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

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