Supported Configurations for WebLogic Server 9.1
Supported Database Configurations
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 Transaction handling, may not be supported with particular databases. For more information, see the WebLogic Server documentation at
http://download.oracle.com/docs/cd/E13222_01/wls/docs91/index.html
.
- 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, such as for Container Managed Persistence (CMP) and Rowsets, database support requirements are more restrictive than for application connectivity. The following table lists the types of databases and drivers supported for use with WebLogic Server features
Table 3-1 WebLogic Server Support for CMP and Rowsets
Database Type
|
JDBC Driver
|
Notes
|
DB2 8.2 FixPak2 (equivalent to 8.1 FixPak 9) and later FixPaks
|
|
|
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)
|
|
|
.
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: