[JBoss-dev] [ jboss-Bugs-1012184 ] FK Violation deleting 1-1 relationship
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=detailatid=376685aid=1012184group_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=detailatid=376685aid=1012184group_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 JBoss-Development@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/jboss-development
[JBoss-dev] [ jboss-Bugs-1012184 ] FK Violation deleting 1-1 relationship
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=detailatid=376685aid=1012184group_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=detailatid=376685aid=1012184group_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
[JBoss-dev] [ jboss-Bugs-1012184 ] FK Violation deleting 1-1 relationship
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=detailatid=376685aid=1012184group_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=detailatid=376685aid=1012184group_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
