Appendix 2.  Supported Databases

Table of Contents

1. Overview
2. Verified Database Matrix
3. Compatible Database Matrix
4. Apache Derby
5. Borland Interbase
5.1. Known issues with Interbase
6. JDataStore
7. IBM DB2
7.1. Known issues with DB2
8. Empress
8.1. Known issues with Empress
9. H2 Database Engine
9.1. Known issues with H2 Database Engine
10. Hypersonic
10.1. Known issues with Hypersonic
11. Firebird
11.1. Known issues with Firebird
12. Informix
12.1. Known issues with Informix
13. Ingres Database
13.1. Known issues with Ingres
14. InterSystems Cache
14.1. Known issues with InterSystems Cache
15. Microsoft Access
15.1. Known issues with Microsoft Access
16. Microsoft SQL Server
16.1. Known issues with SQL Server
17. Microsoft FoxPro
17.1. Known issues with Microsoft FoxPro
18. MySQL
18.1. Using Query Hints with MySQL
18.2. Known issues with MySQL
19. Oracle
19.1. Using Query Hints with Oracle
19.2. Known issues with Oracle
20. Pointbase
20.1. Known issues with Pointbase
21. PostgreSQL
21.1. Known issues with PostgreSQL
22. Sybase Adaptive Server
22.1. Known issues with Sybase

1.  Overview

The following appendix covers the database and JDBC driver versions that are known to work with OpenJPA, along with any database specific configuration parameters, known issues or limitations. The Verified Database Matrix, contains the list of databases and drivers that were tested extensively against this release of OpenJPA, while the Compatible Database Matrix contains the list of databases and drivers that were tested against prior releases or by OpenJPA users and may not support every feature of this release.