Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Migrated to Confluence 4.0

...

JUnit results for OpenJPA supported databases being tested nightly by IBM using Java SE 6 (either IBM SDK or Sun JDK).
(tick) - All tests passed
(error) - Number of failing tests

Database

JDBC Driver

I10 (20090901)

M3 (I11 - 20091005)

Beta (I14 - 20100125)

Beta2 (20100224)

Beta3 (20100323 I11/M3 (20091005)

Derby 10.2.2.0

Embedded

(tick) 2711

(tick) 2904

 

 

Derby 10.5.3.0

Embedded

 

 

(tick) 2648 3004

(tick) 2711 3049

DB2 9.5.2

JCC 3.50.152

2 (error)

1 (error)

(tick) 3004

1 40 (error)

HSQLDB 1.8.0.10

Embedded in-memory

13 (error)

12 (error)

12 (error)

16 (error)

MySQL 5.0.67

JDBC 5.1.6

92 1 (error)

(tick)

(tick)

2 1 (error)

MS SQL Server 2005 SP3 (9.00.4035)

sqljdbc4 2.0.1803.100

14 (error)

8 (error)

8 74 (error)

14 10 (error)

MS SQL Server 2008 SP2 (10.0.2531)

sqljdbc4 2.0.1803.100

14 (error)

5 (error)

5 75 (error)

14 8 (error)

Oracle 10g Express (10.2.0.1.0)

ojdbc14 10.2.0.1.0XE

5 (error)

3 116 (error)

5 (error) in locking

1 (error) + 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 (error)

dwoods

OPENJPA-1322

Derby 10.4.2.0 (689064)

Embedded

Sun 1.6.0_15

r817831 (20090922)

2 (error)

dwoods

OPENJPA-1322

Derby 10.5.3.0 (802917)

Embedded

Sun 1.6.0_15

r813659 (20090910)

1 (error)

dwoods

OPENJPA-1293

MS SQL Server 2008 (10.00.1600)

jTDS 1.2.5

PostgreSQL 8.3.5

8.3 JDBC3 (build 603)

Sun 1.5.0_11-b03

r814302 r895453 (2009091320100103)

64 4 (error)

mtylenda

 

DB2 9.7.0

did not run locking tests

PostgreSQL 8.3.5

8.4 JDBC3 (build 701)

Sun 1.5.0_11-b03

r885965 (20091201)

31 (error)

mtylenda

AccessToUnderlyingConnectionAllowed DBCP property set to true, 12 failures come from locking tests

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 r905001 (2009101820100131)

56 48 (error)

mtylenda

in-memory named database, 48 47 failures come from locking tests

HSQLDBHSQLDB 1.8.0.10 1.8.0.10

EmbeddedEmbedded

SunSun 1.6.0_15 1.6.0_15

r831334r831334 (20091030) (20091030)

271271 (error) (error)

dwoodsdwoods

UsedUsed in-memory db. OPENJPA-1369 in-memory db. OPENJPA-1369

 

 

 

 

 

 

 ; with MVCC option turned on there are 23 failures from locking tests, OPENJPA-1367