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
- Number of failing tests

Database JDBC Driver I10 (20090901) I11/M3 (20091005) I12 (20091102)
Derby 10.2.2.0 Embedded 2648 2711 2788
DB2 9.5.2 JCC 3.50.152 40 1 1
MySQL 5.0.67 JDBC 5.1.6 92 1 1
MS SQL Server 2005 SP3 (9.00.4035) sqljdbc4 2.0.1803.100 74 14 14
MS SQL Server 2008 SP2 (10.0.2531) sqljdbc4 2.0.1803.100 75 14 14
Oracle 10g Express (10.2.0.1.0) ojdbc14 10.2.0.1.0XE 116 5 4


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 dwoods OPENJPA-1322
Derby 10.4.2.0 (689064) Embedded Sun 1.6.0_15 r817831 (20090922) 2 dwoods OPENJPA-1322
Derby 10.5.3.0 (802917) Embedded Sun 1.6.0_15 r813659 (20090910) 1 dwoods OPENJPA-1293
PostgreSQL 8.3.5 8.3 JDBC3 (build 603) Sun 1.5.0_11-b03 r814302 (20090913) 64 mtylenda  
DB2 9.7.0 JCC 3.57.82 IBM 1.6.0 SR5 r819280 (20090928) TBD dwoods  
H2 1.1.118 Embedded Sun 1.5.0_11-b03 r826468 (20091018) 56 mtylenda in-memory named database, 48 failures come from locking tests
HSQLDB 1.8.0.10 Embedded Sun 1.6.0_15 r832357 (20091103) 13 dwoods Used in-memory db. OPENJPA-1369
             


Copyright (C) 2005-2009 Apache Software Foundation. Licensed under Apache License 2.0.
Apache, the Apache feather logo and OpenJPA are trademarks of Apache Software Foundation.