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