Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Peter T Mount <peter(at)retep(dot)org(dot)uk>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] Re: [GENERAL] JDBC and insert - stack overflow
Date: 1999-05-27 20:44:47
Message-ID: 23467.927837887@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
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

pgsql-interfaces by date

Next:From: Tom LaneDate: 1999-05-27 20:54:52
Subject: Re: [INTERFACES] Wierd error when creating a table...
Previous:From: JT KirkpatrickDate: 1999-05-27 18:29:36
Subject: illegal page faults. . .

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group