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)
Derby 10.2.2.0
Embedded
2648
2711
DB2 9.5.2
JCC 3.50.152
40
1
MySQL 5.0.67
JDBC 5.1.6
92
1
MS SQL Server 2005 SP3 (9.00.4035)
sqljdbc4 2.0.1803.100
74
14
MS SQL Server 2008 SP2 (10.0.2531)
sqljdbc4 2.0.1803.100
75
14
Oracle 10g Express (10.2.0.1.0)
ojdbc14 10.2.0.1.0XE
116
5
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.