OpenJPA Logo   ASF Logo

JPA 2.0 Test Coverage

Starting with OpenJPA 2.0.0, we have split the supported databases into verified and compatible categories. The automated database testing performed by IBM and regular testing performed by the OpenJPA community in the lists below, are used to determine which databases will be listed as verified instead of just compatible.

Automated Database Coverage

JUnit results for OpenJPA supported databases being tested nightly by IBM using Java SE 6 (either IBM SDK or Sun JDK).

(/) - All tests passed
(x) - Number of failing tests

Database JDBC Driver M3 (I11 - 20091005) Beta (I14 - 20100125) Beta2 (20100224) Beta3 (20100323)
Derby 10.2.2.0 Embedded (/) 2711 (/) 2904
Derby 10.5.3.0 Embedded (/) 3004 (/) 3049
DB2 9.5.2 JCC 3.50.152 2 (x) 1 (x) (/) 3004 1 (x)
HSQLDB 1.8.0.10 Embedded in-memory 13 (x) 12 (x) 12 (x) 16 (x)
MySQL 5.0.67 JDBC 5.1.6 1 (x) (/) (/) 2 (x)
MS SQL Server 2005 SP3 (9.00.4035) sqljdbc4 2.0.1803.100 14 (x) 8 (x) 8 (x) 10 (x)
MS SQL Server 2008 SP2 (10.0.2531) sqljdbc4 2.0.1803.100 14 (x) 5 (x) 5 (x) 8 (x)
Oracle 10g Express (10.2.0.1.0) ojdbc14 10.2.0.1.0XE 5 (x) 3 (x) 5 (x) in locking 1 (x) + locking

Manual Database Coverage

If you regularly test OpenJPA 2.0.x against another DB vendor or level not listed above and would like to share your results, then feel free to add them below. All we ask, is that you provide as much of the details requested below, so others can make their own decision on whether to use one of these combinations in their environment.

Database JDBC Driver Java SVN Rev Results Submitter Notes
Derby 10.3.3.0 (652961) Embedded Sun 1.6.0_15 r817831 (20090922) 2 (x) dwoods OPENJPA-1322
Derby 10.4.2.0 (689064) Embedded Sun 1.6.0_15 r817831 (20090922) 2 (x) dwoods OPENJPA-1322
Derby 10.5.3.0 (802917) Embedded Sun 1.6.0_15 r813659 (20090910) 1 (x) dwoods OPENJPA-1293
MS SQL Server 2008 (10.00.1600) jTDS 1.2.5 Sun 1.5.0_11-b03 r895453 (20100103) 4 (x) mtylenda did not run locking tests
PostgreSQL 8.3.5 8.4 JDBC3 (build 701) Sun 1.5.0_11-b03 r885965 (20091201) 31 (x) mtylenda AccessToUnderlyingConnectionAllowed DBCP property set to true, 12 failures come from locking tests
H2 1.1.118 Embedded Sun 1.5.0_11-b03 r905001 (20100131) 48 (x) mtylenda in-memory named database, 47 failures come from locking tests; with MVCC option turned on there are 23 failures from locking tests, OPENJPA-1367
Copyright © 2006,2013 The Apache Software Foundation. Licensed under Apache License 2.0.
Apache, the Apache feather logo and OpenJPA are trademarks of The Apache Software Foundation.
Other names may be trademarks of their respective owners.