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 Platform 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
Java DB Network Client	Type 4	Apache Derby 10.1
DataDirect 3.5	Type 4	Oracle 9i, 10g

Table 2–3 lists all the additional databases and drivers Sun has tested internally.

Table 2–3 Additional Supported JDBC Drivers and Databases

JDBC Driver Vendor	JDBC Driver Type	Supported Database Server
DataDirect 3.5	Type 4	Sybase ASE 12.5, 15  Microsoft SQL Server 2000, 2005  IBM DB2 8.1, 8.2
IBM	Type 2	IBM DB2 8.1, 8.2
Microsoft MS SQL	Type 4	SQLServer 2000, 2005
MySQL Connector/J Driver 3.1	Type 4	MySQL 5
Oracle	Type 4	Oracle 9i, 10g
Postgres	Type 4	Postgres 8.1
Sybase	Type 4	ASE 12.5, 15

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