WebLogic 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

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

Known Issues

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

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