![]() |
![]() |
|
Programming WebLogic JDBC
Contents
1. Introduction to WebLogic JDBC
WebLogic Server JDBC Two-Tier Drivers
WebLogic jDriver for Microsoft SQL Server
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 Class Definitions
2. Administration and Configuration for WebLogic JDBC
3. 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
4. Configuring WebLogic JDBC Features
Setting Up WebLogic Server to Use a DataSource
Obtaining a Client Connection Using a DataSource
Creating a Connection Pool at Startup
Creating a Connection Pool Dynamically
Retrieving information About a Pool
Shutting Down a Connection Pool
Choosing the MultiPool Algorithm
Guidelines to Setting Wait For Connection Times
5. 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
Import the Following Packages:
Using a JNDI Lookup to Obtain the Connection
Using Only the WebLogic RMI Driver to Obtain the Connection
Implementing with the JTS Driver
Using the WebLogic Pool Driver
6. Using Third-Party Drivers with WebLogic Server
Overview of Third-Party JDBC Drivers
Setting the Environment for Your Third-Party Driver
CLASSPATH for Third-Party Driver on Windows NT
CLASSPATH for Third-Party Driver on Unix
Getting a Connection with Your Third-Party Driver
Using Connection Pools With a Third-Party Driver
Create the Connection Pool and DataSource
Using a JNDI Lookup to Obtain the Connection
Setting a Direct Connection Using the Oracle Thin Driver
Setting a Direct Connection Using the Sybase jConnect Driver
dbKona in a Multitier Configuration
How dbKona and a JDBC Driver interact
How dbKona and WebLogic Events Can interact
The dbKona Objects and Their Classes
Data Container Objects in dbKona
Data Description Objects In dbKona
Miscellaneous Objects in dbKona
Step 2. Setting Properties For Making a Connection
Step 3. Making a Connection to the DBMS
Preparing a Query, Retrieving, and Displaying Data
Step 1. Setting Parameters for Data Retrieval
Step 2. Creating a DataSet for the Query Results
Step 4. Examining a TableDataSet's Schema
Step 5. Examining the Data with htmlKona
Step 6. Displaying the Results with htmlKona
Step 7. Closing the DataSet and the Connection
Using a SelectStmt Object To Form a Query
Step 1. Setting SelectStmt Parameters
Step 2. Using QBE to Refine the Parameters
Modifying DBMS Data With a SQL Statement
Step 1. Writing SQL Statements
Step 2. Executing Each SQL Statement
Step 3. Displaying the Results with htmlKona
Modifying DBMS Data With a KeyDef
Step 1. Creating a KeyDef and Building Its Attributes
Step 2. Creating a TableDataSet with a KeyDef
Step 3. Inserting a Record into the TableDataSet
Step 4. Updating a Record In the TableDataSet
Step 5. Deleting a Record from the TableDataSet
Step 6. More on Saving the TableDataSet
Using a JDBC PreparedStatement with dbKona
Using Stored Procedures With dbKona
Step 1. Creating a Stored Procedure
Using Byte Arrays For Images and Audio
Step 1. Retrieving and Displaying Image Data
Step 2. Inserting An Image Into a Database
Using dbKona For Oracle Sequences
Constructing a dbKona Sequence Object
Creating and Destroying Sequences on an Oracle Server from dbKona
9. Testing JDBC Connections and Troubleshooting
Validating a DBMS 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
Troubleshooting Problems with Shared Libraries on UNIX
|
Copyright © 2000 BEA Systems, Inc. All rights reserved.
|