Bugs item #1012184, was opened at 2004-08-19 08:35 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: None Priority: 5 Submitted By: Sue Rizzo (suzyrizzo) Assigned to: Nobody/Anonymous (nobody) 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. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=376685&aid=1012184&group_id=22866 ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development
