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.