Re: Idle in TX / Java process hang's in the vicinity of JDBC - Mailing list pgsql-jdbc

David Kerr wrote:

> we've got a working theory that the program opens up a connection to
> DB1 and DB2.  In DB1 we're running a very long query (15 minutes) and
> after some sort of timeout(or something) the program hangs leaving the
> idle in TX in DB2.

You may want to look at any firewalls you have between the client and
the DBs. Often, stateful firewalls will drop state for connections that
are idle for extended periods.

-O