|
|
|
|
|
|
| | | |
Programming 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 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
Notes About Refreshing Connections in a JDBC Connection Pool
Creating a Connection Pool Dynamically
Dynamic Connection Pool Sample Code
Use JNDI to Retrieve the JdbcServices Object
Retrieving Information About a Pool
Shutting Down a Connection Pool
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
Using a JNDI Lookup to Obtain the Connection
Using Only the WebLogic RMI Driver to Obtain the Connection
Row Caching with the WebLogic RMI Driver
Important Limitations to Using 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
CLASSPATH for Third-Party Driver on Windows
CLASSPATH for Third-Party Driver on UNIX
Using the Oracle 10g Thin Driver
Package Change for Oracle Thin Driver 9.x and 10g
Updating Sybase jConnect 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
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
Obtaining a Direct (Non-pooled) JDBC Connection
Obtaining a Direct Connection Using the Oracle Thin Driver
Obtaining a Direct Connection Using the Sybase jConnect Driver
Sample Code for Accessing Oracle Extensions to JDBC Interfaces
Import Packages to Access Oracle Extensions
Retrieve the Default Row Prefetch Value
Sample Code for Accessing Oracle Blob/Clob Interfaces
Import Packages to Access Blob and Clob Extensions
Query to Select Blob Locator from the DBMS
Declare the WebLogic Server java.sql Objects
Updating a CLOB Value Using a Prepared Statement
Oracle Extensions and Supported Methods
Oracle Blob/Clob Extensions and Supported Methods
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
EventfulTableDataSet (Deprecated)
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 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
Checking Record Status Before Saving
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
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
Troubleshooting Problems with Shared Libraries on UNIX
Incorrectly Set File Permissions
|
|
|
|
|
Copyright © 2001 BEA Systems, Inc. All rights reserved.
|