Using WebLogic Type 4 JDBC Drivers

 

JDBC Specification Compliance

Installation

License Requirements

Supported Databases

Connecting Through Data Sources and Connection Pools

Specifying Connection Properties


Limiting Connection Creation Time with LoginTimeout
Connection Failover with AlternateServers
Connection Failover with MS SQL Server Named Instances
Using AlternateServers with WebLogic Server JDBC Connection Pools

 

XA Support

Unicode Support

Error Handling


Driver Errors
Database Errors

 


The DB2 Driver

 

Database Version Support

DB2 Driver Classes

DB2 URL

DB2 Connection Properties

Sample Connection Pool Configuration

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

SQL Escape Sequences

Isolation Levels

Using Scrollable Cursors

JTA Support

Large Object (LOB) Support

Performance Workaround for Batch Inserts and Updates

Auto-Generated Keys Support

 


The Informix Driver

 

Informix Database Version Support

Informix Driver Classes

Informix URL

Informix Connection Properties

Sample Connection Pool Configuration


Informix Limitation for Prepared Statements

 

Data Types

SQL Escape Sequences

Isolation Levels

Using Scrollable Cursors

Blob and Clob Searches

Auto-Generated Keys Support

 


The MS SQL Server Driver

 

Driver Class

URL

MS SQL Server Connection Properties

Sample Connection Pool Configuration

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

Auto-Generated Keys Support

 


The Oracle Driver

 

Oracle Database Version Support

Oracle Driver Classes

Oracle URL

Oracle Connection Properties

Sample Connection Pool Configuration

Data Types

Oracle9i Data Type Support


Oracle9i Date/Time Data Types
Oracle9i Date/Time Session Parameters
TIMESTAMP Data Type
TIMESTAMP WITH LOCAL TIME ZONE Data Type
TIMESTAMP WITH TIME ZONE Data Type
XMLType Data Type

 

SQL Escape Sequences

Isolation Levels

Using Scrollable Cursors

JTA Support

Batch Inserts and Updates

Auto-Generated Keys Support

 


The Sybase Driver

 

Database Version Support

Driver Classes

Sybase URL

Sybase Connection Properties

Sample Connection Pool Configuration

Data Types

SQL Escape Sequences

Isolation Levels

Using Scrollable Cursors

Large Object (LOB) Support

Batch Inserts and Updates

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
PreparedStatement Object
Ref Object
ResultSet Object
ResultSetMetaData Object
SavePoint Object
Statement Object
Struct Object
XAConnection Object
XADataSource Object

GetTypeInfo

 

DB2 Driver

Informix Driver

Oracle Driver


Oracle 9i Only

 

SQL Server Driver


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 Connection Pools for WebLogic JDBC Spy


Configuring WebLogic JDBC Spy with a Non-XA Driver
Configuring WebLogic JDBC Spy with an XA Driver

 

BEA WebLogic JDBC Spy URL Attributes

BEA WebLogic JDBC Spy Log Example

Skip footer navigation  Back to Top Previous Next