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