From: Soeren Laursen <sl@scrooge.dk>
To: Warren Little <wlittle@securitylending.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: idle in transaction
Date: Sun, 15 Feb 2004 17:53:44 +0100
Message-ID: <402FB228.31341.1D6C3A2@localhost> (raw)
In-Reply-To: <1076862212.3148.9.camel@localhost.localdomain>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: sl@scrooge.dk, wlittle@securitylending.com
Subject: Re: idle in transaction
In-Reply-To: <402FB228.31341.1D6C3A2@localhost>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox