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

idle in transaction

From: Warren Little <wlittle(at)securitylending(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: idle in transaction
Date: 2004-02-15 16:23:32
Message-ID: 1076862212.3148.9.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: pgsql-admin
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?
We call setAutoCommit(FALSE) on every connection when created.

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


pgsql-admin by date

Next:From: Soeren LaursenDate: 2004-02-15 16:53:44
Subject: Re: idle in transaction
Previous:From: luohaoDate: 2004-02-15 12:45:09
Subject: PostgreSQL 7.4.1 under Windows/cygwin: initdb fails with error

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