| From: | Junaili Lie <junaili(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | <IDLE> in transaction |
| Date: | 2005-08-18 23:16:27 |
| Message-ID: | 8d04ce990508181616c93fbbc@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-interfaces |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ulises Poirier | 2005-08-18 23:35:39 | download binary version for Win32 |
| Previous Message | Oliver Jowett | 2005-08-18 23:10:42 | Re: BUG #1830: Non-super-user must be able to copy from a |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | elein | 2005-08-19 00:02:18 | Re: <IDLE> in transaction |
| Previous Message | Tom Lane | 2005-08-15 18:26:41 | Re: problems about updating a table and cluster this table at the same time |