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) 

Reply via email to