Postgres Pro
Downloads
Home   >   mailing lists

idle in transaction - Mailing list pgsql-admin

From Warren Little
Subject idle in transaction
Date
Msg-id 1076862212.3148.9.camel@localhost.localdomain
Whole thread Raw
Responses Re: idle in transaction  ("Soeren Laursen" <sl@scrooge.dk>)
Re: idle in transaction  ("Marc Mitchell" <marcm@eisolution.com>)
List pgsql-admin
Tree view 
We recently upgraded postgres from 7.3 to 7.4, along with the JDBC jar,
and noticed all the backend processes/connections are left in the "idle
in transaction" state where before they where left in the "idle" state.
Has something changed in the 7.4 jdbc driver vs 7.3 which might be
causing this?
Note
We call setAutoCommit(FALSE) on every connection when created.



--
Warren Little
Senior Vice President
Secondary Marketing
Security Lending Wholesale, LC
www.securitylending.com
Tel: 866-369-7763
Fax: 866-849-8082

pgsql-admin by date:

Previous
From: "luohao"
Date:
Subject: PostgreSQL 7.4.1 under Windows/cygwin: initdb fails with error
Next
From: "Soeren Laursen"
Date:
Subject: Re: idle in transaction