Using WebLogic Type 4 JDBC Drivers
JDBC Specification Compliance
Installation
License Requirements
Supported Databases
Connecting Through Data Sources and Connection Pools
Specifying Connection Properties
Limiting Connection Creation Time with LoginTimeout
Connection Failover with AlternateServers
Connection Failover with MS SQL Server Named Instances
Using AlternateServers with WebLogic Server JDBC Connection Pools
XA Support
Unicode Support
Error Handling
Driver Errors
Database Errors
The DB2 Driver
Database Version Support
DB2 Driver Classes
DB2 URL
DB2 Connection Properties
Sample Connection Pool Configuration
Creating a DB2 Package
Creating a DB2 Package Using dbping
Creating a DB2 Package Using Connection Properties
Notes About Increasing Dynamic Sections in the DB2 Package
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
JTA Support
Large Object (LOB) Support
Performance Workaround for Batch Inserts and Updates
Auto-Generated Keys Support
The Informix Driver
Informix Database Version Support
Informix Driver Classes
Informix URL
Informix Connection Properties
Sample Connection Pool Configuration
Informix Limitation for Prepared Statements
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Blob and Clob Searches
Auto-Generated Keys Support
The MS SQL Server Driver
Driver Class
URL
MS SQL Server Connection Properties
Sample Connection Pool Configuration
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Server-Side Updatable Cursors
Installing Stored Procedures for JTA
Large Object (LOB) Support
Batch Inserts and Updates
Auto-Generated Keys Support
The Oracle Driver
Oracle Database Version Support
Oracle Driver Classes
Oracle URL
Oracle Connection Properties
Sample Connection Pool Configuration
Data Types
Oracle9i Data Type Support
Oracle9i Date/Time Data Types
Oracle9i Date/Time Session Parameters
TIMESTAMP Data Type
TIMESTAMP WITH LOCAL TIME ZONE Data Type
TIMESTAMP WITH TIME ZONE Data Type
XMLType Data Type
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
JTA Support
Batch Inserts and Updates
Auto-Generated Keys Support
The Sybase Driver
Database Version Support
Driver Classes
Sybase URL
Sybase Connection Properties
Sample Connection Pool Configuration
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Large Object (LOB) Support
Batch Inserts and Updates
Auto-Generated Keys Support
Sybase JTA Support
JDBC Support
JDBC Compatibility
Supported Functionality
Array Object
Blob Object
CallableStatement Object
Clob Object
Connection Object
DatabaseMetaData Object
Driver Object
ParameterMetaData
PreparedStatement Object
Ref Object
ResultSet Object
ResultSetMetaData Object
SavePoint Object
Statement Object
Struct Object
XAConnection Object
XADataSource ObjectGetTypeInfo
DB2 Driver
Informix Driver
Oracle Driver
Oracle 9i Only
SQL Server Driver
SQL Server 2000 Only
Sybase Driver
SQL Escape Sequences for JDBC
Date, Time, and Timestamp Escape Sequences
Scalar Functions
Outer Join Escape Sequences
Procedure Call Escape Sequences
Tracking JDBC Calls with WebLogic JDBC Spy
Configuring WebLogic JDBC Connection Pools for WebLogic JDBC Spy
Configuring WebLogic JDBC Spy with a Non-XA Driver
Configuring WebLogic JDBC Spy with an XA Driver
BEA WebLogic JDBC Spy URL Attributes
BEA WebLogic JDBC Spy Log Example