[jboss-jira] [JBoss JIRA] Commented: (JBAS-5696) removal of entity with self-referencing CMR and fk-constraint

Tue Jul 1 08:48:31 EDT 2008

    [ http://jira.jboss.com/jira/browse/JBAS-5696?page=comments#action_12419481 ] 

Alexey Loubyansky commented on JBAS-5696:
-----------------------------------------

If an instance is going to be removed from the table which has a self-referencing foreign key constraint and the foreign key of the instance was set to null during the transaction then at commit time an UPDATE statement will be executed to set the foreign key to null before the row is removed. This is so because currently there is no logic determining the order in which rows from the same table should be removed.

> removal of entity with self-referencing CMR and fk-constraint
> -------------------------------------------------------------
>
>                 Key: JBAS-5696
>                 URL: http://jira.jboss.com/jira/browse/JBAS-5696
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>    Affects Versions: JBossAS-4.2.2.GA, JBossAS-5.0.0.CR1
>            Reporter: Alexey Loubyansky
>         Assigned To: Alexey Loubyansky
>             Fix For: JBossAS-5.0.0.CR2
>
>
> Removal of instances in parent-children relationship belonging to the same table may result in foreign key constraint violation. The fact that the foreign keys are not set to null and the relationships still exist in the database is ignored.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira