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:
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
|
|
|
|
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+
|
|
SQL Server 2000 is supported only on Microsoft operating systems.
|
|
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 9.2.0.4 and later patch sets of 9.2.x
|
|
|
|
Oracle 10g R1 (Oracle 10.1.0.4 and later patch sets of 10.1.x)
|
|
|
|
Oracle 10g R2 (Oracle 10.2.0.1 and later patch sets of 10.2.x)
|
|
|
|
Oracle 11g R1 (Oracle 11.1.0.6.0 later patch sets of 11.1.x)
|
|
Supported for WebLogic Server 9.2MP3 and later MPs
|
.
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 10g R1 RAC (for Oracle 10.1.0.4 and later patch sets of 10.1.x)
|
|
|
Oracle 10g R2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)
|
|
|
Oracle 11g R1 RAC (for Oracle 11.1.0.6.0 later patch sets of 11.1.x)
|
|
For information about configuring WebLogic Server with Oracle RAC, see: http://e-docs.bea.com/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 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
|
|
|
|
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+
|
|
SQL Server 2000 is supported only on Microsoft operating systems.
|
|
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 9.2.0.4 and later patch sets of 9.2.x
|
|
|
|
Oracle 10g R1 (Oracle 10.1.0.4 and later patch sets of 10.1.x)
|
|
Not supported by WebLogic Portal and WebLogic Integration.
|
|
Oracle 10g R2 (Oracle 10.2.0.1 and later patch sets of 10.2.x)
|
|
|
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
|
|
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)
|
|
Supported with WebLogic Portal 9.2 MP2 and later MPs
|
|
Oracle 10g R2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)
|
|
Note: Support for WLI 9.2 MP1 requires Patch ID: 1VLA, Pass code: SJ88M5JJ. See the BEA Smart Update tool at http://e-docs.bea.com/common/docs92/smart_update/intro.html.
|
For information about configuring WebLogic Server with Oracle RAC, see: http://e-docs.bea.com/wls/docs92/jdbc_admin/oracle_rac.html
