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
Supported Databases
Connecting Through WebLogic JDBC Data Sources
Specifying Connection Properties
Limiting Connection Creation Time with LoginTimeout
Using IP Addresses
Using Security
Authentication
Kerberos Authentication Requirements
NTLM Authentication Requirements
Data Encryption Across the Network
SSL Encryption
SSL Client Authentication (Oracle and DB2 Drivers)
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
Permissions for Kerberos Authentication
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
EncryptionMethod
InsensitiveResultSetBufferSize
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
Returning and Inserting/Updating XML Data
Returning XML Data
Inserting/Updating XML Data
Authentication
Using the AuthenticationMethod Property
Configuring User ID/Password Authentication
To configure user ID/password authentication:
Configuring Kerberos Authentication
Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
Obtaining a Kerberos Ticket Granting Ticket
Configuring Client Authentication
Data Encryption
Configuring SSL Encryption
SSL Connection Properties
Non-Default Schemas for Catalog Methods
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
JTA Support
Large Object (LOB) Support
Batch Inserts and Updates
Parameter Metadata Support
Insert and Update Statements
Select Statements
Stored Procedures
ResultSet Metadata Support
Rowset Support
Auto-Generated Keys Support
Database Connection Property
DatabaseName Connection Property
New Data Types
SQL Procedures for z/OS
IPv6 Support
The Informix Driver
Informix Database Version Support
Informix Driver Classes
Informix URL
Informix Connection Properties
Informix Limitation for Prepared Statements
Performance Considerations
FetchBufferSize
InsensitiveResultSetBufferSize
ResultSetMetaDataOptions
Data Types
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Parameter Metadata Support
Insert and Update Statements
Select Statements
Stored Procedures
ResultSet MetaData Support
Rowset Support
Blob and Clob Searches
FILETOBLOB Feature Support
Auto-Generated Keys Support
Database Connection Property
The MS SQL Server Driver
SQL Server Database Version Support
Driver Class
Microsoft SQL Server URL
Connecting to Named Instances
SQL Server Connection Properties
Performance Considerations
EncryptionMethod
InsensitiveResultSetBufferSize
LongDataCacheSize
PacketSize
ResultSetMetaDataOptions
SelectMethod
SendStringParametersAsUnicode
SnapshotSerializable
UseServerSideUpdatableCursors
Data Types
Returning and Inserting/Updating XML Data
Returning XML Data
Inserting/Updating XML Data
Authentication
Using the AuthenticationMethod Property
Configuring SQL Server Authentication
Configuring Kerberos Authentication
Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
Obtaining a Kerberos Ticket Granting Ticket
Configuring NTLM Authentication
Data Encryption
Using SSL with Microsoft SQL Server
Configuring SSL Encryption
DML with Results (Microsoft SQL Server 2005)
SQL Escape Sequences
Isolation Levels
Using the Snapshot Isolation Level (Microsoft SQL Server 2005 Only)
Using Scrollable Cursors
Server-Side Updatable Cursors
Installing Stored Procedures for JTA
To install stored procedures for JTA:
Distributed Transaction Cleanup
Transaction Timeout
Explicit Transaction Cleanup
Large Object (LOB) Support
Batch Inserts and Updates
Parameter Metadata Support
Insert and Update Statements
Select Statements
Stored Procedures
ResultSet MetaData Support
Rowset Support
Auto-Generated Keys Support
Null Values
Database Connection Property
The Oracle Driver (Deprecated)
Oracle Database Version Support
Oracle Driver Classes
Oracle URL
Oracle Connection Properties
Performance Considerations
BatchPerformanceWorkaround
CatalogOptions
CommitBehavior
EncryptionMethod
InsensitiveResultSetBufferSize
ResultSetMetaDataOptions
ServerType
WireProtocolMode
Using tnsnames.ora Files
Connecting to the Database
Configuring the tnsnames.ora File
Data Types
Using Oracle Date/Time Data Types
TIMESTAMP WITH LOCAL TIME ZONE Data Type
TIMESTAMP WITH TIME ZONE Data Type
Returning and Inserting/Updating XML Data
Returning XML Data
Inserting/Updating XML Data
REF CURSOR Data Type
Example 2: Calling a Stored Procedure that Returns Multiple REF CURSORs
Authentication
Using the AuthenticationMethod Property
Configuring User ID/Password Authentication
Configuring Kerberos Authentication
Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
Obtaining a Kerberos Ticket Granting Ticket
Configuring NTLM Authentication
Configuring Client Authentication
Data Encryption
SQL Escape Sequences
Isolation Levels
Using Scrollable Cursors
Batch Inserts and Updates
Parameter Metadata Support
Insert and Update Statements
Select Statements
Stored Procedures
ResultSet MetaData Support
Executing Insert/Update/Delete Statements with a RETURNING Clause
Example A: Retrieving a Result Value From an Insert/Update/Delete of a Single Row
Example B: Retrieving Result Values From an Insert/Update/Delete of Multiple Rows
Rowset Support
Auto-Generated Keys Support
Server Result Set Caching
XQuery Support
The Sybase Driver
Database Version Support
Driver Classes
Sybase URL
Sybase Connection Properties
Performance Considerations
BatchPerformanceWorkaround
EncryptionMethod
InsensitiveResultSetBufferSize
LongDataCacheSize
PacketSize
PrepareMethod
ResultSetMetaDataOptions
SelectMethod
Data Types
Authentication
Using the AuthenticationMethod Property
Configuring User ID/Password Authentication
Configuring Kerberos Authentication
Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)
Obtaining a Kerberos Ticket Granting Ticket
Data Encryption
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
Database Connection Property
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 (Deprecated)
SQL Server Driver
Sybase Driver
SQL Escape Sequences for JDBC
Date, Time, and Timestamp Escape Sequences
Scalar Functions
Outer Join Escape Sequences
LIKE Escape Character Sequence for Wildcards
Procedure Call Escape Sequences
Tracking JDBC Calls with WebLogic JDBC Spy
Configuring WebLogic JDBC Data Sources for WebLogic JDBC Spy
WebLogic JDBC Spy URL Attributes
WebLogic JDBC Spy Log Example
|