Technical data

xii WebLogic Server Administration Guide
Overview of JDBC Configuration ...........................................................16-7
When to Use a Tx Data Source .........................................................16-8
Drivers Supported for Local Transactions ........................................16-9
Drivers Supported for Distributed Transactions ...............................16-9
Configuring JDBC Drivers for Local Transactions................................16-10
Configuring XA JDBC Drivers for Distributed Transactions................16-14
WebLogic jDriver for Oracle/XA Data Source Properties .............16-17
Additional XA Connection Pool Properties....................................16-20
Configuring Non-XA JDBC Drivers for Distributed Transactions........ 16-20
Non-XA Driver/Single Resource ....................................................16-21
Non-XA Driver/Multiple Resources...............................................16-21
Limitations and Risks When Using a Non-XA Driver in Global
Transactions .............................................................................16-21
Non-XA Connection Pool and Tx Data Source Configuration Example.
16-23
Configuring and Managing JDBC Connection Pools, MultiPools, and
DataSources Using the Administration Console....................................16-24
JDBC Configuration ..............................................................................16-24
Creating the JDBC Objects .............................................................16-25
Assign the JDBC Objects................................................................16-25
Configuring JDBC Connectivity Using the Administration Console......
16-27
Database Passwords in Connection Pool Configuration.................16-28
JDBC Configuration Tasks Using the Command-Line Interface ...16-29
Managing and Monitoring Connectivity................................................16-30
JDBC Management Using the Administration Console .................16-30
JDBC Management Using the Command-Line Interface ...............16-31
Increasing Performance with the Prepared Statement Cache........................16-32
Usage Restrictions for the Prepared Statement Cache ...........................16-33
Calling a Stored Prepared Statement After a Database Change May
Cause Errors.............................................................................16-33
Using setNull In a Prepared Statement ...........................................16-34
Prepared Statements in the Cache May Reserve Database Cursors 16-34
Determining the Proper Prepared Statement Cache Size .......................16-35
Using a Startup Class to Load the Prepared Statement Cache...............16-35