0 Replies Latest reply on Jun 10, 2006 3:06 PM by Sebastian Prehn

    ON DELETE RESTRICT -- any progress ??

    Sebastian Prehn Newbie

      Hello!

      I read the posts concerning the problem that arises when using jboss's CMP on database schemes that utilize "ON DELETE RESTRICT".
      JBoss sets the foreign keys references to NULL before actually deleting the parent entry. So the database fk-constraint exception doesnt fire
      There seems to be no direct solution yet.
      The only work arrounds that I found where defining the fk-column as "NOT NULL" which imposes other problems.

      Any updates, on how to deal with this properly?

      regards,
      Sebastian