On Wed, 5 Dec 2007, jo�l Winteregg wrote:
> It's funny because I just had the same problem using Hibernate,
> Postgresql and BTM transaction manager during this week. I had many
> "<IDLE in transaction> state" which were locking my DB tables... As you
> can see (cf. pgsql-jdbc post below), the current Postgresql JDBC driver
> (XA implementation) contain a bug regarding transaction boundaries:
> http://archives.postgresql.org/pgsql-jdbc/2007-11/msg00051.php
>
This fix got into the recently released 8.2-507 that Jimmy said he tested,
so that's unlikely to be the issue.
Kris Jurka