Hi,
Thanks for that..it does seem like committing on the session
causes the connection to be closed, but I can write a workaround.
I m about to implement the multiple inserts changes but I thought this
would be a quick bang or a small amount of effort.
http://www.nevermind.co.nz/2009/10/13/s
On Oct 30, 2009, at 9:45 AM, Nathan Harmston wrote:
>
> Hi,
>
> I have a script which will process a large amount of data and save
> some of those results to the database. This takes a large amount of
> time and so what I would do in something like java is to lock the
> tables before processing,
