Using the JDBC Drivers

 

This document contains programming and reference information for the JDBC drivers that are provided with the BEA WebLogic Enterprise software.

This document is intended for programmers and system administrators who need to create and maintain transactional, scalable WLE applications.

This document covers the following topics:

 

Using the WebLogic Enterprise JDBC/XA Drivers

Before You Begin

Supported Platforms

Adding the JAR Files to Your CLASSPATH

Adding Locale to Your CLASSPATH

Shared Libraries and Dynamic Link Libraries

Requirements for Making a Connection to a DBMS

About the Sample Code

About the JDBC API

Setting Data Source Properties

Administration Steps

Use buildXAJS to Create an XA Version of JavaServer

Use buildtms to Create a Transaction Manager Server Load Module for Oracle

Define the Database Open Information

Define JavaServerXA Parameters

Identify the Driver Class and Connection Pool Characteristics

Programming Steps

Import the Required API Packages

Initialize JavaServerXA and Get the Pool Name

Use a JNDI Lookup to Create a Pool of Connections

Get Database Connections from the Pool

 

Using JDBC Connection Pooling

About JDBC Connection Pooling

About the JDBC Drivers and Connection Pooling

UBBCONFIG Parameters for Connection Pooling

Sample UBBCONFIG File for Connection Pooling

JDBCCONNPOOLS Parameter Values

Encrypting DBPASSWORD and PROPS

Displaying Information About JDBC Connection Pools

T_JDBCCONNPOOLS MIB Class

API Characteristics

Application Level API

System Level API for the JNDI Service Provider

System Level API for JDBC drivers

Obtaining Connections from a WebLogic Enterprise Connection Pool

An Application's View of the Connection Lifecycle

The DataSource Interface

 

Using the jdbcKona Drivers

API Support

Platforms Supported by the jdbcKona Drivers

Adding the JAR Files to Your CLASSPATH

jdbcKona/Oracle Shared Libraries and Dynamic Link Libraries

Requirements for Making a Connection to a Database Management System (DBMS)

Support for JDBC Extended SQL

The JDBC API with WebLogic Extensions

Implementing a WebLogic Enterprise Java Application Using the jdbcKona Drivers

Importing Packages

Setting Properties for Connecting to the DBMS

Connecting to the DBMS

Making a Simple SQL Query

Inserting, Updating, and Deleting Records

Creating and Using Stored Procedures and Functions

Disconnecting and Closing Objects

Code Example

 

Using the jdbcKona/Oracle Drivers

Data Type Mapping

Connecting a jdbcKona/Oracle Driver to an Oracle DBMS

Method 1

Method 2

Other Properties You Can Set for the jdbcKona/Oracle Driver

General Notes

Waiting for Oracle DBMS Resources

Autocommit

Using Oracle Blobs

Support for Oracle Array Fetches

Using Stored Procedures

Syntax for Stored Procedures in the jdbcKona/Oracle Driver

Binding a Parameter to an Oracle Cursor

Using CallableStatement

DatabaseMetaData Methods

jdbcKona/Oracle and the Oracle NUMBER Column

 

jdbcKona Extensions to the JDBC 1.22 API