Re: WO Equivalent of prepared statement
Re: WO Equivalent of prepared statement
- Subject: Re: WO Equivalent of prepared statement
- From: Andrew Lindesay <email@hidden>
- Date: Tue, 28 Oct 2008 11:49:43 +1300
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@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden