Description Fred Toussi 2010-12-01 08:44:02 EST

Build Identifier: EclipseLink v. 2.10

One of the JPA tests published at http://www.jpab.org/EclipseLink.html causes this failure when used with four different open source databases. The exception is MySQL which by default does not enforce foreign key constraints.

Sample error message:

DELETE on table 'NODE' caused a violation of foreign key constraint 'FK_NODE_CHILD1_ID' for key (110036).  The statement has been rolled back.

Note, the reported HSQLDB 2.0.0 failures relate to the separate issue with lack of size specification with some VARCHAR(n) declarations. This can be avoided by specifying sql.enforce_strict_size=false;sql.enforce_size=false in the HSQLDB connection URL.

Reproducible: Always

Steps to Reproduce:
1. Download the Jpab package
2. Follow instructions to test with EclipseLink and one of the databases