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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
