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:
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
|
|
|
DB2 9.1 and later FixPaks
|
|
|
MySQL 4
|
Connect/J
|
http://dev.mysql.com
/downloads/connector
|
MySQL 5
|
Connect/J
|
No XA support available.
|
Microsoft SQL Server 2000 SP3+
|
|
SQL Server 2000 is supported only on Microsoft operating systems.
|
Microsoft SQL Server 2005
|
|
SQL Server 2005 is supported only on Microsoft operating systems.
|
Sybase 12.5.03 and later patch levels of 12.5.x
|
|
|
Sybase 15.0.x and later patch levels of 15.0.x
|
|
|
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 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 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 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 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 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 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 11gR2 (Oracle 11.2.0.1+)
|
|
|
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
|
|
|
DB2 9.1 and later FixPaks
|
|
|
MySQL 4
|
Connect/J
|
http://dev.mysql.com
/downloads/connector
|
MySQL 5
|
Connect/J
|
No XA support available.
|
Microsoft SQL Server 2000 SP3+
|
|
SQL Server 2000 is supported only on Microsoft operating systems.
|
Microsoft SQL Server 2005
|
|
SQL Server 2005 is supported only on Microsoft operating systems.
|
Sybase 15.0.x and later patch levels of 15.0.x
|
|
|
Sybase 12.5.03 and later patch levels of 12.5.x
|
|
|
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 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 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 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 Drivers support the Oracle database versions that are listed.
Not supported by WebLogic Integration
|
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 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)
|
|
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)
|
|
|
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