On Nov 24, 2008, at 9:46 AM, J Stephanos wrote:
> 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. :-(
public static void main(String argv[])
{
ERXDatabaseContextMulticastingDelegate.addDefaultDelegate(new
ERXEntityDependencyOrderingDelegate());
...
Chuck
On Fri, Oct 24, 2008 at 11:28 PM, Chuck Hill <[EMAIL PROTECTED]
village.net> 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
--
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]
