[jboss-jira] [JBoss JIRA] Updated: (JBAS-1057) FK Violation deleting 1-1 relationship

[Dimitris Andreadis (JIRA)]

     [ http://jira.jboss.com/jira/browse/JBAS-1057?page=all ]

Dimitris Andreadis updated JBAS-1057:
-------------------------------------

    Fix Version/s: JBossAS-4.0.6.CR1
                       (was: JBossAS-4.0.5.CR1)

> FK Violation deleting 1-1 relationship
> --------------------------------------
>
>                 Key: JBAS-1057
>                 URL: http://jira.jboss.com/jira/browse/JBAS-1057
>             Project: JBoss Application Server
>          Issue Type: Bug
>      Security Level: Public(Everyone can see) 
>          Components: CMP service
>    Affects Versions: JBossAS-3.2.6 Final
>            Reporter: SourceForge User
>         Assigned To: Alexey Loubyansky
>             Fix For: JBossAS-4.0.6.CR1
>
>
> SourceForge Submitter: suzyrizzo .
> I have attached a set of CMPs that cause a foreign key 
> violation when deleted.
> Entities:
>   Group
>   Address
>   GroupId
> Group has a uni-directional 1-1 relationship with 
> Address.  A foreign key is set up on the 
> Group.physicalAddressKey field.
> Group has a bi-directional 1-many relationship with 
> GroupId.
> I have batch-cascade-delete turned on for the group-
> has-groupids relationship because the GroupId.groupKey 
> cannot be null.
> I do not have batch-cascade-delete turned on for the 
> group-has-address relationship because
> physicalAddressKey is an FK into Address, so Address 
> cannot be deleted before Group.
> The relationships work separately, but when I have them 
> defined at the same time, I get a Foreign Key violation.  
> I've included the server.log file with the full error 
> message in my attachment.

-- 
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