[jboss-jira] [JBoss JIRA] Commented: (JBAS-5696) removal of entity with self-referencing CMR and fk-constraint
[ 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