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

Re: "Idle in Transaction" revisited.

From: Gaetano Mendola <mendola(at)bigfoot(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Subject: Re: "Idle in Transaction" revisited.
Date: 2004-09-18 10:35:18
Message-ID: 414C0F66.7090507@bigfoot.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
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.


Regards
Gaetano Mendola


In response to

Responses

pgsql-jdbc by date

Next:From: Oliver JowettDate: 2004-09-18 10:53:26
Subject: Re: "Idle in Transaction" revisited.
Previous:From: Kris JurkaDate: 2004-09-18 07:24:28
Subject: Re: "Idle in Transaction" revisited.

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