|
 |
| e-docs > WebLogic Server > Programming WebLogic JDBC |
|
Programming WebLogic JDBC
|
Using JDBC Drivers with WebLogic Server
Table of WebLogic Server JDBC Drivers
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
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
Notes About Refreshing Connections in a JDBC Connection Pool
JDBC Connection Pool Testing Enhancements
Minimizing Connection Test Delay After Database Connectivity Loss
Minimizing Connection Request Delay After Connection Test Failures
Minimizing Connection Request Delay with SecondsToTrustAnIdlePoolConnection
Creating a Connection Pool Dynamically
Dynamic Connection Pool Sample Code
Look Up the Administration MBeanHome
Create the Connection Pool MBean
Set the Connection Pool Properties
Removing a Dynamic Connection Pool and DataSource
Retrieving Information About a Pool
Shutting Down a Connection Pool
Using weblogic.jdbc.common.JdbcServices and weblogic.jdbc.common.Pool Classes (Deprecated)
Application-Scoped JDBC Connection Pools
Configuring and Using MultiPools
Choosing the MultiPool Algorithm
MultiPool Failover Enhancements
Connection Request Routing Enhancements When a Connection Pool Fails
Automatic Re-enablement on Recovery of a Failed Connection Pool within a MultiPool
Enabling Failover for Busy Connection Pools in a MultiPool
Controlling MultiPool Failover with a Callback
Controlling MultiPool Failback with a Callback
MultiPool Fail-Over Limitations and Requirements
Test Connections on Reserve to Enable Fail-Over
No Fail-Over for In-Use Connections
Configuring and Using DataSources
Importing Packages to Access DataSource Objects
Obtaining a Client Connection Using a DataSource
Performance Tuning Your JDBC Application
WebLogic Performance-Enhancing Features
How Connection Pools Enhance Performance
Caching Prepared 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
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
Using WebLogic Multitier JDBC Drivers
Setting Up WebLogic Server to Use the WebLogic RMI Driver
Sample Client Code for Using the RMI Driver
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
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
Package Change for Oracle Thin Driver 9.x and 10g
Character Set Support with nls_charset12.zip
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
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 Oracle Extensions with the Oracle Thin Driver
Limitations When Using Oracle JDBC Extensions
Sample Code for Accessing Oracle Extensions to JDBC Interfaces
Import Packages to Access Oracle Extensions
Retrieve the Default Row Prefetch Value
Updating ARRAYs in the Database
Using Oracle Array Extension Methods
Using OracleStruct Extension Methods
Using STRUCTs to Update Objects in the Database
Creating Objects in the Database
Automatic Buffering for STRUCT Attributes
Using OracleRef Extension Methods
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
Updating a CLOB Value Using a Prepared Statement
Programming with Oracle Virtual Private Databases
Tables of Oracle Extension Interfaces 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. Set Properties for Making a Connection
Step 3. Make a Connection to the DBMS
Preparing a Query, Retrieving, and Displaying Data
Step 1. Set Parameters for Data Retrieval
Step 2. Create a DataSet for the Query Results
Step 4. Examine a TableDataSet's Schema
Step 5. Examine the Data with htmlKona
Step 6. Display the Results with htmlKona
Step 7. Close 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
Other Problems with Oracle on UNIX
Thread-related Problems on UNIX
Troubleshooting Problems with Shared Libraries on UNIX
Incorrectly Set File Permissions
Using Mircrosoft SQL with Nested Triggers
|
|
|
|
||
 |
|
|
 |
 |
 |
|
||
