I have never done this from a WO app, but in my day job, where I
build websites using various scripting languages, I do this sort of
thing by taking the data, building an input file to Oracle's sqlldr
program, and execing out to run sqlldr. If you don't need
application logic during the upload and are just shoving data into
tables, their bulk loader is very, very fast.
janine
On Sep 26, 2007, at 6:14 AM, Shravan Kumar.M wrote:
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/janine%
40furfly.net
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]
