We are working with Active Objects in Confluence Data Center (are we the last ones?). We have a foreign key between two records. Postgres, for example, has the following options:
- ON DELETE RESTRICT: Throw an exception,
- ON DELETE CASCADE: Delete the parent record too,
- SET NULL: Set the value to null when the child is deleted,
- SET DEFAULT.
ActiveObjects uses RESTRICT by default, which means it produces the following exception:
java.sql.SQLIntegrityConstraintViolationException: integrity constraint violation: foreign key no action; FK_AO_32F7CE_TABLE_COLUMN_ID table: AO_32F7CE_OTHERTABLE
Is there any way to tell ActiveObjects to set “null” when we delete the parent record, for example using a @OneToMany or @OneToOne annotation?