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 12. 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, 10.8.2.2, 10.14.2.0

Apache Derby Embedded JDBC Driver

Same as Database Version

H2

1.4.195, 1.4.196

H2 Embedded JDBC Driver

Same as Database Version

Microsoft SQL Server

2005 (9.00), 2008 (10.00), 2017

Microsoft SQL Server JDBC Driver

1.2 or 2.0, 9.2.1

Oracle

10g (10.1, 10.2), 11g (11.1, 11.2), 12c, 18c, 19c, 21c

Oracle JDBC driver

11.2.0.1, 11.2.0.4, 19.3.0.0, 23.26.2.0

PostgreSQL

8.3.5, 8.4, 9, 11, 12, 13, 16, 18

PostgreSQL Native Driver

8.3 JDBC3 (build 603), 8.4 JDBC3 (build 701), 42.2.5, , 42.2.19, 42.7.13

MySQL

5.0.26, 5.1.6, 5.7, 9.7.0

MySQL Driver

5.1.6, 5.1.47, 9.7.0

MariaDB

10.5, 12.3.2

MariaDB Driver

3.5.8

Hypersonic HSQLDB

2.5.1

HSQLDB Driver

Same as Database 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

IBM solidDB

6.5.0.0

solidDB JDBC Driver

2.0

Sybase Adaptive Server Enterprise

12.5, 15.0

jConnect

5.5, 6.0