Supported Configurations for ALSB3.0

Supported Database Configurations

This section includes the following topics:

Database Access Requirements

ALSB 3.0 requires the following database-specific resources:

Access to a database server installed on the local network. When AquaLogic 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 AquaLogic Service Bus

The following table lists the database drivers that are installed with ALSB 3.0.

Table 3-1 Database Drivers Available with ALSB 3.0

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/docs100/jdbc_drivers/index.html`
	Oracle
	SQL Server
	Sybase
Third-party drivers supported by WebLogic Server	Oracle Thin Driver 10g	"Using Third-Party Drivers with WebLogic Server" in Programming WebLogic JDBC: `http://download.oracle.com/docs/cd/E13222_01/wls/docs100/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/docs100/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 ALSB 3.0. 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/docs100/jdbc/thirdparty.html.

Note: ALSB 3.0 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 ALSB 3.0, see Table 3-2.

Database Versions and Drivers Supported for ALSB 3.0

The following table lists the types and versions of databases and drivers supported for use with ALSB 3.0.

Table 3-2 Database Types and Drivers Supported by ALSB 3.0

Database Type	JDBC Driver	Notes
DB2 8.2 FixPak2 (equivalent to 8.1 FixPak 9) and later FixPaks	BEA WebLogic Type 4 JDBC DB2 Driver BEA WebLogic Type 4 JDBC DB2 XA Driver
Oracle 9.2.0.4 and later patch sets of 9.2.x	BEA WebLogic Type 4 JDBC Oracle Driver BEA 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 Driver 10g Oracle Thin/XA Driver 10g
Oracle 10.2 and later patch sets of 10.2 (32-bit and 64-bit production editions)	Oracle Driver 10g Oracle Thin/XA Driver 10g
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 2000	BEA WebLogic Type 4 JDBC SQL Server XA Driver
SQL Server 2000 SP3+	BEA WebLogic Type 4 JDBC SQL Server Driver
SQL Server 2005	BEA WebLogic Type 4 JDBC SQL Server Driver
Sybase 12.5.03 and later patch levels of 12.5.x	BEA WebLogic Type 4 JDBC Sybase Driver BEA 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/docs100/jdbc/thirdparty.html.