Supported Configurations for WebLogic Platform 10.0

Supported Database Configurations

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

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 Supported Database Versions and Drivers 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 FixPak2 (equivalent to 8.1 FixPak 9) and later FixPaks	BEA WebLogic Type 4 JDBC DB2 Driver BEA WebLogic Type 4 XA JDBC DB2 Driver
DB2 9.1 and later FixPaks	BEA WebLogic Type 4 JDBC DB2 Driver BEA 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` No XA or stored procedures support available.
MySQL 5	Connect/J	No XA support available.
Microsoft SQL Server 2000 SP3+	BEA WebLogic Type 4 JDBC SQL Server Driver BEA WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
Microsoft SQL Server 2005	BEA WebLogic Type 4 JDBC SQL Server Driver BEA WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2005 is supported only on Microsoft operating systems.
Sybase 12.5.03 and later patch levels of 12.5.x	BEA WebLogic Type 4 JDBC Sybase Driver BEA WebLogic Type 4 XA JDBC Sybase Driver
Sybase 15.0.x and later patch levels of 15.0.x	BEA WebLogic Type 4 JDBC Sybase Driver BEA 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. BEA 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.
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.6.0 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. Supported for WebLogic Server 10.0MP1 and later MPs
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. Supported for WebLogic Server 10.0MP1 and later MPs

Supported Database Versions and Drivers 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 10.0

Database Type	JDBC Driver	Notes
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.
Oracle 11gR1 (Oracle 11.1.0.6.0 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. Supported for WebLogic Server 10.0MP1 and later MPs 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 (Oracle 11.2.0.1+)	Oracle Thin Driver 10g Oracle Thin Driver 11g	Oracle Thin Drivers support the Oracle database versions that are listed. Supported for WebLogic Server 10.0MP1 and later MPs 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.

Database Type

JDBC Driver

Notes

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.

Oracle 11gR1 (Oracle 11.1.0.6.0 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.

Supported for WebLogic Server 10.0MP1 and later MPs

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 (Oracle 11.2.0.1+)

Oracle Thin Driver 10g

Oracle Thin Driver 11g

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

Supported for WebLogic Server 10.0MP1 and later MPs

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/docs100/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 BEA 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	BEA WebLogic Type 4 JDBC DB2 Driver BEA WebLogic Type 4 XA JDBC DB2 Driver
DB2 9.1 and later FixPaks	BEA WebLogic Type 4 JDBC DB2 Driver BEA WebLogic Type 4 XA JDBC DB2 Driver
MySQL 4	Connect/J	Not supported with WebLogic Portal. The `mysql.jar` file is not bundled with ProductName. It is available for download from: `http://dev.mysql.com /downloads/connector` No XA or stored procedures support available.
MySQL 5	Connect/J	No XA support available.
Microsoft SQL Server 2000 SP3+	BEA WebLogic Type 4 JDBC SQL Server Driver BEA WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
Microsoft SQL Server 2005	BEA WebLogic Type 4 JDBC SQL Server Driver BEA WebLogic Type 4 XA JDBC SQL Server Driver	SQL Server 2005 is supported only on Microsoft operating systems.
Sybase 15.0.x and later patch levels of 15.0.x	BEA WebLogic Type 4 JDBC Sybase Driver BEA WebLogic Type 4 XA JDBC Sybase Driver
Sybase 12.5.03 and later patch levels of 12.5.x	BEA WebLogic Type 4 JDBC Sybase Driver BEA 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. BEA 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.
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.6.0 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. Not supported by WebLogic Integration

WebLogic Platform Support for Oracle RAC