db-ojb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Russell Smyth <rsm...@computer-guidance.com>
Subject RE: test cases fail with foreign keys in hsqldb
Date Wed, 04 Dec 2002 21:35:06 GMT
I think if you are able to repair these problems you will find the number of
errors
on other platforms (ie SapDB) should be reduced greatly - I looked at them
briefly 
at one point and found that many of the problems were related to this issue.

> -----Original Message-----
> From: Jakob Braeuchi [mailto:jbraeuchi@gmx.ch]
> Sent: Wednesday, December 04, 2002 2:08 PM
> To: OJB Developers List
> Cc: OJB Users List
> Subject: test cases fail with foreign keys in hsqldb
> 
> 
> 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.deleteMto
> NImplementor(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.deleteMto
> NImplementor(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