Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group