Re: EOF - rows inserted in to database in random order on ec.savechanges()
Re: EOF - rows inserted in to database in random order on ec.savechanges()
- Subject: Re: EOF - rows inserted in to database in random order on ec.savechanges()
- From: "J Stephanos" <email@hidden>
- Date: Mon, 24 Nov 2008 12:46:47 -0500
> 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@hidden> 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..
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden