> Are you having problems with constraint violation? No. >Your best option is to make the constraints DEFERRABLE INITIALLY DEFERRED if your database supports it.
MySQL doesn't support it. >If not, Wonder's ERXEntityDependencyOrderingDelegate is your next best choice. Do you have a sample code fragment that illustrates this workaround? What I am doing hasn't changed the insert order. :-( --JSt On Fri, Oct 24, 2008 at 11:28 PM, Chuck Hill <[EMAIL PROTECTED]>wrote: > > On Oct 24, 2008, at 9:10 PM, J Stephanos wrote: > > When we do batch inserts, the rows are inserted in random order >> instead of the order in which it is inserted in to the ec. >> How can we control to database insertion order? >> >> - create eo >> - insert in to ec >> >> - after doing about 20 inserts, we do ec.saveChanges() >> >> All rows are there in the database but the insertion order is random. >> Can this be controlled? How? >> Works fine when you save changes after every ec insert But that is >> inefficient.. >> > > > The order is undefined. Are you having problems with constraint violation? > Your best option is to make the constraints DEFERRABLE INITIALLY DEFERRED > if your database supports it. If not, Wonder's > ERXEntityDependencyOrderingDelegate is your next best choice. > > > Chuck > > > -- > Chuck Hill Senior Consultant / VP Development > > Practical WebObjects - for developers who want to increase their overall > knowledge of WebObjects or who are trying to solve specific problems. > http://www.global-village.net/products/practical_webobjects > > > > > > >
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [EMAIL PROTECTED]
