bea.com | products | dev2dev | support | askBEA |
|
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
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
Guidelines to Setting Wait for Connection Times
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
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
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 Vendor Extensions to JDBC Interfaces
Sample Code for Accessing Vendor Extensions to JDBC Interfaces
Import Packages to Access Vendor Extensions
Cast the Connection as a Vendor 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
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
Support for Vendor Extensions Between Versions of Weblogic Server Clients and Servers
Tables of Oracle Extension Interfaces and Supported Methods
Testing JDBC Connections and Troubleshooting
Validating a DBMS Connection from the Command Line
Testing a Two-Tier Connection from the Command Line
Validating a Multitier WebLogic JDBC 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