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
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
Performance Considerations
CatalogIncludesSynonyms
CatalogSchema
InsensitiveResultSetBufferSize
MaxPooledStatements
ResultSetMetaDataOptions
SendStreamAsBlob
StripNewLines
UseCurrentSchema
Setting the locationName on AS/400
Creating a DB2 Package
Creating a DB2 Package Using dbping
Creating a DB2 Package Using Connection Properties
Example for DB2 for Linux/UNIX/Windows:
Example for DB2 for z/OS and iSeries:
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
Insert and Update Statements
Select Statements
ResultSet Metadata Support
Rowset Support
Auto-Generated Keys Support
Known Issues
The Informix Driver
Informix Database Version Support
Informix Driver Classes
Informix URL
Informix Connection Properties
Informix Limitation for Prepared Statements
Performance Considerations
InsensitiveResultSetBufferSize
MaxPooledStatements
ResultSetMetaDataOptions
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Parameter Metadata Support
Insert and Update Statements
Select Statements
ResultSet MetaData Support
Rowset 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
Performance Considerations
InsensitiveResultSetBufferSize
MaxPooledStatements
ResultSetMetaDataOptions
SelectMethod
SendStringParametersAsUnicode
UseServerSideUpdatableCursors
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Server-Side Updatable Cursors
Installing Stored Procedures for JTA
To install stored procedures for JTA:
Large Object (LOB) Support
Batch Inserts and Updates
Parameter Metadata Support
Insert and Update Statements
Select Statements
ResultSet MetaData Support
Rowset Support
Auto-Generated Keys Support
The Oracle Driver
Oracle Database Version Support
Oracle Driver Classes
Oracle URL
Oracle Connection Properties
Performance Considerations
BatchPerformanceWorkaround
CatalogOptions
InsensitiveResultSetBufferSize
MaxPooledStatements
ResultSetMetaDataOptions
ServerType
WireProtocolMode
Using tnsnames.ora Files
Connecting to the Database
Configuring the tnsnames.ora File
Data Types
Oracle Date/Time Data Types
TIMESTAMP WITH LOCAL TIME ZONE Data Type
TIMESTAMP WITH TIME ZONE Data Type
XMLType Data Type
REF CURSOR Data Type Support
Character Set Conversion
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Batch Inserts and Updates
Parameter Metadata Support
Insert and Update Statements
Select Statements
ResultSet MetaData Support
Rowset Support
Auto-Generated Keys Support
The Sybase Driver
Database Version Support
Driver Classes
Sybase URL
Sybase Connection Properties
Performance Considerations
BatchPerformanceWorkaround
InsensitiveResultSetBufferSize
MaxPooledStatements
PrepareMethod
ResultSetMetaDataOptions
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Large Object (LOB) Support
Batch Inserts and Updates
Parameter Metadata Support
ResultSet MetaData Support
Rowset Support
Auto-Generated Keys Support
NULL Values
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 and Oracle 10g 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