Introduction

 

This document explains how to install and use BEA's JDBC driver for the Oracle Database Management System (DBMS) with WebLogic Server. It also describes the new feature, MultiPools, added to WebLogic Server in Version 6.

We assume you are familiar with Java, general DBMS concepts, and Structured Query Language (SQL).

This section discusses the following topics:

• Overview of WebLogic jDrivers

• WebLogic jDriver for Oracle

Overview of WebLogic jDrivers

BEA offers three WebLogic jDrivers for use with the WebLogic Server software:

• Type 2 native JDBC driver for Oracle that includes distributed transaction capability

• Type 4 JDBC drivers for Informix and Microsoft SQL Server

Type-2 drivers use client libraries supplied by a database vendor, while Type-4 drivers are pure-Java; they connect to the database server at the wire level without vendor-supplied client libraries.

WebLogic jDriver for Oracle

WebLogic jDriver for Oracle, a Type 2 JDBC driver for the Oracle DBMS, is provided with the WebLogic Server software. To use this driver, you must install a complete Oracle client, including all required libraries, on the machine that will be the client to the Oracle DBMS. This Oracle client installation must contain vendor-supplied client libraries and associated files required by WebLogic Server.

Oracle Shared Libraries

The WebLogic Server distribution includes a choice of several BEA-supplied native libraries for WebLogic Server. Which library you choose depends on which Oracle client version is installed on your client machine and which version of the Oracle API you will use to access your Oracle server. Before you can install this driver, you must include both the BEA-supplied native library and the Oracle-supplied client libraries in your the client's PATH (Windows NT) or shared library path (UNIX). For more information, see Installing WebLogic jDriver for Oracle.

Distributed Transactions with the WebLogic jDriver for Oracle/XA

WebLogic Server provides a multithreaded JDBC/XA driver for Oracle Corporations Oracle8i database management system. The WebLogic jDriver for Oracle/XA is the transaction-enabled version of WebLogic jDriver for Oracle. The WebLogic jDriver for Oracle/XA fully supports XA, the bidirectional system-level interface between a transaction manager and a resource manager of the X/Open Distributed Transaction Processing (DTP) model.