Contents for WebLogic Type 4 JDBC Drivers
Introduction and Roadmap
Document Scope and Audience
Guide to this Document
Related Documentation
JDBC Samples and Tutorials
Avitek Medical Records Application (MedRec) and Tutorials
JDBC Examples in the WebLogic Server Distribution
New and Changed JDBC Features in This Release
Using WebLogic Type 4 JDBC Drivers
JDBC Specification Compliance
Installation
License Requirements
Supported Databases
Connecting Through WebLogic JDBC Data Sources
Specifying Connection Properties
Limiting Connection Creation Time with LoginTimeout
Required Permissions for the Java Security Manager
Permissions for Establishing Connections
Granting Access to Java Properties
Granting Access to Temporary Files
Granting Access to Oracle tnsnames.ora Files
XA Support
Unicode Support
Error Handling
Driver Errors
Database Errors
The DB2 Driver
Database Version Support
DB2 Driver Classes
DB2 URL
DB2 Connection Properties
Setting the locationName on AS/400
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
Using a Non-Default Schema for Catalog Methods
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
JTA Support
Large Object (LOB) Support
Performance Workaround for Batch Inserts and Updates
Parameter Metadata Support
Auto-Generated Keys Support
The Informix Driver
Informix Database Version Support
Informix Driver Classes
Informix URL
Informix Connection Properties
Informix Limitation for Prepared Statements
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Parameter Metadata Support
Blob and Clob Searches
FILETOBLOB Feature Support
Auto-Generated Keys Support
The MS SQL Server Driver
SQL Server Database Version Support
Driver Class
URL
Connecting to Named Instances
SQL Server Connection Properties
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
Parameter Metadata Support
Auto-Generated Keys Support
The Oracle Driver
Oracle Database Version Support
Oracle Driver Classes
Oracle URL
Oracle Connection Properties
Using tnsnames.ora Files
Connecting to the Database
Configuring the tnsnames.ora File
Data Types
Oracle Date/Time Data Types
Date/Time Session Parameters
TIMESTAMP Data Type
TIMESTAMP WITH LOCAL TIME ZONE Data Type
TIMESTAMP WITH TIME ZONE Data Type
XMLType Data Type
REF CURSOR Data Type Support
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Batch Inserts and Updates
Parameter Metadata Support
Auto-Generated Keys Support
Connection Failover with the Oracle Driver
Specifying Primary and Alternate Servers
Using the AlternateServers Property
Specifying Connection Retry
Connection Failover Properties
Connection Failover with the Oracle Driver
Specifying Primary and Alternate Servers
Using the AlternateServers Property
Specifying Connection Retry
Connection Failover Properties
The Sybase Driver
Database Version Support
Driver Classes
Sybase URL
Sybase Connection Properties
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Large Object (LOB) Support
Batch Inserts and Updates
Parameter Metadata Support
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 Object
PreparedStatement Object
Ref Object
ResultSet Object
ResultSetMetaData Object
SavePoint Object
Statement Object
Struct Object
XAConnection Object
XADataSource Object
XAResource Object
GetTypeInfo
DB2 Driver
Informix Driver
Oracle Driver
Oracle9i Only
Oracle10g Only
SQL Server Driver
Microsoft 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 Data Sources for WebLogic JDBC Spy
BEA WebLogic JDBC Spy URL Attributes
BEA WebLogic JDBC Spy Log Example