Peter T Mount <peter(at)retep(dot)org(dot)uk> writes:
>> By the way, use con.setAutoCommit( false ) to have all the inserts in one
>> big transaction. It saves a lot of time.
> Don't forget to commit() at the end, as you can't guarantee that a
> transaction will be committed when the connection closes.
In fact, I believe that we guarantee the opposite: any open transaction
will be aborted if the client closes the connection without sending a
commit command...
regards, tom lane