From: "Soeren Laursen" <sl@scrooge.dk>
To: Warren Little <wlittle@securitylending.com>
Date: Sun, 15 Feb 2004 17:53:44 +0100
MIME-Version: 1.0
Subject: Re: idle in transaction
Reply-To: soeren.laursen@scrooge.dk
Cc: pgsql-admin@postgresql.org
Message-ID: <402FB228.31341.1D6C3A2@localhost>
In-reply-to: <1076862212.3148.9.camel@localhost.localdomain>
Content-type: text/plain; charset=ISO-8859-1
Content-transfer-encoding: Quoted-printable
Content-description: Mail message body

Just a very quick thought, have You issued a:
connection.commit();

Regards,

S=F8ren,
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