Bugs item #1012184, was opened at 2004-08-19 06:35 Message generated for change (Comment added) made by starksm You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1012184&group_id=22866
Category: JBossCMP Group: v3.2 Status: Open Resolution: Accepted Priority: 5 Submitted By: Sue Rizzo (suzyrizzo) Assigned to: Alexey Loubyansky (loubyansky) Summary: FK Violation deleting 1-1 relationship Initial Comment: 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. ---------------------------------------------------------------------- Comment By: Scott M Stark (starksm) Date: 2004-12-29 12:52 Message: Logged In: YES user_id=175228 All issues have been moved to http://jira.jboss.com. Existing issues have been moved. New issues will be closed with this canned reponse. ---------------------------------------------------------------------- Comment By: Alexey Loubyansky (loubyansky) Date: 2004-09-14 05:23 Message: Logged In: YES user_id=543482 Yes, there is a problem. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1012184&group_id=22866 ------------------------------------------------------- SF email is sponsored by - The IT Product Guide Read honest & candid reviews on hundreds of IT Products from real users. Discover which products truly live up to the hype. Start reading now. http://productguide.itmanagersjournal.com/ _______________________________________________ JBoss-Development mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-development
