Re: "Idle in Transaction" revisited.

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