3. Compatible Database Matrix
Prev | Appendix 2. Supported Databases | Next

## 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 | 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)

Prev | Up | Next
2. Verified Database Matrix | Home | 4. Unverified Database Matrix