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 2.1. 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 | Oracle JDBC driver | 11.2.0.1, 11.2.0.4, 19.3.0.0 |
| PostgreSQL | 8.3.5, 8.4, 9, 11, 12, 13 | PostgreSQL Native Driver | 8.3 JDBC3 (build 603), 8.4 JDBC3 (build 701), 42.2.5, , 42.2.19 |
| MySQL | 5.0.26, 5.1.6, 5.7 | MySQL Driver | 5.1.6, 5.1.47 |
| MariaDB | 10.5 | MariaDB Driver | 2.7.2 |
| 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 |