Re: Idle in TX / Java process hang's in the vicinity of JDBC

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: David Kerr <dmk(at)mr-paradox(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Idle in TX / Java process hang's in the vicinity of JDBC
Date: 2010-07-30 22:28:22
Message-ID: 4C535206.4070703@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Lloyd Parkes 2010-07-31 22:20:48 Re: Integer is not a subclass of Short
Previous Message David Kerr 2010-07-30 16:35:54 Re: Idle in TX / Java process hang's in the vicinity of JDBC