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