3.  Compatible Database Matrix

Following is a table of the database and JDBC driver versions that are compatible with OpenJPA. Some of these databases have been tested against this version of OpenJPA, while others were added or tested in prior releases and may not support all of the new features of this release. For the list of databases that have been fully tested against this release, please refer to the Verified Database Matrix section.

Table 2.2.  Compatible Databases and JDBC Drivers

Database Name Database Version JDBC Driver Name JDBC Driver Version
Apache Derby Apache Derby Embedded JDBC Driver
Borland Interbase Interclient 4.5.1
Borland JDataStore 6.0 Borland JDataStore 6.0
DB2 8.1 IBM DB2 JDBC Universal Driver 1.0.581, 2.10.72
Empress 8.62 Empress Category 2 JDBC Driver 8.62
Firebird 1.5, 2.0, 2.1 JayBird JCA/JDBC driver 2.1.6
H2 Database Engine 1.1.118 H2 Same as Database Version
Hypersonic Database Engine 1.8.0, 2.0.1 RC2 Hypersonic Same as Database Version
Informix Dynamic Server 9.30.UC10, 9.4xC7 Informix JDBC driver 2.21.JC2, 3.00 JC3, 3.10 JC1
Ingres Database 9.2 Ingres JDBC Driver 9.2-3.4.8
InterSystems Cache 5.0 Cache JDBC Driver 5.0
Microsoft Access 9.0 (a.k.a. "2000") DataDirect SequeLink 5.4.0038
Microsoft SQL Server 2000 (8.00) Microsoft SQL Server JDBC Driver 1.2
Microsoft Visual FoxPro 7.0 DataDirect SequeLink 5.4.0038
MySQL 3.23.43-log MySQL Driver 3.0.14
Oracle 8.1, 9.2 Oracle JDBC driver
Pointbase 4.4 Pointbase JDBC driver 4.4 (4.4)
PostgreSQL 7.2.1, 8.1.5 PostgreSQL Native Driver 8.1
IBM solidDB solidDB JDBC Driver 2.0
Sybase Adaptive Server Enterprise 12.5 jConnect 5.5 (5.5)