Installing and Using WebLogic jDriver for Oracle

 

Contents

 

1. Introduction

Overview of WebLogic jDrivers

WebLogic jDriver for Oracle

Oracle Shared Libraries

Distributed Transactions with the WebLogic jDriver for Oracle/XA

2. Installing WebLogic jDriver for Oracle

Preparing to Install WebLogic jDriver for Oracle

Checking Software Requirements for WebLogic jDriver for Oracle

Supported Platforms

Requirements for Running JDBC 2.0

Setting Up the Environment for Using WebLogic jDriver for Oracle

Windows NT

Solaris

IBM AIX

HP-UX 11

SGI IRIX

Siemens MIPS

Compaq Tru64 UNIX

Installation Procedures for WebLogic jDriver for Oracle

After Installing WebLogic jDriver for Oracle

Licensing Functionality

Checking Connections to the Oracle Database

Setting Up a Connection Pool

Configuring a Connection Pool with WebLogic Server Software

Using the Connection Pool in an Application

Using IDEs or Debuggers with WebLogic jDrivers

Preparing to Set Up a Development Environment and Use the WebLogic jDriver for Oracle

3. Using WebLogic jDriver for Oracle

Local Versus Distributed Transactions

Importing JDBC Packages

Setting CLASSPATH

Oracle Client Library Versions, URLs, and Driver Class Names

Connecting to an Oracle DBMS

Connecting Using WebLogic Server in a Two-Tier Configuration

Connecting Using WebLogic Server in a Multi-Tier Configuration

Connection Example

Connecting Using a DataSource Object

Setting Properties for WebLogic JDBC Use

About the Connection Object

Setting Autocommit

Making a Simple SQL Query

Inserting, Updating, and Deleting Records

Creating and Using Stored Procedures and Functions

Disconnecting and Closing Objects

Working with ResultSets from Stored Procedures

Row Caching With WebLogic JDBC

Code Example

4. Using WebLogic jDriver for Oracle/XA in Distributed Transactions

Differences Using the WebLogic jDriver for Oracle in XA versus Non-XA Mode

Configuring JDBC XA and Non-XA Resources

JDBC/XA Resources

Non-XA JDBC Resources

Limitations of the WebLogic jDriver for Oracle XA

Implementing Distributed Transactions

Importing Packages

Finding the Data Source via JNDI

Performing a Distributed Transaction

5. Advanced Oracle Features

Allowing Mixed Case Metadata

Data Types

WebLogic Server and Oracle's NUMBER Column

Using Oracle Long Raw Data Types

Waiting on Oracle Resources

Autocommit

Transaction Isolation Levels

Codeset Support

Support for Oracle Array Fetches

Using Stored Procedures

Binding a Parameter to an Oracle Cursor

Notes on Using CallableStatement

DatabaseMetaData Methods

Support for JDBC Extended SQL

Overview of JDBC 2.0 for Oracle

Configuration Required to Support JDBC 2.0

BLOBs and CLOBs

Transaction Boundaries

BLOBs

Connection Properties

Import Statements

Initializing a BLOB Field

Writing Binary Data to a BLOB

Writing a BLOB Object

Reading BLOB Data

Other Methods

CLOBs

Codeset Support

Initializing a CLOB Field

Writing ASCII Data to a CLOB

Writing Unicode Data to a CLOB

Writing CLOB Objects

Reading CLOB Data

Other Methods

Character and ASCII Streams

Unicode Character Streams

ASCII Character Streams

Batch Updates

Using Batch Updates

Clearing the Batch

Update Counts

New Date Methods