Thanks for all your participation.

Am trying out all your suggestions and will update this list going forward.

I have tried Ulrich's advise of creating a new EOObjectStore and creating a new EOEditingContext in this EOObjectStore, but this seems to take more time than just using the actual EOObjectStore and just creating EOEditingContext for every n-number of records, for us 'n' is 100.

Thanks & Rgds,
Shravan Kumar.M

"Let us learn from the past to profit by the present,and from the present to live better in the future."
--William WordsWorth
---------------------------------------------------------------


On 26-Sep-07, at 5:49 PM, Steven Mark McCraw wrote:

I agree with Simon. I used to try to use WebObjects for this kind of thing, but it is a never ending pain. EOF is especially terrible for that kind of task. If you can just write a perl script or something, things will go a lot easier (perl is great for this kind of task). If you have to have it in java, consider making a straight JDBC connection. I'm not sure if you can do inserts through EOUtilities.rawRowsForSQL, but I would try it. Otherwise, if you google around a bit you can find out how to push the raw SQL through EOAdaptorChannel.


On Sep 26, 2007, at 6:15 AM, Shravan Kumar.M wrote:

No! its Oracle 9i.




On 26-Sep-07, at 3:43 PM, Andrew Lindesay wrote:

Hello Shravan;

We recently had a problem of not able to upload a file having 40K number of records from our WebObjects application to the database. We used to get java.lang.OutOfMemoryError after uploading

Is MySQL involved per chance?

cheers.

___
Andrew Lindesay
technology : www.lindesay.co.nz
business : www.silvereye.co.nz




 _______________________________________________
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/mark% 40bluecollarsoftware.com

This email sent to [EMAIL PROTECTED]


 _______________________________________________
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]

Reply via email to