X-Original-To: pgsql-general-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id A955C52C3A
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Aug 2005 00:00:53 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 08598-03
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Fri, 19 Aug 2005 03:00:51 +0000 (GMT)
Received: from mail63.csoft.net (leary3.csoft.net [63.111.22.74])
	by svr1.postgresql.org (Postfix) with SMTP id 2293552C17
	for <pgsql-general@postgresql.org>;
	Fri, 19 Aug 2005 00:00:47 -0300 (ADT)
Received: (qmail 6853 invoked by uid 1112); 19 Aug 2005 03:00:44 -0000
Date: Thu, 18 Aug 2005 22:00:44 -0500 (EST)
From: Kris Jurka <books@ejurka.com>
X-X-Sender: books@leary.csoft.net
To: Junaili Lie <junaili@gmail.com>
Cc: pgsql-general@postgresql.org
Subject: Re: <IDLE> in transaction
In-Reply-To: <8d04ce990508181616c93fbbc@mail.gmail.com>
Message-ID: <Pine.BSO.4.62.0508182157090.17362@leary.csoft.net>
References: <8d04ce990508181616c93fbbc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.008 required=5 tests=[AWL=0.008]
X-Spam-Level: 
X-Archive-Number: 200508/978
X-Sequence-Number: 82386



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