idle in transaction

From: Warren Little <wlittle(at)securitylending(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: idle in transaction
Date: 2004-02-15 17:33:48
Message-ID: 1076866428.3148.14.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

I recently posted this on pgsql-admin and was directed to try this list
as well.

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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Chris Smith 2004-02-15 17:59:57 Re: jdbc supportsStoredProcedures
Previous Message Chris Smith 2004-02-15 16:40:58 PATCH - watch transaction state and improve transaction handling