Supported Configurations for WebLogic Platform 9.2

Supported Database Configurations

The following sections describe the database and driver support provided by WebLogic Platform 9.2:

WebLogic Server Support for Databases

The following sections provide information on supported drivers and databases for application connectivity and use with WebLogic Server features:

WebLogic Server Support for Database Application Connectivity

WebLogic Server provides support for application connectivity and communication with any database management system using a JDBC driver that meets the following requirements:

The driver must be threadsafe. WebLogic Server is highly multithreaded and there are some drivers (the JDBC-ODBC bridge from Sun, for example) that cannot be used with WebLogic Server.
The driver must implement standard JDBC transactional calls, such as setAutoCommit() and setTransactionIsolation(), when used in transactionally aware environments, such as for EJBs.

Note the following restrictions:

Third-party JDBC drivers that do not implement serializable or remote interfaces cannot pass objects to an RMI client application.
Certain features of WebLogic Server, such as Container Managed Persistence (CMP) and Rowsets, may not be supported with particular databases. See Databases Supporting WebLogic Server Features..
Not all JDBC drivers can be used with WebLogic Server and Oracle RAC. See WebLogic Server Support for Oracle RAC.
Automatic database connection failover and load balancing with global transactions (XA) in a highly-available (HA) DBMS architecture is supported with Oracle RAC only, and is not supported with other HA DBMS technologies. Transaction behavior for HA DBMSs varies from vendor to vendor and among various HA technologies. Because of these differences in behavior, the WebLogic Transaction Manager may not be able to complete or continue transactions with connections to a database other than the database instance used to originate the transaction. Attempts to do so may result in data consistency errors without any indication of an error.

For information on using JDBC drivers with WebLogic Server, see:

WebLogic Type 4 JDBC Drivers.
Configuring JDBC Data Sources in Configuring and Managing WebLogic JDBC.
Using Third-Party Drivers with WebLogic Server in Configuring and Managing WebLogic JDBC.

Databases Supporting WebLogic Server Features

When WebLogic Server features use a database for internal data storage, database support requirements are more restrictive than for application connectivity. The following WebLogic Server features require internal data storage:

Container Managed Persistence (CMP)
Rowsets
JMS/JDBC Persistence and use of a WebLogic JDBC Store
JDBC Session Persistence
RDBMS Security Providers
Database leasing (for singleton services and server migration)
JTA Logging Last Resource optimization

The following table lists the types of databases and drivers supported for use with WebLogic Server features

Table 3-1 Database Support for WebLogic Server Features

Database Type	JDBC Driver	Notes
DB2 8.2 Fix Pack 2+ is supported with WebLogic 9.2, 9.2 MP1, 9.2 MP3. DB2 8.2 Fix Pack 2+ is not supported starting with WebLogic Server 9.2 MP4.	Oracle WebLogic Type 4 JDBC DB2 Driver Oracle WebLogic Type 4 XA JDBC DB2 Driver
DB2 9.5 (all Fix Pack levels included) DB2 9.5 is supported starting with WebLogic Server 9.2 MP4.	Oracle WebLogic Type 4 JDBC DB2 Driver Oracle WebLogic Type 4 XA JDBC DB2 Driver
MySQL 4	Connect/J	The `mysql.jar` file is not bundled with WebLogic Server. It is available for download from: `http://dev.mysql.com/downloads/connector` Note: No XA or stored procedures support available.
Microsoft SQL Server 2000 SP3+ Microsoft SQL Server 2000 SP4+ is supported starting with WebLogic Server 9.2 MP4.	Oracle WebLogic Type 4 JDBC SQL Server Driver Oracle WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
Microsoft SQL Server 2005 (all Service Pack levels included) Microsoft SQL Server 2005 is supported starting with WebLogic Server 9.2 MP4.	Oracle WebLogic Type 4 JDBC SQL Server Driver Oracle WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2005 is supported only on Microsoft operating systems.
Microsoft SQL Server 2008 (all Service Pack levels included) Microsoft SQL Server 2008 is supported starting with WebLogic Server 9.2 MP4.	Oracle WebLogic Type 4 JDBC SQL Server Driver Oracle WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2008 is supported only on Microsoft operating systems.
Sybase 12.5.03 and later patch levels of 12.5.x is supported with WebLogic 9.2, 9.2 MP1, 9.2 MP3. Sybase 12.5.03 and later patch levels of 12.5.x is not supported with WebLogic 9.2 MP4.	Oracle WebLogic Type 4 JDBC Sybase Driver Oracle WebLogic Type 4 XA JDBC Sybase Driver
Sybase 15.0.x and later patch levels of 15.0.x Sybase 15.0.x is supported starting with WebLogic Server 9.2 MP4.	Oracle WebLogic Type 4 JDBC Sybase Driver Oracle WebLogic Type 4 XA JDBC Sybase Driver
PointBase 5.1	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Server distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Server. Non-evaluation development or other use of the PointBase Server requires that a separate PointBase Server license be obtained by the end user directly from DataMirror. Oracle evaluation license limits the size of the PointBase database to 30MB. PointBase 5.1 is not supported by WebLogic Server 9.2 MP4.
PointBase 5.7	PointBase Type 4 Driver	PointBase 5.7 is supported with WebLogic Server 9.2 MP4 only. PointBase 5.7 is for evaluation purposes only. It is not bundled / redistributed with WebLogic Server 9.2 MP4.
Oracle 9i (9.2.0.4 and later patch sets of 9.2.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.
Oracle 10gR1 (Oracle 10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.
Oracle 10gR2 (Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.
Oracle 11gR1 (Oracle 11.1.0.7 and later patch sets of 11.1.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.
Oracle 11gR2 (Oracle 11.2.0.1+)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.

WebLogic Server Support for Oracle RAC

Automatic database connection failover and load balancing with global transactions (XA) in a highly-available (HA) DBMS architecture is supported with the following Oracle RAC versions and drivers:

Table 3-2 Database Types and Drivers Supported by WebLogic Server 9.2

Database Type	JDBC Driver
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g
Oracle 10gR1 RAC (for Oracle 10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g
Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g
Oracle 11gR1 RAC (for Oracle 11.1.0.7 and later patch sets of 11.1.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g Support for 11g RAC continues to rely on the well-proven integration architecture using Multi-Data Sources for XA with load balancing. See Using WebLogic Server with Oracle RAC in Configuring and Managing WebLogic JDBC.
Oracle 11gR2 RAC (for Oracle 11.2.0.1+)	Oracle Thin Driver 10g Oracle Thin Driver 11g Support for 11g RAC continues to rely on the well-proven integration architecture using Multi-Data Sources for XA with load balancing. See Using WebLogic Server with Oracle RAC in Configuring and Managing WebLogic JDBC.

For information about configuring WebLogic Server with Oracle RAC, see: http://download.oracle.com/docs/cd/E13222_01/wls/docs92/jdbc_admin/oracle_rac.html

WebLogic Platform Support for Databases

The following sections provide information on supported drivers and databases for application connectivity and use with WebLogic Platform:

Databases Supporting WebLogic Platform

The following table lists the types of databases and drivers supported for use with WebLogic Server, WebLogic Portal, and Oracle Workshop for WebLogic Platform.

Table 3-3 Database Types and Drivers Supported by WebLogic Platform

Database Type	JDBC Driver	Notes
DB2 8.2 FixPak2 (equivalent to 8.1 FixPak 9) and later FixPaks	Oracle WebLogic Type 4 JDBC DB2 Driver Oracle WebLogic Type 4 XA JDBC DB2 Driver
MySQL 4	Connect/J	Not supported with WebLogic Portal and WebLogic Integration. The `mysql.jar` file is not bundled with WebLogic Platform 9.2. It is available for download from: `http://dev.mysql.com/downloads/connector` Note: No XA or stored procedures support available.
Microsoft SQL Server 2000 SP3+	Oracle WebLogic Type 4 JDBC SQL Server Driver Oracle WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
Sybase 12.5.03 and later patch levels of 12.5.x	Oracle WebLogic Type 4 JDBC Sybase Driver Oracle WebLogic Type 4 XA JDBC Sybase Driver
PointBase 5.1	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Server distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Server. Non-evaluation development or other use of the PointBase Server requires that a separate PointBase Server license be obtained by the end user directly from DataMirror. Oracle evaluation license limits the size of the PointBase database to 30MB.
Oracle 9i (9.2.0.4 and later patch sets of 9.2.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.
Oracle 10gR1 (Oracle 10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed. Not supported by WebLogic Portal and WebLogic Integration.
Oracle 10gR2 (Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed.

WebLogic Platform Support for Oracle RAC

Automatic database connection failover and load balancing with global transactions (XA) in a highly-available (HA) DBMS architecture is supported with the following Oracle RAC versions and drivers:

Table 3-4 Database Types and Drivers Supported by WebLogic Platform

Database Type	JDBC Driver	Notes
Oracle 9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed. Supported with WebLogic Portal 9.2 MP2 and later MPs
Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed. Supported with WebLogic Integration 9.2 MP1 and later MPs Note: Support for WLI 9.2 MP1 requires Patch ID: `1VLA`, Pass code: `SJ88M5JJ`. See the Oracle Smart Update tool at http://download.oracle.com/docs/cd/E13179_01/common/docs92/smart_update/intro.html.

Database Type

JDBC Driver

Notes

Oracle 9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)

Oracle Thin Driver 10g

Oracle Thin Driver 11g

Oracle Thin Drivers support the Oracle database versions that are listed.

Supported with WebLogic Portal 9.2 MP2 and later MPs

Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)

Oracle Thin Driver 10g

Oracle Thin Driver 11g

Oracle Thin Drivers support the Oracle database versions that are listed.

Supported with WebLogic Integration 9.2 MP1 and later MPs

Note: Support for WLI 9.2 MP1 requires Patch ID: 1VLA, Pass code: SJ88M5JJ. See the Oracle Smart Update tool at http://download.oracle.com/docs/cd/E13179_01/common/docs92/smart_update/intro.html.

For information about configuring WebLogic Server with Oracle RAC, see: http://download.oracle.com/docs/cd/E13222_01/wls/docs92/jdbc_admin/oracle_rac.html