Re: idle in transaction - Mailing list pgsql-admin

From Soeren Laursen
Subject Re: idle in transaction
Date
Msg-id 402FB228.31341.1D6C3A2@localhost
Whole thread Raw
In response to idle in transaction  (Warren Little <wlittle@securitylending.com>)
List pgsql-admin
Just a very quick thought, have You issued a:
connection.commit();

Regards,

Søren,
Subject:            [ADMIN] idle in transaction
From:               Warren Little <wlittle@securitylending.com>
To:                 pgsql-admin@postgresql.org
Date sent:          Sun, 15 Feb 2004 09:23:32 -0700

> 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
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



pgsql-admin by date:

Previous
From: Warren Little
Date:
Subject: idle in transaction
Next
From: Tom Lane
Date:
Subject: Re: SSH connection timing out