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
tablefk.vm
Description: Binary data
foreignkey.vm
Description: Binary data
-- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
