Supported Configurations for WebLogic Platform 8.1

Supported Database Configurations

This section includes the following topics:

WebLogic Server Support for Databases

WebLogic Platform Support for Databases

WebLogic Server Support for Databases

In addition to the support provided by all WebLogic Platform products described in WebLogic Platform Support for Databases, 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 a highly multithreaded application and there are some drivers (for example, the JDBC-ODBC bridge from Sun) 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), 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/docs81/index.html.
Not all JDBC drivers can be used with WebLogic Server and Oracle RAC. For a list of Oracle RAC requirements, see the detailed information about database versions and drivers supported by the appropriate service pack release. For example, if you want to run Oracle9i RAC with WebLogic Platform 8.1 SP5, check the list of supported drivers in Table 3-5.
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. See Table 3-5 for details about Oracle RAC support.

Driver Support for WebLogic Server

For information on supported the database drivers that are installed with WebLogic Server, see:

WebLogic Type 4 JDBC Drivers.
Using Third-Party Drivers with WebLogic Server in Programming WebLogic JDBC.
WebLogic jDriver for Oracle. See WebLogic jDriver for Oracle (Deprecated) at http://download.oracle.com/docs/cd/E13222_01/wls/docs81/oracle/index.html.
WebLogic jDriver for Microsoft SQL Server. See WebLogic jDriver for SQL Server (Deprecated) at http://download.oracle.com/docs/cd/E13222_01/wls/docs81/mssqlserver4/index.html.

For more information about configuring WebLogic Server with drivers from third-party vendors, see Using Third-Party Drivers with WebLogic Server in Programming WebLogic JDBC.

For more detailed information about using JDBC drivers in applications, see Programming 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
JDBC Session Persistence
RDBMS Security Providers

See List of Supported Databases for WebLogic Platform 8.1, by Release.

Support for Oracle RAC in WebLogic Server 8.1 SP4

For WebLogic Server 8.1 SP4, BEA provides a patch that supports Oracle9i RAC and Oracle 10g RAC for the use of MultiPools, with or without XA transactions.

Note: The MultiPool Patch is supported by WebLogic Server 8.1 SP4 only; it is not supported by any other WebLogic Platform component products.

The MultiPool Patch enables WebLogic JDBC MultiPools to be used with either Oracle9i RAC or 10g RAC to support connection pool failover and load balancing for applications using XA transactions and Oracle RAC.
This patch is compatible with non-XA usage, and incorporates support previously delivered in the WebLogic Platform 8.1 SP4 patch for Oracle9i RAC connect-time failover.
The MultiPool Patch is available for downloading at:
http://dev2dev.bea.com/wlserver/patch/wls81sp4_MP_OracleRAC_patch.html

Note: For information about configuring your system with Oracle9i or 10g RAC, see "Using WebLogic Server with Oracle RAC" in Programming WebLogic JDBC:
http://download.oracle.com/docs/cd/E13222_01/wls/docs81/jdbc/oracle_rac.html

WebLogic Platform Support for Databases

Certain WebLogic Platform products, specifically WebLogic Workshop, WebLogic Portal, WebLogic Integration, and WebLogic Server Process Edition use databases stores for product runtime data. WebLogic Platform and these products support only the databases and the database drivers specified in the "Database Support" sections in this document for this purpose. For example, see the supported database versions and drivers for WebLogic Platform 8.1 SP5 in Database Support for WebLogic Platform 8.1 SP5.

In addition, WebLogic Platform provides support for application connectivity and communication with databases as follows:

Using JDBC drivers, as described in WebLogic Server Support for Databases.

Note: Some programming productivity features in the WebLogic Workshop IDE only support the databases and JDBC drivers specified in the "Database Support" sections in this document.

Using a WebLogic Adapter for RDBMS to integrate with a custom application running on a database separate from the database on which WebLogic Integration is running. For information, see the BEA WebLogic Adapter for RDBMS 8.1.2 Documentation at http://download.oracle.com/docs/cd/E13207_01/wladapters/rdbms/docs812/index.html.

Database Access Requirements for WebLogic Platform

WebLogic Platform requires the following database-specific resources:

Access to a database server installed on the local network. WebLogic Platform installs a local copy of the PointBase database solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.
Database server account with privileges sufficient for creating a database with tables must be available.
For WebLogic Platform 8.1 SP2, BEA provides an SDK/Oracle10gdriver/Database patch that enables full WebLogic Platform support for the SQL Server and Sybase databases when using XA, and full WebLogic Platform DB2 support. This patch is available at the following URL:

http://commerce.bea.com/d2d/wlplat81sp2_patch.jsp

For WebLogic Platform 8.1 SP4, BEA provides a patch for the IBM DB2 database. BEA recommends that you apply this patch to your system if you are using DB2 with WebLogic Platform 8.1 SP4. This patch, which includes JDBC drivers for DB2, is available at the following URL:

http://commerce.bea.com/d2d/wlplat81sp4_db2_patch.jsp

For WebLogic Platform 8.1 SP4, BEA provides a patch for Oracle9i RAC support. BEA recommends that you apply this patch to your system if you are using Oracle9i RAC with WebLogic Platform 8.1 SP4. This patch is available at the following URL:

http://commerce.bea.com/d2d/wlplat81sp4_Oracle9iRAC_patch.jsp

List of Supported Databases for WebLogic Platform 8.1, by Release

The following table lists the databases supported by each release of WebLogic Platform 8.1.x.

Note: The following table is provided only to show which databases are supported by the various 8.1 releases of WebLogic Platform. Details, including information about available patch levels, are provided in service pack-specific tables. To access detailed information for a particular service pack, click the link for that service pack in the following table.

Table 3-1 Supported Databases, by Release

This Database . . .	Is Supported in This Release . . .
DB2 8.1¹	8.1 SP6 8.1 SP5 8.1 SP4 ² 8.1 SP3 8.1 SP2
HP NonStop^{^TM} SQL/MX 1.8.5³	8.1 SP2
HP NonStop^TM SQL/MX 2.0	8.1 SP2 ⁴ 8.1 SP3 ⁵
Microsoft SQL Server 2000	8.1 SP6 8.1 SP5 8.1 SP4 8.1 SP3 8.1 SP2 8.1
Microsoft SQL Server 2005	8.1 SP6
MySQL 4.0.18⁶	8.1 SP6 8.1 SP5 8.1 SP4
Oracle 8.1.7⁷	8.1 SP4 8.1 SP3 8.1 SP2 8.1
Oracle9i (9.2.0)	8.1 SP5 8.1 SP4 8.1 SP3 8.1 SP2 8.1
Oracle9i RAC (for 9.2.0.4)	8.1 SP6 8.1 SP5 8.1 SP4 ⁸^, ⁹ 8.1 SP3 ⁶
Oracle 10g R1 (10.1)¹⁰	8.1 SP6 8.1 SP5 ¹¹ 8.1 SP4 8.1 SP3
Oracle 10g R2 (10.2)¹²	8.1 SP6 8.1 SP5
Oracle 11g R1 (11.1.0.7)	8.1 SP6
Oracle 11gR2 (11.2.0.1+)¹³	8.1 SP6
Oracle 10g R1 RAC (for Oracle 10.1)	8.1 SP6 8.1 SP5 ¹¹ 8.1 SP4 ⁶, ⁹
Oracle 10g R2 RAC (for Oracle 10.2)¹²	8.1 SP6 8.1 SP5
Oracle 11g R1 RAC (for Oracle 11.1.0.7)	8.1 SP6
Oracle 11g R2 RAC (for Oracle 11.2.0.1+)	8.1 SP6
PointBase 4.4	8.1 SP5 8.1 SP4 8.1 SP3 8.1 SP2 8.1
PointBase 5.1	8.1 SP6
Sybase 12.5	8.1 SP6 8.1 SP5 8.1 SP4 8.1 SP3 8.1 SP2

1. Support for DB2 in WebLogic Platform 8.1 SP2, 8.1 SP3, 8.1 SP4, and 8.1 SP5 applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows.

2. For WebLogic Platform 8.1 SP4, BEA provides a patch for the IBM DB2 database. BEA recommends that you apply this patch to your system if you are using DB2 with WebLogic Platform 8.1 SP4. This patch, which includes JDBC drivers for DB2, is available at the following URL:
http://commerce.bea.com/d2d/wlplat81sp4_db2_patch.jsp

3. Supported only by WebLogic Server on HP NonStop Server configurations.

4. Supported by WebLogic Server and WebLogic Integration on HP NonStop Server configurations.

5. Supported by WebLogic Server on HP Integrity Nonstop Server on Itanium processors.

6. Supported only by WebLogic Server.

7. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at
http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817.

8. For WebLogic Platform 8.1 SP4, BEA provides a patch for Oracle9i RAC. BEA recommends that you apply this patch to your system if you are using Oracle9i RAC with WebLogic Platform 8.1 SP4. This patch is available at the following URL:
http://commerce.bea.com/d2d/wlplat81sp4_Oracle9iRAC_patch.jsp.
Note that the full WebLogic Platform 8.1 SP4 product components (specifically the WebLogic Workshop, WebLogic Portal, and WebLogic Integration products) do not support the WebLogic Server 8.1 SP4 MultiPool-based RAC support referenced in footnote 9.

9. For WebLogic Server 8.1 SP4, BEA provides a patch that supports Oracle9i RAC and Oracle 10g RAC for the use of MultiPools, with or without XA transactions. The MultiPool Patch is supported by WebLogic Server 8.1 SP4 only; it is not supported by any other WebLogic Platform component products.
The MultiPool Patch enables WebLogic JDBC MultiPools to be used with either Oracle9i RAC or 10g RAC to support connection pool failover and load balancing for applications using XA transactions and Oracle RAC.
This patch is compatible with non-XA usage, and incorporates support previously delivered in the WebLogic Platform 8.1 SP4 patch for Oracle9i RAC connect-time failover. It is available for downloading at
http://dev2dev.bea.com/wlserver/patch/wls81sp4_MP_OracleRAC_patch.html.

10. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error "ORA-00600: internal error code, arguments: [qctstc2o1]", contact Oracle support and get the patch for Bug ID 4010945.

11. WebLogic Platform 8.1 SP5 supports version 10.1.0.4 and later patch sets of 10.1 of Oracle 10g and Oracle 10g RAC.

12. Note to users of WebLogic Portal 8.1 SP5: As described in Oracle Note 317258.1, Oracle changed their use of predefined database roles in the 10g R2 version to provide more security. The CONNECT role now provides only CREATE SESSION privileges; the other associated privileges have been removed. Therefore, you must now explicitly grant the CREATE VIEW privilege for Oracle 10g R2 databases.(CR252362)

13. Supported only by WebLogic Server.

Database Support for WebLogic Platform 8.1 SP6

This section provides:

High-Level Summary of Supported Databases

The following table identifies the databases for which full support, partial support, or no support are provided by the complete WebLogic Platform 8.1 product and its components in Service Pack 6 (SP6).

Note: For detailed information about supported versions and drivers for these databases, see Table 3-3.

Table 3-2 Databases Supported by WebLogic Platform 8.1 SP6 and Components

Supported Database	Full Platform	WebLogic Server	WebLogic Workshop	WebLogic Portal	WebLogic Integration
DB2
MySQL 4.0.18
Oracle 10g R1 (10.1.0.4)
Oracle 10g R2 (10.2.0.1)
Oracle 11g R1 (11.1.0.7)
Oracle 11g R2 (11.2.0.1+)
Oracle9i RAC (for Oracle 9.2.0.4)
Oracle 10g R1 RAC (for Oracle 10.1.0.4)
Oracle 10g R2 RAC (for Oracle 10.2.0.1)
Oracle 11g R1 RAC (for Oracle 11.1.0.7)
Oracle 11g R2 RAC (for Oracle 11.2.0.1+)
PointBase 5.1^¹
SQL Server 2000
SQL Server 2005²
Sybase 12.5.03
Other Databases	³	⁴
KEY Full support Partial support No support

1. Not supported for production.

2. WebLogic Server 8.1 SP6 GA is supported with Microsoft SQL Server 2005. For all other WebLogic 8.1SP6 components, BEA recommends the WebLogic Platform 8.1SP6 Microsoft SQL Server 2005 Patch.

3. Only WebLogic Server and WebLogic Integration offer partial support of databases not listed in this table.

4. The container-managed persistence (CMP) feature of WebLogic Server may not be supported with particular databases.

Supported Database Versions and Drivers

The following table lists the types of databases and drivers supported for use with WebLogic Platform 8.1 SP6.

Note: For information about databases and drivers supported for use with WebLogic Server, see WebLogic Server Support for Databases.

Table 3-3 Database Types and Drivers Supported in WebLogic Platform 8.1 SP6

Database Type	JDBC Driver	Notes
DB2 8.1 FixPak6 and later FixPaks (including v8.2)	BEA WebLogic Type 4 XA JDBC DB2 Driver BEA WebLogic Type 4 JDBC DB2 Driver	For more information about using DB2 with WebLogic Platform, see "Configuring DB2" in "Configuring Databases" at: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/configuring_specific_db_types.html`
Microsoft SQL Server 2000 SP3 and later SPs	BEA WebLogic Type 4 JDBC MS SQL Server Driver BEA WebLogic Type 4 XA JDBC MS SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
Microsoft SQL Server 2005	BEA WebLogic Type 4 JDBC MS SQL Server Driver BEA WebLogic Type 4 XA JDBC MS SQL Server Driver	SQL Server 2005 is supported only on Microsoft operating systems. WebLogic Server 8.1 SP6 GA is supported with Microsoft SQL Server 2005. For all other WebLogic 8.1 SP6 components, BEA recommends the WebLogic Platform 8.1SP6 Microsoft SQL Server 2005 Patch.
MySQL 4.0.18 and later SPs	Connector/J JDBC Driver 3.0.x	MySQL is supported only by WebLogic Server 8.1 SP6, including JDBC, JMS, and EJB-CMP. It is not supported by other components of WebLogic Platform 8.1 SP6. (See CR176363.)
Oracle 10g R1 (10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error `"ORA-00600: internal error code, arguments: [qctstc2o1]"`, contact Oracle support and get the patch for Bug ID 4010945. For information about configuring WebLogic Platform 8.1 SP6 with MultiPools and Oracle 10g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html`
Oracle 10g R2 (10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Bug ID 4010945, reported for Oracle 10g R1, has been resolved in 10g R2. Note to users of WebLogic Portal 8.1 SP6: As described in Oracle Note 317258.1, Oracle changed their use of predefined database roles in the 10g R2 version to provide more security. The CONNECT role now provides only CREATE SESSION privileges; the other associated privileges have been removed. Therefore, you must now explicitly grant the CREATE VIEW privilege for Oracle 10g R2 databases. (CR252362)
Oracle 11g R1 (11.1.0.7 and later patch sets of 11.1.0.7)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Oracle 11g R1 is certified on WebLogic Server 8.1 SP6 only. Users must use JDBC Driver version 10.2 when connecting WebLogic Server 8.1 to Oracle Database 11g because version 10.2 is the only driver version that supports both Oracle Database 11g and JDK 1.4.2 as required by WebLogic Server 8.1.
Oracle 11g R2 (11.2.0.1+)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Oracle 11g R2 is certified on WebLogic Server 8.1 SP6 only. Users must use JDBC Driver version 10.2 when connecting WebLogic Server 8.1 to Oracle Database 11g because version 10.2 is the only driver version that supports both Oracle Database 11g and JDK 1.4.2 as required by WebLogic Server 8.1.
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP6 with Oracle9i RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html`
Oracle 10gR1 RAC (for Oracle 10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP6 with MultiPools and Oracle 10g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html`
Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP6 with MultiPools and Oracle 10g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html` Note to users of WebLogic Portal 8.1 SP6: As described in Oracle Note 317258.1, Oracle changed their use of predefined database roles in the 10g R2 version to provide more security. The CONNECT role now provides only CREATE SESSION privileges; the other associated privileges have been removed. Therefore, you must now explicitly grant the CREATE VIEW privilege for Oracle 10g R2 databases. (CR252362)
Oracle 11gR1 RAC (for Oracle 11.1.0.7 and later patch sets of 11.1.0.7)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP6 with MultiPools and Oracle 11g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html` Note: The information contained in the WebLogic Platform 8.1 SP6 with MultiPools and Oracle 10g RAC document is fully applicable to the use of Oracle 11g RAC, which is certified with WebLogic Server 8.1 SP6 as per this document.
Oracle 11gR2 RAC (for Oracle 11.2.0.1+)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP6 with MultiPools and Oracle 11g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html` Note: The information contained in the WebLogic Platform 8.1 SP6 with MultiPools and Oracle 10g RAC document is fully applicable to the use of Oracle 11g RAC, which is certified with WebLogic Server 8.1 SP6 as per this document.
PointBase 5.1	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.
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	—
Other databases	Any compliant driver supplied by WebLogic Server	Other databases may be used for data access through WebLogic Server.

Database Support for WebLogic Platform 8.1 SP5

This section provides:

High-Level Summary of Supported Databases

Note: For detailed information about supported versions and drivers for these databases, see Table 3-5.

Table 3-4 Databases Supported by WebLogic Platform 8.1 SP5 and Components

Supported Database	Full Platform	WebLogic Server	WebLogic Workshop	WebLogic Portal	WebLogic Integration
DB2 8.1
MySQL 4.0.18
Oracle 9i (9.2.0.4)
Oracle9i RAC (for Oracle 9.2.0.4)
Oracle 10g R1 (10.1.0.4)
Oracle 10g R2 (10.2.0.1)				¹
Oracle 10g R1 RAC (for Oracle 10.1.0.4)
Oracle 10g R2 RAC (for Oracle 10.2.0.1)				¹
PointBase 4.4²
SQL Server 2000
Sybase 12.5.03
Other Databases	^³	⁴			^⁵
KEY Full support Partial support No support

1. Note to users of WebLogic Portal 8.1 SP5: As described in Oracle Note 317258.1, Oracle changed their use of predefined database roles in the 10g R2 version to provide more security. The CONNECT role now provides only CREATE SESSION privileges; the other associated privileges have been removed. Therefore, you must now explicitly grant the CREATE VIEW privilege for Oracle 10g R2 databases.

2. PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic
Workshop do not support PointBase for production server deployments.

3. Only WebLogic Server and WebLogic Integration offer partial support of databases not listed in this table.

4. The container-managed persistence (CMP) feature of WebLogic Server may not be supported with particular databases.

5. Supported only with the use of adapters.

Supported Database Versions and Drivers

The following table lists the types of databases and drivers supported for use with WebLogic Platform 8.1 SP5.

Note: For information about databases and drivers supported for use with WebLogic Server, see WebLogic Server Support for Databases on page 3-1.

Table 3-5 Database Types and Drivers Supported in WebLogic Platform 8.1 SP5

Database Type	JDBC Driver	Notes
DB2 8.1 FixPak6 and later FixPaks	BEA WebLogic Type 4 XA JDBC DB2 Driver BEA WebLogic Type 4 JDBC DB2 Driver	Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows. For more information about using DB2 with WebLogic Platform, see "Configuring DB2" in "Configuring Databases" at: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/configuring_specific_db_types.html`
Microsoft SQL Server 2000 SP3 and later SPs	BEA WebLogic Type 4 JDBC MS SQL Server Driver BEA WebLogic Type 4 XA JDBC MS SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
MySQL 4.0.18 and later SPs	Connector/J JDBC Driver 3.0.x	MySQL is supported only by WebLogic Server 8.1 SP5, including JDBC, JMS, and EJB-CMP. It is not supported by any other components of WebLogic Platform 8.1 SP5. (See CR176363.)
Oracle 9i (9.2.0.4 and later patch sets of 9.2.x)	Oracle Thin Driver 9.2.0 Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. WebLogic Platform 8.1 SP5 supports the Oracle 9.2.0.4 server and Oracle 9.2.0.4 Thin XA Driver. Obtaining specific patch sets for Oracle 9i Release 2, such as those required for Oracle 9.2.0.4, may require an Oracle Metalink (support contract) account. For details, see: `http://otn.oracle.com/support/patches.htm` The Oracle Thin Driver 10g and Oracle Thin/XA Driver 10g are the default drivers for WebLogic Platform 8.1 SP5.
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP5 with Oracle9i RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html`. For information about configuring WebLogic Platform 8.1 SP5 with MultiPools and Oracle 10g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html`
Oracle 10gR1 (10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error `"ORA-00600: internal error code, arguments: [qctstc2o1]"`, contact Oracle support and get the patch for Bug ID 4010945.
Oracle 10gR2 (10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Bug ID 4010945, reported for Oracle 10g R1, has been resolved in 10g R2. Note to users of WebLogic Portal 8.1 SP5: As described in Oracle Note 317258.1, Oracle changed their use of predefined database roles in the 10g R2 version to provide more security. The CONNECT role now provides only CREATE SESSION privileges; the other associated privileges have been removed. Therefore, you must now explicitly grant the CREATE VIEW privilege for Oracle 10g R2 databases. (CR252362)
Oracle 10gR1 RAC (for Oracle 10.1.0.4 and later patch sets of 10.1.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP5 with MultiPools and Oracle 10g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html`
Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For information about configuring WebLogic Platform 8.1 SP5 with MultiPools and Oracle 10g RAC, see: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/db_mgmt/oracle_rac.html` Note to users of WebLogic Portal 8.1 SP5: As described in Oracle Note 317258.1, Oracle changed their use of predefined database roles in the 10g R2 version to provide more security. The CONNECT role now provides only CREATE SESSION privileges; the other associated privileges have been removed. Therefore, you must now explicitly grant the CREATE VIEW privilege for Oracle 10g R2 databases. (CR252362)
PointBase 4.4	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.
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	—
Other databases	Any compliant driver supplied by WebLogic Server	Other databases may be used for data access through WebLogic Server.

Database Support for WebLogic Platform 8.1 SP4

This section provides:

High-Level Summary of Supported Databases

Note: For detailed information about supported versions and drivers for these databases, see Table 3-7.

Table 3-6 Databases Supported by WebLogic Platform 8.1 SP4 and Components

Supported Database	Full Platform	WebLogic Server	WebLogic Workshop	WebLogic Portal	WebLogic Integration
DB2 8.1¹
MySQL 4.0.18
Oracle 8.1.7.4²
Oracle 9i (9.2.0.4)
Oracle9i RAC (for Oracle 9.2.0.4)³^, ⁴^, ⁵
Oracle 10g R1 (10.1.0.2)⁶
Oracle 10g R2 (10.2.0.1)⁶
Oracle 10g R1 RAC (for Oracle 10.1.0.2)⁵^,⁶
Oracle 10g R2 RAC (for Oracle 10.2.0.1)⁵^,⁶
PointBase 4.4⁷
SQL Server 2000
Sybase 12.5.03
Other Databases	^⁸	⁹			^¹⁰
KEY Full support Partial support No support

1. For WebLogic Platform 8.1 SP4, BEA provides a patch for the IBM DB2 database. BEA recommends that you apply this patch to your system if you are using DB2 with WebLogic Platform 8.1 SP4. This patch, which includes JDBC drivers for DB2, is available at the following URL:
http://commerce.bea.com/d2d/wlplat81sp4_db2_patch.jsp

2. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at
http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817.

3. In 8.1 SP4, the full WebLogic Platform product supports the use of Oracle9i RAC with connect-time failover. WebLogic Server, however, also supports the use of Oracle9i RAC with WebLogic JDBC MultiPools and XA transactions. If you plan to use the full Platform product with Oracle9i RAC, see footnote 4, below.⁴ If you plan to use WebLogic Server with Oracle9i RAC, see footnote 5, below.⁵

4. For WebLogic Platform 8.1 SP4, BEA provides a patch for Oracle9i RAC (for Oracle 9.2.0.4). BEA recommends that you apply this patch to your system if you are using Oracle9i RAC with WebLogic Platform 8.1 SP4. This patch is available at the following URL:
http://commerce.bea.com/d2d/wlplat81sp4_Oracle9iRAC_patch.jsp

5. For WebLogic Server 8.1 SP4, BEA provides a patch that supports Oracle9i RAC and Oracle 10g RAC for the use of MultiPools, with or without XA transactions. The MultiPool Patch is supported by WebLogic Server 8.1 SP4 only; it is not supported by any other WebLogic Platform component products. The MultiPool Patch enables WebLogic JDBC MultiPools to be used with either Oracle9i RAC or 10g RAC to support connection pool failover and load balancing for applications using XA transactions and Oracle RAC. This patch is compatible with non-XA usage, and incorporates support previously delivered in the WebLogic Platform 8.1 SP4 patch for Oracle9i RAC connect-time failover. It is available for downloading at:
http://dev2dev.bea.com/wlserver/patch/wls81sp4_MP_OracleRAC_patch.html

6. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error "ORA-00600: internal error code, arguments: [qctstc2o1]", contact Oracle support and get the patch for Bug ID 4010945.

7. PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.

8. Only WebLogic Server and WebLogic Integration offer partial support of databases not listed in this table.

9. The container-managed persistence (CMP) feature of WebLogic Server may not be supported with particular databases.

10. Supported only with the use of adapters.

Supported Database Versions and Drivers

The following table lists the types of databases and drivers supported for use with WebLogic Platform 8.1 SP4.

Note: For information about databases and drivers supported for use with WebLogic Server, see WebLogic Server Support for Databases on page 3-1.

Table 3-7 Database Types and Drivers Supported in WebLogic Platform 8.1 SP4

Database Type	JDBC Driver	Notes
DB2 8.1 FixPak5 and later FixPaks	BEA WebLogic Type 4 XA JDBC DB2 Driver WebLogic Type 4 JDBC DB2 Driver	Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows. WebLogic Platform 8.1 SP4 support for DB2 requires the installation of the WebLogic Platform 8.1 SP4 DB2 patch. The patch, which includes JDBC drivers for DB2, can be downloaded from: `http://commerce.bea.com/d2d/wlplat81sp4_db2_patch.jsp` For more information about using DB2 with WebLogic Platform, see "Configuring DB2" in "Configuring Databases" at: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/sp_notes/sp_notes.html`.
Microsoft SQL Server 2000 SP3 and later SPs	BEA WebLogic Type 4 JDBC MS SQL Server Driver BEA WebLogic Type 4 XA JDBC MS SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
MySQL 4.0.18 and later SPs	Connector/J JDBC Driver 3.0.x	MySQL is supported only by WebLogic Server 8.1 SP4; it is not supported by any other components of WebLogic Platform 8.1 SP4.
Oracle 8.1.7.4	Oracle Thin Driver 9.2.0 Oracle Thin/XA Driver 9.2.0	The Oracle Thin Driver 10g and Oracle Thin/XA Driver 10g are the default drivers for WebLogic Platform 8.1 SP4.
Oracle 9i (9.2.0.4 and later patch sets of 9.2.x)	Oracle Thin Driver 9.2.0 Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. WebLogic Platform 8.1 SP4 supports the Oracle 9.2.0.4 server and Oracle 9.2.0.4 Thin XA Driver. Obtaining specific patch sets for Oracle 9i Release 2, such as those required for Oracle 9.2.0.4, may require an Oracle Metalink (support contract) account. For details, see: `http://otn.oracle.com/support/patches.htm` The Oracle Thin Driver 10g and Oracle Thin/XA Driver 10g are the default drivers for WebLogic Platform 8.1 SP4.
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For WebLogic Platform 8.1 SP4, BEA provides a patch for Oracle9i RAC support. BEA recommends that you apply this patch to your system if you are using Oracle9i RAC with WebLogic Platform 8.1 SP4. This patch is available at the following URL: `http://commerce.bea.com/d2d/wlplat81sp4_Oracle9iRAC_patch.jsp` For information about configuring WebLogic Platform 8.1 SP4 with Oracle9i RAC, see "Configuring Oracle 9i RAC" in "Configuring Databases" at: `http://download.oracle.com/docs/cd/E13196_01/platform/docs81/sp_notes/sp_notes.html`. For WebLogic Server 8.1 SP4, BEA provides a patch that supports Oracle9i RAC and Oracle 10g RAC for the use of MultiPools, with or without XA transactions. The MultiPool Patch is supported by WebLogic Server 8.1 SP4 only; it is not supported by any other WebLogic Platform component products. The MultiPool Patch enables WebLogic JDBC MultiPools to be used with either Oracle9i RAC or 10g RAC to support connection pool failover and load balancing for applications using XA transactions and Oracle RAC. This patch is compatible with non-XA usage, and incorporates support previously delivered in the WebLogic Platform 8.1 SP4 patch for Oracle9i RAC connect-time failover. The MultiPool Patch is available for downloading at: `http://dev2dev.bea.com/wlserver/patch/wls81sp4_MP_OracleRAC_patch.html`
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x) (continued)		For information about configuring WebLogic Server 8.1 SP4 with MultiPools and Oracle 9i RAC, see: "Using WebLogic Server with Oracle RAC" in Programming WebLogic JDBC: `http://download.oracle.com/docs/cd/E13222_01/wls/docs81/jdbc/oracle_rac.html`
Oracle 10g (10.1.0.2 and later patch sets of 10.1.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Oracle 10.1.0.2 is supported by all components of WebLogic Platform 8.1 SP4. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error `"ORA-00600: internal error code, arguments: [qctstc2o1]"`, contact Oracle support and get the patch for Bug ID 4010945.
Oracle 10g RAC (for Oracle 10.1.0.2 and later patch sets of 10.1.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. For WebLogic Server 8.1 SP4, BEA provides a patch that supports Oracle9i RAC and Oracle 10g RAC for the use of MultiPools, with or without XA transactions. The MultiPool Patch is supported by WebLogic Server 8.1 SP4 only; it is not supported by any other WebLogic Platform component products. The MultiPool Patch enables WebLogic JDBC MultiPools to be used with either Oracle9i RAC or 10g RAC to support connection pool failover and load balancing for applications using XA transactions and Oracle RAC. This patch is compatible with non-XA usage, and incorporates support previously delivered in the WebLogic Platform 8.1 SP4 patch for Oracle9i RAC connect-time failover. The MultiPool Patch is available for downloading at: `http://dev2dev.bea.com/wlserver/patch/wls81sp4_MP_OracleRAC_patch.html` For information about configuring WebLogic Server 8.1 SP4 with MultiPools and Oracle 10g RAC, see "Using WebLogic Server with Oracle RAC" in Programming WebLogic JDBC: `http://download.oracle.com/docs/cd/E13222_01/wls/docs81/jdbc/oracle_rac.html`
PointBase 4.4	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.
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	—
Other databases	Any compliant driver supplied by WebLogic Server	Other databases may be used for data access through WebLogic Server.

About the WebLogic Platform 8.1 SP4 DB2 Patch

BEA has provided a patch for WebLogic Platform 8.1 SP4 that enables full WebLogic Platform support for the IBM DB2 database. This patch, which includes JDBC drivers for DB2, is available at the following URL:

http://commerce.bea.com/d2d/wlplat81sp4_db2_patch.jsp

Database Support for WebLogic Platform 8.1 SP3

This section provides:

High-Level Summary of Supported Databases

Note: For detailed information about supported versions and drivers for these databases, see Table 3-9.

Table 3-8 Databases Supported by WebLogic Platform 8.1 SP3 and Components

Supported Database	Full Platform	WebLogic Server	WebLogic Workshop	WebLogic Portal	WebLogic Integration
DB2 8.1¹
HP NonStop^TM SQL/MX 2.0²
Oracle 8.1.7.4³
Oracle 9i (9.2.0.4)
Oracle9i RAC (for Oracle 9.2.0.4)
Oracle 10g (10.1.0.2)⁴
PointBase 4.4	⁵	^⁵	⁵	⁵	⁵
SQL Server 2000
Sybase 12.5.03
Other Databases	^⁶	⁷			^⁸
KEY Full support Partial support No support

1. Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows.

2. Supported only on HP Integrity NonStop Server on Itanium processors. For more information, see 8.1 Supported Configurations: HP Integrity NonStop Server on Itanium:
http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs81/hpnonstop_itanium/81sp3.html

3. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at
http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817.

4. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error "ORA-00600: internal error code, arguments: [qctstc2o1]", contact Oracle support and get the patch for Bug ID 4010945.

5. PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic
Workshop do not support PointBase for production server deployments.

6. Only WebLogic Server and WebLogic Integration offer partial support of databases not listed in this table.

7. The container-managed persistence (CMP) feature of WebLogic Server may not be supported with particular databases.

8. Supported only with the use of adapters.

Supported Database Versions and Drivers

The following table lists the types of databases and drivers supported for use with WebLogic Platform 8.1 SP3.

Note: For information about databases and drivers supported for use with WebLogic Server, see WebLogic Server Support for Databases on page 3-1.

Table 3-9 Database Types and Drivers Supported in WebLogic Platform 8.1 SP3

Database Type	JDBC Driver	Notes
DB2 8.1 FixPak3 and later FixPaks	BEA WebLogic Type 4 JDBC DB2 Driver BEA WebLogic Type 4 XA JDBC DB2 Driver	Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows.
HP NonStop^TM SQL/MX 2.0	NonStop^TM SQL/MX Type 2 non-XA driver: `com.tandem.sqlmx.SQLMXDriver` NonStop^TM SQL/MX Type 2 XA driver: `com.hp.nsk.xares.WLSTxSQLMXDataSource`	Supported by WebLogic Server on HP Integrity NonStop^TM Server configurations. For more information, see HP Integrity NonStop Server on Itanium with WebLogic Server 8.1 SP3 in 8.1 Supported Configurations: HP Integrity NonStop Server on Itanium: `http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs81/hpnonstop_itanium/81sp3.html`
Microsoft SQL Server 2000 SP3 and later SPs	BEA WebLogic Type 4 JDBC MS SQL Server Driver BEA WebLogic Type 4 XA JDBC MS SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems.
Oracle 8.1.7.4	Oracle Thin Driver 9.2.0 Oracle Thin Driver 10g	The Oracle Thin Driver 10g is the default driver for WebLogic Platform 8.1 SP3. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at `http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817`
Oracle 9i (9.2.0.4) and later patch sets of 9.2.x	Oracle Thin Driver 9.2.0 Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. WebLogic Platform 8.1 SP3 supports the Oracle 9.2.0.4 server and Oracle 9.2.0.4 Thin XA Driver. Obtaining specific patch sets for Oracle 9i Release 2, such as those required for Oracle 9.2.0.4, may require an Oracle Metalink (support contract) account. For details, see: `http://otn.oracle.com/support/patches.htm` The Oracle Thin Driver 10g is the default driver for WebLogic Platform 8.1 SP3.
Oracle9i RAC (for Oracle 9.2.0.4 and later patch sets of 9.2.x.x)	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Supported at this time only by WebLogic Server. For more information about requirements for configuring WebLogic Server 8.1 SP3 with Oracle9i RAC, see: `http://download.oracle.com/docs/cd/E13222_01/wls/docs81/jdbc/oracle_rac.html`
Oracle 10g (10.1.0.2) and later patch sets of 10.1.x	Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. Oracle 10.1.0.2 is supported by all components of WebLogic Platform 8.1 SP3. If you run WebLogic Platform with an Oracle 10g database (Oracle 10.1.0.2) on a 64-bit platform, and you see the error `"ORA-00600: internal error code, arguments: [qctstc2o1]"`, contact Oracle support and get the patch for Bug ID 4010945.
PointBase 4.4	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.
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	—
Other databases	Any compliant driver supplied by WebLogic Server	Other databases may be used for data access through WebLogic Server.

Database Support for WebLogic Platform 8.1 SP2

This section provides:

Note: BEA provides an SDK/Database patch for WebLogic Platform 8.1 SP2 that enables full WebLogic Platform support for the SQL Server and Sybase databases when using XA, and full WebLogic Platform DB2 support. BEA also provides a patch to support use of the Oracle Thin Driver 10g. This patch is available at the following URL:

http://commerce.bea.com/d2d/wlplat81sp2_patch.jsp

High-Level Summary of Supported Databases

Note: For detailed information about supported versions and drivers for these databases, see Table 3-11.

Table 3-10 Databases Supported by WebLogic Platform 8.1 SP2 and Components

Supported Database	Full Platform	WebLogic Server	WebLogic Workshop	WebLogic Portal	WebLogic Integration
DB2 8.1¹	^²			²	²
HP NonStop^TM SQL/MX 1.8.5³
HP NonStop^TM SQL/MX 2.0³
Oracle 8.1.7.4⁴
Oracle 9i (9.2.0.4)
PointBase 4.4	^⁵	⁵	⁵	⁵	⁵
SQL Server 2000	²				²
Sybase 12.5.03	²				²
Other Databases	^⁶	⁷			^⁸
KEY Full support Partial support No support

1. Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows.

2. Full WebLogic Platform support for this database requires the installation of the WebLogic Platform 8.1 SP2 SDK/Database patch. For more information, see WebLogic Server Support for Databases.

3. Supported only on HP NonStop Server configurations. For more information, see HP NonStop Server G06 on MIPS in 8.1 Supported Configurations: HP NonStop Server on MIPS: http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs81/hpnonstop_mips/81sp2.html.

4. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at
http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817.

5. PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.

6. Only WebLogic Server and WebLogic Integration offer partial support of databases not listed in this table.

7. The container-managed persistence (CMP) feature of WebLogic Server may not be supported with particular databases.

8. Supported only with the use of adapters.

Supported Database Versions and Drivers

The following table lists the types of databases and drivers supported for use with WebLogic Platform 8.1 SP2.

Note: For information about databases and drivers supported for use with WebLogic Server, see WebLogic Server Support for Databases on page 3-1.

Table 3-11 Database Types and Drivers Supported in WebLogic Platform 8.1 SP2

Database Type	JDBC Driver	Notes
DB2 8.1 FixPak3	BEA WebLogic Type 4 JDBC DB2 Driver BEA WebLogic Type 4 XA JDBC DB2 Driver	Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows. WebLogic Integration and WebLogic Portal 8.1 SP2 support for DB2 requires the installation of the WebLogic Platform 8.1 SP2 SDK/Database patch, which can be downloaded from: `http://commerce.bea.com/d2d/wlplat81sp2_patch.jsp`
HP NonStop^TM SQL/MX 1.8.5	SQL/MX Type 2 non-XA driver: `com.tandem.sqlmx.SQLMXDriver` SQL/MX Type 2 XA driver: `com.hp.nsk.xares.WLSTxSQLMXDataSource`	Supported only by WebLogic Server on HP NonStop Server configurations. For more information, see HP NonStop Server G06 on MIPS with 8.1 SP2 in 8.1 Supported Configurations: HP NonStop Server on MIPS: `http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs81/hpnonstop_mips/81sp2.html`
HP NonStop^TM SQL/MX 2.0	SQL/MX Type 2 non-XA driver: `com.tandem.sqlmx.SQLMXDriver` SQL/MX Type 2 XA driver: `com.hp.nsk.xares.WLSTxSQLMXDataSource`	Supported by WebLogic Server and WebLogic Integration on HP NonStop Server configurations. For more information, see HP NonStop Server G06 on MIPS with 8.1 SP2 in 8.1 Supported Configurations: HP NonStop Server on MIPS: `http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs81/hpnonstop_mips/81sp2.html`
Microsoft SQL Server 2000 SP3	BEA WebLogic Type 4 JDBC MS SQL Server Driver BEA WebLogic Type 4 XA JDBC MS SQL Server Driver	SQL Server 2000 is supported only on Microsoft operating systems. WebLogic Integration 8.1 SP2 support for the BEA WebLogic Type 4 XA JDBC MS SQL Server Driver requires the installation of the WebLogic Platform 8.1 SP2 SDK/Database patch.
Oracle 8.1.7.4	Oracle Thin Driver 9.2.0 Oracle Thin/XA Driver 9.2.0 Oracle Thin Driver 10g Oracle Thin/XA Driver 10g	WebLogic Platform 8.1 SP2 support for the Oracle Thin Driver 10g and Oracle Thin/XA Driver 10g requires the installation of the WebLogic Platform 8.1 SP2 Patch for Oracle Thin Driver 10g. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at `http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817`
Oracle RDBMS 9i (9.2.0.4) & later patch sets	Oracle Thin Driver 9.2.0 Oracle Thin Driver 10g	Oracle Thin Drivers support the Oracle database versions that are listed. WebLogic Platform 8.1 SP2 supports the Oracle 9.2.0.4 server and Oracle 9.2.0.4 Thin XA Driver. Obtaining specific patch sets for Oracle 9i Release 2, such as those required for Oracle 9.2.0.4, may require an Oracle Metalink (support contract) account. For details, see: `http://otn.oracle.com/support/patches.htm` WebLogic Platform 8.1 SP2 support for the Oracle Thin Driver 10g and Oracle Thin/XA Driver 10g requires the installation of the WebLogic Platform 8.1 SP2 Patch for Oracle Thin Driver 10g.
PointBase 4.4	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.
Sybase 12.5.03	BEA WebLogic Type 4 JDBC Sybase Driver BEA WebLogic Type 4 XA JDBC Sybase Driver	WebLogic Integration 8.1 SP2 support for the BEA WebLogic Type 4 XA JDBC Sybase Driver requires the installation of the WebLogic Platform 8.1 SP2 SDK/Database patch.
Other databases	Any compliant driver supplied by WebLogic Server	Other databases may be used for data access through WebLogic Server.

About the WebLogic Platform 8.1 SP2 SDK/Database Patch

BEA has made available an SDK/Database patch for WebLogic Platform 8.1 SP2 that enables full WebLogic Platform support for the SQL Server and Sybase databases when using XA, and full WebLogic Platform DB2 support. This patch is available at the following URL:

http://commerce.bea.com/d2d/wlplat81sp2_patch.jsp

About the WebLogic Platform 8.1 SP2 Patch for Oracle Thin Driver 10g

WebLogic Platform 8.1 SP2 support for the Oracle Thin Driver 10g and Oracle Thin/XA Driver 10g requires the installation of the WebLogic Platform 8.1 SP2 Patch for Oracle Thin Driver 10g.

The patch is available at:

http://commerce.bea.com/d2d/wlplat81sp2_patch.jsp

The Oracle 10g drivers are bundled with the patch.

Known Issues

There is one known issue with the Oracle Thin Driver 10g: it has a batch size limit of 1682 operations. In previous versions of the Oracle Thin driver, there was no apparent limit to the size of batch operations. If your application runs very large batch operations, you may see batch failures. To work around this issue, limit your batch size to 1682 or use the 9.2.0 version of the Oracle Thin driver. Oracle recommends batch sizes of between 5 and 30.

Database Support for WebLogic Platform 8.1 GA

This section provides:

Note: WebLogic Server 8.1 SP1 shipped with WebLogic Platform 8.1 GA.

High-Level Summary of Supported Databases

The following table specifies the level of support for the databases shown, for which full support, partial support, or no support are provided by the complete WebLogic Platform 8.1 product and its components in the General Availability (GA) version.

Note: For detailed information about supported versions and drivers for these databases, see Table 3-13.

Table 3-12 Databases Supported by WebLogic Platform 8.1 GA and Components

Supported Database	Full Platform	WebLogic Server	WebLogic Workshop	WebLogic Portal	WebLogic Integration
DB2 8.1¹		^²
Oracle 8.1.7³	^⁴
Oracle 9i (9.2.0)
PointBase 4.4	^⁵	⁵	⁵	⁵	⁵
SQL Server 2000	⁴
Sybase 12.5		²
Other Databases	^⁶	²			^⁷
KEY Full support Partial support No support

1. Support applies only to IBM DB2 Universal Database (UDB) v8.1 for Linux, UNIX, and Windows.

2. The container-managed persistence (CMP) feature of WebLogic Server may not be supported with particular databases.

3. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at
http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817.

4. Not supported by WebLogic Integration.

5. PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.

6. Only WebLogic Server and WebLogic Integration offer partial support of databases not listed in this table.

7. Supported only with the use of adapters.

Supported Database Versions and Drivers

The following table lists the types of databases and drivers supported for use with WebLogic Platform 8.1 GA Release.

Note: For information about databases and drivers supported for use with WebLogic Server, see WebLogic Server Support for Databases on page 3-1.

Table 3-13 Database Types and Drivers Supported in WebLogic Platform 8.1—GA Release

Database Type	JDBC Driver	Notes
Microsoft SQL Server 2000 SP3	BEA WebLogic Type 4 JDBC Microsoft SQL Server Driver	Not supported by WebLogic Integration 8.1.
Oracle 8.1.7	Oracle Thin Driver 9.2.0 Oracle Thin/XA Driver 9.2.0	Not supported by WebLogic Integration 8.1. If you are running Oracle 8.1.7 and you want to use WebLogic Portal, make sure you are running the Oracle 8.1.7.4 patch level. Oracle has announced the end of Error Correction Support for Oracle 8.1.7. For details, see "Oracle 8.1.7 End-of-Support-Announcement" at `http://download.oracle.com/docs/cd/E13196_01/platform/suppconfigs/configs/mature.html#oracle817`
Oracle 9i (9.2.0)	Oracle Thin Driver 9.2.0	When distributed transactions are used in a configuration that includes the Oracle 9.2.0 DBMS (on any operating system), BEA recommends using the Oracle 9.2.0.3 server and Oracle 9.2.0.3 Thin/XA Driver.
PointBase 4.4	PointBase Type 4 Driver	PointBase Server is an all-Java DBMS product included in the WebLogic Platform distribution solely for evaluation purposes, either in the form of custom trial applications or through packaged sample applications provided with WebLogic Platform. 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. WebLogic Integration, WebLogic Portal, and WebLogic Workshop do not support PointBase for production server deployments.