One property: com.webobjects.eoaccess.ERXEntityDependencyOrderingDelegate.active = true
took care of it. WOnderful! Steve > On May 25, 2017, at 12:15 PM, Chuck Hill <ch...@gevityinc.com> wrote: > > That is in Wonder now, IIRC. > > The other thing to do, if you database supports it, is to mark the > constraints as DEFERRABLE INITIALLY DEFERRED. The delegate was intended to > handle the cases where the database did not support that. > > Chuck > > > From: Webobjects-dev > <webobjects-dev-bounces+chill=gevityinc....@lists.apple.com > <mailto:webobjects-dev-bounces+chill=gevityinc....@lists.apple.com>> on > behalf of Aaron Rosenzweig <aa...@chatnbike.com <mailto:aa...@chatnbike.com>> > Date: Thursday, May 25, 2017 at 8:32 AM > To: Steve Peery <spe...@me.com <mailto:spe...@me.com>> > Cc: WebObjects Development <webobjects-dev@lists.apple.com > <mailto:webobjects-dev@lists.apple.com>> > Subject: Re: Save order of EO objects to support database foreign key > constraints. > > Hi Steve, > > You can make a delegate to handle the ordering of database operations. > > Chuck Hill made one that might just work for you but if you need something > additionally custom you’ll have to take over. > https://lists.apple.com/archives/webobjects-dev/2007/Jun/msg00751.html > <https://lists.apple.com/archives/webobjects-dev/2007/Jun/msg00751.html> > > AARON ROSENZWEIG / Chat 'n Bike <http://www.chatnbike.com/> > e: aa...@chatnbike.com <mailto:aa...@chatnbike.com> t: (301) 956-2319 > > > > > > > On May 25, 2017, at 10:54 AM, Steve Peery <spe...@me.com > <mailto:spe...@me.com>> wrote: > > Hey List, > > I am importing a bunch of relational data into a project and when I try to > save changes I get an error something like this: > > Error when attempting to save data: EvaluateExpression failed: : Next > exception:SQL State:23000 -- error code: 1452 -- msg: Cannot add or update a > child row: a foreign key constraint fails (`valueA`.`valueB`, CONSTRAINT > `TableA_tableBID_id_FK` FOREIGN KEY (`tableBID`) REFERENCES `tableB` (`id`)) > > I know it is because they are not written to the database in the order > created. I have dealt with this in the past by doing incremental saving and > other awkward things, but in this case that would be a total pain. > > Any suggestions for the best way to deal with this? > > Thank you, > > Steve Peery > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list (Webobjects-dev@lists.apple.com > <mailto:Webobjects-dev@lists.apple.com>) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com > <https://lists.apple.com/mailman/options/webobjects-dev/aaron%40chatnbike.com> > > This email sent to aa...@chatnbike.com <mailto:aa...@chatnbike.com> >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list (Webobjects-dev@lists.apple.com) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to arch...@mail-archive.com
