Bugs item #1012184, was opened at 2004-08-19 16:35 Message generated for change (Comment added) made by loubyansky 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: Alexey Loubyansky (loubyansky) Date: 2004-09-14 15: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 ------------------------------------------------------- This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 Project Admins to receive an Apple iPod Mini FREE for your judgement on who ports your project to Linux PPC the best. Sponsored by IBM. Deadline: Sept. 13. Go here: http://sf.net/ppc_contest.php _______________________________________________ JBoss-Development mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-development