Contents for Programming WebLogic JDBC

 

 

Introduction to WebLogic JDBC

Overview of JDBC

Overview of JDBC Drivers

Types of JDBC Drivers

Table of Drivers

Description of JDBC Drivers

WebLogic Server JDBC Two-Tier Drivers

WebLogic Server JDBC Multitier Drivers

Third-Party Drivers

Overview of Connection Pools

Using Connection Pools with Server-side Applications

Using Connection Pools with Client-side Applications

Overview of MultiPools

Choosing the MultiPool Algorithm

Overview of Clustered JDBC

Overview of DataSources

JDBC API

WebLogic JDBC Interface Definitions

JDBC 2.0

Limitations

Platforms

 

Administration and Configuration for WebLogic JDBC

Configuring JDBC

Configuring Connection Pools

Configuring MultiPools

Configuring DataSources and TxDataSources

Monitoring JDBC Connectivity

 

Performance Tuning Your JDBC Application

Overview of JDBC Performance

WebLogic Performance-Enhancing Features

How Connection Pools Enhance Performance

Caching 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

 

Configuring WebLogic JDBC Features

Using Connection Pools

Advantages to Using Connection Pools

Connection Pool Fail-Over Requirements

Creating a Connection Pool at Startup

Permissions

Connection Pool Limitation

Creating a Connection Pool Dynamically

Dynamic Connection Pool Sample Code

Managing Connection Pools

Using MultiPools

Choosing the MultiPool Algorithm

MultiPool Fail-Over Limitations and Requirements

Guidelines to Setting Wait for Connection Times

Messages and Error Conditions

Configuring and Using DataSources

Importing Packages to Access DataSource Objects

Obtaining a Client Connection Using a DataSource

 

Using WebLogic Multitier JDBC Drivers

Overview of WebLogic Multitier Drivers

Using the WebLogic RMI Driver

Limitations When Using the WebLogic RMI Driver

Setting Up WebLogic Server to Use the WebLogic RMI Driver

Setting Up the Client to Use the WebLogic Server

Row Caching with the WebLogic RMI Driver

Using the WebLogic JTS Driver

Implementing with the JTS Driver

Using the WebLogic Pool Driver

 

Using Third-Party Drivers with WebLogic Server

Overview of Third-Party JDBC Drivers

Limitations

Setting the Environment for Your Third-Party Driver

Updating Oracle Thin Driver

Updating Sybase jConnect Driver

Installing and Using the IBM Informix JDBC Driver

Getting a Connection with Your Third-Party Driver

Using Connection Pools with a Third-Party Driver

Getting a Physical Connection from a Connection Pool

Obtaining a Direct (Non-pooled) JDBC Connection

Oracle Thin Driver Extensions

Sample Code for Accessing Oracle Extensions to JDBC Interfaces

Sample Code for Accessing Oracle Blob/Clob Interfaces

Tables of Oracle Interfaces

 

Using dbKona

Introduction to dbKona

The dbKona Architecture

The dbKona API

The dbKona API Reference

The dbKona Objects and Their Classes

Entity Relationships

Implementing with dbKona

Accessing a DBMS with dbKona

Preparing a Query, Retrieving, and Displaying Data

Using a SelectStmt Object to Form a Query

Modifying DBMS Data with a SQL Statement

Modifying DBMS Data with a KeyDef

Using a JDBC PreparedStatement with dbKona

Using Stored Procedures with dbKona

Using Byte Arrays for Images and Audio

Using dbKona for Oracle Sequences

 

Testing JDBC Connections and Troubleshooting

Testing Connections

Validating a DBMS Connection from the Command Line

How to Test a Two-Tier Connection from the Command Line

How to Validate a Multitier WebLogic JDBC Connection from the Command Line

Troubleshooting JDBC

Troubleshooting JDBC Connections

SEGVs with JDBC and Oracle Databases

Out-of-Memory Errors

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

Solaris

HP-UX