Contents for Programming WebLogic JDBC
WebLogic Server JDBC Two-Tier Drivers
WebLogic Server JDBC Multitier Drivers
Using Connection Pools with Server-side Applications
Using Connection Pools with Client-side Applications
Choosing the MultiPool Algorithm
WebLogic JDBC Interface Definitions
Administration and Configuration for WebLogic JDBC
Configuring DataSources and TxDataSources
Performance Tuning Your JDBC Application
WebLogic Performance-Enhancing Features
How Connection Pools Enhance Performance
Designing Your Application for Best Performance
1. Process as Much Data as Possible Inside the Database
2. Use Built-in DBMS Set-based Processing
4. Make Transactions Single-batch
5. Never Have a DBMS Transaction Span User Input
7. Keep Operational Data Sets Small
8. Use Pipelining and Parallelism
Configuring WebLogic JDBC Features
Advantages to Using Connection Pools
Connection Pool Fail-Over Requirements
Creating a Connection Pool at Startup
Creating a Connection Pool Dynamically
Dynamic Connection Pool Sample Code
Choosing the MultiPool Algorithm
MultiPool Fail-Over Limitations and Requirements
Guidelines to Setting Wait for Connection Times
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
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
Implementing with 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 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
Sample Code for Accessing Oracle Extensions to JDBC Interfaces
Sample Code for Accessing Oracle Blob/Clob Interfaces
The dbKona Objects and Their Classes
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
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 Connections
SEGVs with JDBC and Oracle Databases
Other Problems with Oracle on UNIX
Thread-related Problems on UNIX