Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow - Mailing list pgsql-interfaces

From Tom Lane
Subject Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow
Date
Msg-id 23467.927837887@sss.pgh.pa.us
Whole thread Raw
In response to Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow  (Peter T Mount <peter@retep.org.uk>)
List pgsql-interfaces
Peter T Mount <peter@retep.org.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


pgsql-interfaces by date:

Previous
From: JT Kirkpatrick
Date:
Subject: illegal page faults. . .
Next
From: Tom Lane
Date:
Subject: Re: [INTERFACES] Wierd error when creating a table...