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)
This archive was generated by hypermail 2.0.0 : Wed Oct 01 2008 - 17:03:13 EDT