Type 4 JDBC Drivers

Introduction and Roadmap

Document Scope and Audience

Guide to this Document

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 Server Authentication

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

Character Data

Binary Data

Inserting/Updating XML Data

Character Data

Binary Data

Authentication

Using the AuthenticationMethod Property

Configuring User ID/Password Authentication

To configure user ID/password authentication:

Configuring Kerberos Authentication

Product Requirements

Configuring the Driver

To configure the driver:

Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)

Obtaining a Kerberos Ticket Granting Ticket

Configuring Client Authentication

Data Encryption

Configuring SSL Encryption

To configure 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

Character Data

Binary Data

Inserting/Updating XML Data

Character Data

Binary Data

Authentication

Using the AuthenticationMethod Property

Configuring SQL Server Authentication

Configuring Kerberos Authentication

Product Requirements

Configuring the Driver

To configure the driver:

Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)

Obtaining a Kerberos Ticket Granting Ticket

Configuring NTLM Authentication

Product Requirements

Configuring the Driver

To configure the driver:

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

Date/Time Session Parameters

TIMESTAMP Data Type

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

Product Requirements

Configuring the Driver

To configure the driver:

Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)

Obtaining a Kerberos Ticket Granting Ticket

Configuring NTLM Authentication

Product Requirements

Configuring the Driver

To configure the driver:

Configuring Client Authentication

Data Encryption

To configure SSL 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

Product Requirements

Configuring the Driver

To configure the driver:

Specifying User Credentials for Kerberos Authentication (Delegation of Credentials)

Obtaining a Kerberos Ticket Granting Ticket

Data Encryption

To configure SSL 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