cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Scott Anderson" <>
Subject DbMerger and relationships
Date Wed, 01 Oct 2008 21:02:39 GMT
Does anyone know if it's possible to get information about existing relationships' UPDATE/DELETE
rules via JDBC? Looks like the DELETE rule on my Derby database isn't in sync with what Cayenne
thinks it is, but the merger isn't checking that.

Foreign  Key 'SQL081001165758000' is invalid because 'The table cannot be defined as a dependent
of table APP.ACCOUNT because of delete rule restrictions. (The relationship causes the table
to be delete-connected to the indicated table through multiple relationships and the delete
rule of the existing relationship is SET NULL.).  '.
ALTER TABLE mail ADD FOREIGN KEY (sentto) REFERENCES account (id) 

View raw message