Installing and Using WebLogic jDriver for Oracle


	BEA Home \| Events \| Solutions \| Partners \| Products \| Services \| Download \| Developer Center \| WebSUPPORT
	http://www.oracle.com/technology/documentation/index.html \| Site Map \| Search \| Download Documentation \| Contact \| Glossary

\| WebLogic Server Doc Home \| WebLogic jDriver for Oracle \| Previous Topic \| Next Topic \| Contents \| View as PDF

Installing and Using WebLogic jDriver for Oracle

Introduction

Overview of WebLogic jDrivers

WebLogic jDriver for Oracle

Oracle Shared Libraries

Distributed Transactions with the WebLogic jDriver for Oracle/XA

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

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

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

Unsupported JDBC 2.0 Methods

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

Advanced Oracle Features

Allowing Mixed Case Metadata

WebLogic Server and Oracle's NUMBER Column

Using Oracle Long Raw Data Types

Waiting on Oracle Resources

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

Connection Properties

Import Statements

Initializing a BLOB Field

Writing Binary Data to a BLOB

Writing a BLOB Object

Updating a CLOB Value Using a Prepared Statement

Reading BLOB Data

Codeset Support

Initializing a CLOB Field

Writing ASCII Data to a CLOB

Writing Unicode Data to a CLOB

Writing CLOB Objects

Reading CLOB Data

Character and ASCII Streams

Unicode Character Streams

ASCII Character Streams

Using Batch Updates

Clearing the Batch

New Date Methods

Copyright © 2001 BEA Systems, Inc. All rights reserved.
Required browser: Netscape 4.0 or higher, or Microsoft Internet Explorer 4.0 or higher.