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

[Alexei Guevara (JIRA)]

    [ https://jira.jboss.org/jira/browse/JBAS-1057?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12528028#action_12528028 ] 

Alexei Guevara commented on JBAS-1057:
--------------------------------------

has this issue been addressed ? if so, in which release ? 

thanks in advance

> FK Violation deleting 1-1 relationship
> --------------------------------------
>
>                 Key: JBAS-1057
>                 URL: https://jira.jboss.org/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
>            Assignee: Alexey Loubyansky
>             Fix For: Backlog
>
>
> 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: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira