Hello Randy;

Would raw-rows partitioned by some element in your entity work OK in this situation for you instead of dropping to JDBC's prepared stmts?

It might be best to get a different JDBC connection by using the connection dictionary information rather than use EOF's one because if EOF goes and does something else with the connection, you may end up with concurrency issues. If you did want to get the JDBC connection used by EOF, maybe have a look at;

        LEEOHelper.refreshDatabaseConnectionsForModel(..)

...in my framework. I'm not quite sure where I got that from so it is not "pre-approved", but it seems to work fine.

cheers

Is there a pre-approved way of getting a JDBC connection from an EOModel?
...
I am processing millions of rows of data, and the output is very large tables. I would like to use an equivalent of preparedstatements for my writing&updating; there is less need for transactional integrity and more need of raw speed.
...
Use JDBC directly. That should give you the ability of prepared statements.

___
Andrew Lindesay
www.lindesay.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/archive%40mail-archive.com

This email sent to [EMAIL PROTECTED]

Reply via email to