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 | 10.1.2.1 | Apache Derby Embedded JDBC Driver | 10.1.2.1 |
| Borland Interbase | 7.1.0.202 | 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 | 10.2.0.1 |
| Pointbase | 4.4 | Pointbase JDBC driver | 4.4 (4.4) |
| PostgreSQL | 7.2.1, 8.1.5 | PostgreSQL Native Driver | 8.1 |
| IBM solidDB | 6.5.0.0 | solidDB JDBC Driver | 2.0 |
| Sybase Adaptive Server Enterprise | 12.5 | jConnect | 5.5 (5.5) |