JDBC Drivers and Databases

Table 2–2 lists databases and drivers that meet the Java EE compatibility requirements. All supported configurations of the Sun Java System Application Server Enterprise Edition must contain at least one database/driver combination from this table, such as the bundled Java DB database and driver. In addition, the Application Server is designed to support JDBC connectivity to any additional DBMS with a corresponding JDBC driver.

Table 2–2 Java EE-Compatible JDBC Drivers

JDBC Driver Vendor	JDBC Driver Type	Supported Database Server
Derby Network Client	Type 4	Derby 10.2
DataDirect 3.60.29	Type 4	Oracle 10g
DataDirect 3.6	Type 4	DB2 9.1  DB2 8.2
Oracle Thin	Type 4	Oracle 10g
PostGres	Type 4	8.1
MySQL Connector/J Driver 3.1	Type 4	MySQL 5

Table 2–3 lists all the additional databases and drivers scheduled to be supported in the Application Server FCS release.

Table 2–3 Supported JDBC Drivers and Databases (Application Server FCS)

JDBC Driver Vendor	JDBC Driver Type	Supported Database Server
Oracle OCI	Type 2	Oracle 9i
IBM DB2	Type 2	DB2 9.1
Oracle 10G	Type 4	-RAC
DataDirect 3.60.29	Type 4	Sybase ASE 15  MS SQL 2005
MySQL Connector/J Driver 3.1	Type 4	MySQL 5

In general, the Application Server Enterprise Edition 9.1 supports all JDBC drivers that meet the Java EE specification.