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 13. 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)