From: Kris Jurka <books@ejurka.com>
To: Junaili Lie <junaili@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: <IDLE> in transaction
Date: Thu, 18 Aug 2005 22:00:44 -0500 (EST)
Message-ID: <Pine.BSO.4.62.0508182157090.17362@leary.csoft.net> (raw)
In-Reply-To: <8d04ce990508181616c93fbbc@mail.gmail.com>
References: <8d04ce990508181616c93fbbc@mail.gmail.com>
On Thu, 18 Aug 2005, Junaili Lie wrote:
> We have applications that sits on top of Java application server. Our
> code is written in Java, sitting on top of Jboss with Hibernate, and
> we use JDBC driver pg74.215.jdbc2ee.jar. We have observed a number of
> <IDLE> in transaction on pg_stat_activity.
This is an issue with the 7.4 JDBC driver. It issues BEGIN statements
prior to any commands being issued, so the connection is always in an open
transaction even if it hasn't done anything. The 8.0 driver (which may be
used against a 7.4 server) should fix this issue.
Elein, who replied as well, has been seeing another issue where the idle
transaction holds some locks blocking other connections. This points to a
problem in either hibernate or the application code, but the first step to
solving it is definitely moving away from the 7.4 driver.
Kris Jurka
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-interfaces@postgresql.org
Cc: books@ejurka.com, junaili@gmail.com, pgsql-general@postgresql.org
Subject: Re: <IDLE> in transaction
In-Reply-To: <Pine.BSO.4.62.0508182157090.17362@leary.csoft.net>
* 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