Table 2–2 lists databases and drivers that meet the Java EE compatibility requirements. All supported configurations of the Sun GlassFish Enterprise Server must contain at least one database/driver combination from this table, such as the bundled Java DB database and driver. In addition, the Enterprise 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.6.x, 3.7.x (Also known as Sun JDBC drivers) Note – Sun JDBC drivers are provided only with Enterprise-profile capable installation bundles. |
Type 4 |
Oracle 10g Oracle 9i Sybase ASE 12.5, 15 MS SQL 2000, 2005 DB2 9.1 DB2 8.1, 8.2 |
MySQL Connector/J Driver 3.1 |
Type 4 |
MySQL 5.0 |
Oracle 10g, 11g |
Type 4 |
Oracle 10g, Oracle 11g -RAC |
PostGres |
Type 4 |
8.1, 8.2.x |
In general, the Enterprise Server v2.1.1 supports all JDBC drivers that meet the Java EE specification.