Supported Configurations for Oracle Service Bus 10gR3

Supported Database Configurations

This section includes the following topics:

Database Access Requirements

Oracle Service Bus requires the following database-specific resources:

Access to a database server installed on the local network. When Oracle Service Bus is installed on your system, a local copy of the PointBase database is provided. This copy of the database is provided solely for evaluation purposes. For any other use of the PointBase Server, the user is required to obtain a separate PointBase Server license directly from DataMirror.
If you plan to use the JMS Reporting Provider, then a database server account with privileges sufficient for creating a database with tables must be available.

Support for JDBC Drivers

This section provides:

JDBC Drivers Bundled with Oracle Service Bus

The following table lists the database drivers that are installed with Oracle Service Bus 10gR3.

Table 3-1 Database Drivers Available with Oracle Service Bus 10gR3

Type	Drivers	For more information, see . . .
WebLogic Type 4 JDBC drivers	DB2	WebLogic Type 4 JDBC Drivers: `http://download.oracle.com/docs/cd/E13222_01/wls/docs103/jdbc_drivers/index.html`
	Oracle
	SQL Server
	Sybase
Third-party drivers supported by WebLogic Server	PointBase Type 4	"Using Third-Party Drivers with WebLogic Server" in Programming WebLogic JDBC: `http://download.oracle.com/docs/cd/E13222_01/wls/docs103/jdbc/thirdparty.html` "Using Third-Party JDBC Drivers with WebLogic Server" in Configuring and Managing WebLogic JDBC: `http://download.oracle.com/docs/cd/E13222_01/wls/docs103/jdbc_admin/third_party_drivers.html`
Third-party drivers supported by WebLogic Server	PointBase Type 4

Configuring JDBC Drivers

The Configuration Wizard and the WebLogic Server Administration Console provide default configuration settings for the drivers listed in Support for JDBC Drivers, and the drivers listed in Database Versions and Drivers Supported for Oracle Service Bus 10gR3. In some cases, support for configuring third-party drivers is provided even though the driver itself is not bundled with the product.

For more information about configuring drivers from third-party vendors, see "Using Third-Party Drivers with WebLogic Server" in Programming WebLogic JDBC at: http://download.oracle.com/docs/cd/E13222_01/wls/docs103/jdbc/thirdparty.html.

Note: Oracle Service Bus does not support custom configuration, through the Configuration Wizard, of all the third-party drivers supported for custom configuration by WebLogic Server. For a list of drivers supported by Oracle Service Bus, see Table 3-2.

Database Versions and Drivers Supported for Oracle Service Bus 10gR3

The following table lists the types and versions of databases and drivers supported for use with Oracle Service Bus 10gR3.

Table 3-2 Database Types and Drivers Supported by Oracle Service Bus 10gR3

Database Type	JDBC Driver	Notes
DB2 8.2 FixPak2 (equivalent to 8.1 FixPak 9) and later FixPaks	Oracle WebLogic Type 4 JDBC DB2 Driver Oracle WebLogic Type 4 JDBC DB2 XA Driver
DB2 9.5 and later FixPaks	Oracle WebLogic Type 4 JDBC DB2 Driver Oracle WebLogic Type 4 JDBC DB2 XA Driver
Oracle 9.2.0.4 and later patch sets of 9.2.x	Oracle WebLogic Type 4 JDBC Oracle Driver Oracle WebLogic Type 4 JDBC Oracle XA Driver Oracle Driver 10g Oracle Thin XA Driver 10g
Oracle 10.1.0.3 and later patch sets of 10.1.x (32-bit and 64-bit production editions)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g
Oracle 10.2 and later patch sets of 10.2 (32-bit and 64-bit production editions)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g
Oracle 11gR1 (Oracle 11.1.0.6+) (32-bit and 64-bit production editions)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g
Oracle 11gR2 (11.2.0.1+)(32-bit and 64-bit production editions)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g
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.
SQL Server 2005	Oracle WebLogic Type 4 JDBC SQL Server Driver
Sybase 12.5.03 and later patch levels of 12.5.x	Oracle WebLogic Type 4 JDBC Sybase Driver Oracle WebLogic Type 4 JDBC Sybase XA Driver

For more information about using database drivers, see "Using Third-Party Drivers with WebLogic Server" in Programming WebLogic JDBC at: http://download.oracle.com/docs/cd/E13222_01/wls/docs103/jdbc/thirdparty.html.

Oracle Service Bus 10gR3 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-3 Database Types and Drivers Supported by Oracle Service Bus

Database Type	JDBC Driver
Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g
Oracle 11gR1 RAC (Oracle 11.1.0.6+)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g
Oracle 11gR2 RAC (Oracle 11.2.0.1+)	Oracle Thin Driver 11g Oracle Thin XA Driver 11g

Database Type

JDBC Driver

Oracle 10gR2 RAC (for Oracle 10.2.0.1 and later patch sets of 10.2.x)

Oracle Thin Driver 11g

Oracle Thin XA Driver 11g

Oracle 11gR1 RAC (Oracle 11.1.0.6+)

Oracle Thin Driver 11g

Oracle Thin XA Driver 11g

Oracle 11gR2 RAC (Oracle 11.2.0.1+)

Oracle Thin Driver 11g

Oracle Thin XA Driver 11g