db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jakob Braeuchi" <jbraeu...@gmx.ch>
Subject test cases fail with foreign keys in hsqldb
Date Wed, 04 Dec 2002 21:07:47 GMT
hi all,

thanks to armin i found that torque does not create the foreign keys defined
in -schema.xml when using hsqldb. thanks to these lacking foreign keys our
test cases pass witout errors... when enabling referential integrity some
test cases fail:

java.sql.SQLException: Integrity constraint violation: TASK_FK_1 table: TASK
in statement [DELETE FROM PERSON_PROJECT WHERE (PROJECT_ID = 1)]
at org.hsqldb.Trace.getError(Unknown Source)
...
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.deleteMtoNImplementor(P
ersistenceBrokerImpl.java:856)
..
at org.apache.ojb.broker.MtoNMapping.testInsertion(MtoNMapping.java:191)

....

java.sql.SQLException: Integrity constraint violation: TASK_FK_1 table: TASK
in statement [DELETE FROM PERSON_PROJECT WHERE (PROJECT_ID = 2)]
..
org.apache.ojb.broker.singlevm.PersistenceBrokerImpl.deleteMtoNImplementor(P
ersistenceBrokerImpl.java:856)
..
at org.apache.ojb.broker.MtoNMapping.testInsertion(MtoNMapping.java:191)

the attached .vm files are the modifications i made to enable referential
integrity for hsqldb in torque.
replace those file found in torque.jar sql\base\hypersonic with the ones
attached. i already sent these files to martin poeschl of torque.

hth
jakob

Mime
View raw message