BEA Logo BEA WebLogic Enterprise Release 5.0

  Corporate Info  |  News  |  Solutions  |  Products  |  Partners  |  Services  |  Events  |  Download  |  How To Buy

 

   WLE Doc Home   |   JDBC & Related Topics   |   Previous   |   Next   |   Contents   |   Index

Using the JDBC Drivers

This document contains programming and reference information for the JDBC drivers that are provided with the BEA WebLogic Enterprise (sometimes referred to as WLE) 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 WLE JDBC/XA Driver

Before You Begin

   Platforms Supported by the JDBC/XA Driver

   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, Including the Connection Pool Name

      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 WLE 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 WLE 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 Driver

Data Type Mapping

Connecting the 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

 

Using the jdbcKona/ MSSQLServer4 Driver

Connecting to an SQL Server with the jdbcKona/MSSQLServer4 Driver

   Method 1

   Method 2

   Method 3

Setting Properties for Microsoft SQL
Server 7

Using the jdbcKona/MSSQLServer4 Driver in Java Development Environments

JDBC Extensions and Limitations

   Support for JDBC Extended SQL

   cursorName Method Not Supported

   java.sql.TimeStamp Limitations

   Querying Metadata

   Changing autoCommit Mode

   Statement.executeWriteText() Methods Not Supported

   Sharing a Connection Object in Multithreaded Applications

   EXECUTE Keyword with Stored Procedures

 

jdbcKona Extensions to the JDBC 1.22 API