Appendix 2.  Supported Databases

Table of Contents

1. Apache Derby
2. Borland Interbase
2.1. Known issues with Interbase
3. JDataStore
4. IBM DB2
4.1. Known issues with DB2
5. Empress
5.1. Known issues with Empress
6. H2 Database Engine
6.1. Known issues with H2 Database Engine
7. Hypersonic
7.1. Known issues with Hypersonic
8. Firebird
8.1. Known issues with Firebird
9. Informix
9.1. Known issues with Informix
10. InterSystems Cache
10.1. Known issues with InterSystems Cache
11. Microsoft Access
11.1. Known issues with Microsoft Access
12. Microsoft SQL Server
12.1. Known issues with SQL Server
13. Microsoft FoxPro
13.1. Known issues with Microsoft FoxPro
14. MySQL
14.1. Known issues with MySQL
15. Oracle
15.1. Using Query Hints with Oracle
15.2. Known issues with Oracle
16. Pointbase
16.1. Known issues with Pointbase
17. PostgreSQL
17.1. Known issues with PostgreSQL
18. Sybase Adaptive Server
18.1. Known issues with Sybase

Following is a table of the database and JDBC driver versions that are supported by OpenJPA.

Table 2.1.  Supported 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
Empress 8.62 Empress Category 2 JDBC Driver 8.62
Firebird 1.5 JayBird JCA/JDBC driver 1.0.1
H2 Database Engine 1.0 H2 1.0
Hypersonic Database Engine 1.8.0 Hypersonic 1.8.0
Informix Dynamic Server 9.30.UC10 Informix JDBC driver 2.21.JC2
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 9.00.1399 (SQL Server 2005) SQLServer 1.0.809.102
Microsoft Visual FoxPro 7.0 DataDirect SequeLink 5.4.0038
MySQL 3.23.43-log MySQL Driver 3.0.14
MySQL 5.0.26 MySQL Driver 3.0.14
Oracle 8.1,9.2,10.1 Oracle JDBC driver 10.2.0.1.0
Pointbase 4.4 Pointbase JDBC driver 4.4 (4.4)
PostgreSQL 7.2.1 PostgreSQL Native Driver 8.1
PostgreSQL 8.1.5 PostgreSQL Native Driver 8.1
Sybase Adaptive Server Enterprise 12.5 jConnect 5.5 (5.5)

1.  Apache Derby

Example 2.1.  Example properties for Derby

openjpa.ConnectionDriverName: org.apache.derby.jdbc.EmbeddedDriver
openjpa.ConnectionURL: jdbc:derby:DB_NAME;create=true