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 38DD152A74
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Thu, 18 Aug 2005 20:16:28 -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 43755-01
	for <pgsql-general-postgresql.org@localhost.postgresql.org>;
	Thu, 18 Aug 2005 23:16:25 +0000 (GMT)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.207])
	by svr1.postgresql.org (Postfix) with ESMTP id B280652A44
	for <pgsql-general@postgresql.org>;
	Thu, 18 Aug 2005 20:16:23 -0300 (ADT)
Received: by zproxy.gmail.com with SMTP id z6so340964nzd
	for <pgsql-general@postgresql.org>;
	Thu, 18 Aug 2005 16:16:27 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=T62MN/UXG7In35sxYdp0chznDmHRWQKVN5Oy2Fp5rMxxQWPtDgOE2ocigAfPIwrgAVUeiVNXHAm8U+MVvn85/XyYbmNhXGdEpaYpEkGFBVFhdr0JdH1lCzNKWYeKkb2toB/V4JttfF+fYp1sixPfHN7FLCVCIC6uA9sMyrAB+ic=
Received: by 10.36.38.15 with SMTP id l15mr1557770nzl;
	Thu, 18 Aug 2005 16:16:27 -0700 (PDT)
Received: by 10.36.47.1 with HTTP; Thu, 18 Aug 2005 16:16:27 -0700 (PDT)
Message-ID: <8d04ce990508181616c93fbbc@mail.gmail.com>
Date: Thu, 18 Aug 2005 16:16:27 -0700
From: Junaili Lie <junaili@gmail.com>
To: pgsql-general@postgresql.org
Subject: <IDLE> in transaction
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.064 required=5 tests=[AWL=0.040, RCVD_BY_IP=0.024]
X-Spam-Level: 
X-Archive-Number: 200508/968
X-Sequence-Number: 82376

Hi,
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.
I am wondering if there's command/view/system tables/ tools out there
that will allow us to look at what's the in transactions that are
waiting to be committed.
We have some "<IDLE> in transaction" and would like to see which part
of the code that causes it.


Thanks in advance.

J