[
http://jira.jboss.com/jira/browse/JBAS-1057?page=all ]
Dimitris Andreadis updated JBAS-1057:
-------------------------------------
Fix Version/s: JBossAS-4.2.1.CR1
(was: JBossAS-4.2.0.CR1)
Moving issue to a next release
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.
--
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