2.  Verified Database Matrix

Following is a table of the supported database and JDBC driver versions that have been verified against this version of OpenJPA. For the list of other databases and drivers that were tested in prior releases or by other OpenJPA users, but may not support every feature of this release, please refer to the Compatible Database Matrix section.

Table 2.1.  Supported Databases and JDBC Drivers

Database Name Database Version JDBC Driver Name JDBC Driver Version
Apache Derby 10.2.2.0, 10.3.3.0, 10.4.2.0, 10.5.3.0 Apache Derby Embedded JDBC Driver Same as DB Version
IBM DB2 8.1, 8.2, 9.1, 9.5, 9.7 IBM DB2 JDBC Universal Driver 3.50.152
IBM Informix Dynamic Server 10.00xC6, 11.10xC1, 11.5xC1 Informix JDBC driver 3.00 JC3, 3.10 JC1, 3.50 JC1
Microsoft SQL Server 2005 (9.00), 2008 (10.00) Microsoft SQL Server JDBC Driver 1.2 or 2.0
MySQL 5.0.26, 5.1.6 MySQL Driver 5.1.6
Oracle 10g (10.1, 10.2), 11g (11.1, 11.2) Oracle JDBC driver 11.2.0.1
PostgreSQL 8.3.5, 8.4 PostgreSQL Native Driver 8.3 JDBC3 (build 603), 8.4 JDBC3 (build 701)
Sybase Adaptive Server Enterprise 12.5, 15.0 jConnect 5.5, 6.0