John R Pierce wrote:
> I'm curious what common practice is for threads that do nothing but
> SELECTS... do folks just enable auto_commit, thereby preventing pgJDBC
> from doing BEGIN; ? Do they lace their code with COMMIT() calls?
We were bitten by this problem too, and my solution was to suggest our
developer to do and explicit: "ABORT" after the connection, and do
explicit "BEGIN" "END" instead of rely on the jdbc interface.
In response to
pgsql-jdbc by date
|Next:||From: Oliver Jowett||Date: 2004-09-18 10:53:26|
|Subject: Re: "Idle in Transaction" revisited.|
|Previous:||From: Kris Jurka||Date: 2004-09-18 07:24:28|
|Subject: Re: "Idle in Transaction" revisited. |