| products | dev2dev | support | askBEA
 Download Docs   Site Map   Glossary 

Programming WebLogic JDBC

 Previous Next Contents View as PDF  

Introduction to WebLogic JDBC

Overview of JDBC

Using JDBC Drivers with WebLogic Server

Types of JDBC Drivers

Table of WebLogic Server JDBC Drivers

WebLogic Server JDBC Two-Tier Drivers

WebLogic jDriver for Oracle

WebLogic jDriver for Microsoft SQL Server

WebLogic Server JDBC Multitier Drivers

WebLogic RMI Driver

WebLogic Pool Driver

WebLogic JTS Driver

Third-Party Drivers

Sybase jConnect Driver

Oracle Thin Driver

Overview of Connection Pools

Using Connection Pools with Server-side Applications

Using Connection Pools with Client-side Applications

Overview of MultiPools

Overview of Clustered JDBC

Overview of DataSources


JDBC 2.0


Configuring and Administering WebLogic JDBC

Configuring and Using Connection Pools

Advantages to Using Connection Pools

Creating a Connection Pool at Startup

Avoiding Server Lockup with the Correct Number of Connections

Database Passwords in Connection Pool Configuration


Creating a Connection Pool Dynamically

Dynamic Connection Pool Sample Code

Import Packages

Look Up the Administration MBeanHome

Get the Server MBean

Create the Connection Pool MBean

Set the Connection Pool Properties

Add the Target

Create a DataSource

Removing a Dynamic Connection Pool and DataSource

Managing Connection Pools

Retrieving Information About a Pool

Disabling a Connection Pool

Shrinking a Connection Pool

Shutting Down a Connection Pool

Resetting a Pool

Using weblogic.jdbc.common.JdbcServices and weblogic.jdbc.common.Pool Classes (Deprecated)

Application-Scoped JDBC Connection Pools

Configuring and Using MultiPools

MultiPool Features

Choosing the MultiPool Algorithm

High Availability

Load Balancing

Guidelines to Setting Wait for Connection Times

Messages and Error Conditions


Capacity Issues

Configuring and Using DataSources

Importing Packages to Access DataSource Objects

Obtaining a Client Connection Using a DataSource

Code Examples

JDBC Data Source Factories

Performance Tuning Your JDBC Application

Overview of JDBC Performance

WebLogic Performance-Enhancing Features

How Connection Pools Enhance Performance

Caching Statements and Data

Designing Your Application for Best Performance

1. Process as Much Data as Possible Inside the Database

2. Use Built-in DBMS Set-based Processing

3. Make Your Queries Smart

4. Make Transactions Single-batch

5. Never Have a DBMS Transaction Span User Input

6. Use In-place Updates

7. Keep Operational Data Sets Small

8. Use Pipelining and Parallelism

Using WebLogic Multitier JDBC Drivers

Using the WebLogic RMI Driver

Setting Up WebLogic Server to Use the WebLogic RMI Driver

Sample Client Code for Using the RMI Driver

Import the Required Packages

Get the Database Connection

Using a JNDI Lookup to Obtain the Connection

Using Only the WebLogic RMI Driver to Obtain a Database Connection

Row Caching with the WebLogic RMI Driver

Important Limitations for Row Caching with the WebLogic RMI Driver

Using the WebLogic JTS Driver

Sample Client Code for Using the JTS Driver

Using the WebLogic Pool Driver

Using Third-Party Drivers with WebLogic Server

Overview of Third-Party JDBC Drivers

Setting the Environment for Your Third-Party JDBC Driver

CLASSPATH for Third-Party JDBC Driver on Windows

CLASSPATH for Third-Party JDBC Driver on UNIX

Changing or Updating the Oracle Thin Driver

Installing and Using the IBM Informix JDBC Driver

Connection Pool Attributes when using the IBM Informix JDBC Driver

Programming Notes for the IBM Informix JDBC Driver

Installing and Using the SQL Server 2000 Driver for JDBC from Microsoft

Installing the MS SQL Server JDBC Driver on a Windows System

Installing the MS SQL Server JDBC Driver on a Unix System

Connection Pool Attributes when using the Microsoft SQL Server Driver for JDBC

Getting a Connection with Your Third-Party Driver

Using Connection Pools with a Third-Party Driver

Creating the Connection Pool and DataSource

Using a JNDI Lookup to Obtain the Connection

Getting a Physical Connection from a Connection Pool

Code Sample for Getting a Physical Connection

Limitations for Using a Physical Connection

Using Vendor Extensions to JDBC Interfaces

Sample Code for Accessing Vendor Extensions to JDBC Interfaces

Import Packages to Access Vendor Extensions

Get a Connection

Cast the Connection as a Vendor Connection

Use Vendor Extensions

Using Oracle Extensions with the Oracle Thin Driver

Limitations When Using Oracle JDBC Extensions

Sample Code for Accessing Oracle Extensions to JDBC Interfaces

Programming with ARRAYs

Import Packages to Access Oracle Extensions

Establish the Connection

Getting an ARRAY

Updating ARRAYs in the Database

Using Oracle Array Extension Methods

Programming with STRUCTs

Getting a STRUCT

Using OracleStruct Extension Methods

Getting STRUCT Attributes

Using STRUCTs to Update Objects in the Database

Creating Objects in the Database

Automatic Buffering for STRUCT Attributes

Programming with REFs

Getting a REF

Using OracleRef Extension Methods

Getting a Value

Updating REF Values

Creating a REF in the Database

Programming with BLOBs and CLOBs

Query to Select BLOB Locator from the DBMS

Declare the WebLogic Server java.sql Objects

Begin SQL Exception Block

Updating a CLOB Value Using a Prepared Statement

Support for Vendor Extensions Between Versions of Weblogic Server Clients and Servers

Tables of Oracle Extension Interfaces and Supported Methods

Testing JDBC Connections and Troubleshooting

Monitoring JDBC Connectivity

Validating a DBMS Connection from the Command Line

Testing a Two-Tier Connection from the Command Line




Validating a Multitier WebLogic JDBC Connection from the Command Line




Troubleshooting JDBC

JDBC Connections



Codeset Support

Other Problems with Oracle on UNIX

Thread-related Problems on UNIX

Closing JDBC Objects

Troubleshooting Problems with Shared Libraries on UNIX

WebLogic jDriver for Oracle



Incorrectly Set File Permissions

Incorrect SHLIB_PATH


Back to Top Previous Next