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

Re: PreparedStatement timeouts?

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Paul Tomblin <ptomblin(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: PreparedStatement timeouts?
Date: 2008-08-12 23:37:01
Message-ID: 48A21E9D.7030005@opencloud.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
Paul Tomblin wrote:
> I think something like this was asked recently, but I didn't see an answer:
> 
> If I prepare a statement, is there some time after which I can't use
> it?  Or does the connection itself time out?
> I've been seeing exceptions with connections that sit idle for long
> periods of time, and I'm not sure if it's the connection or the
> prepared statement that's the problem.

There's no timeout on the PreparedStatement itself. Probably the 
connection is getting dropped by a stateful firewall between the client 
and the server after some period of inactivity.

-O

In response to

pgsql-jdbc by date

Next:From: RaghuramDate: 2008-08-13 10:12:44
Subject: Hello
Previous:From: Paul TomblinDate: 2008-08-12 21:24:08
Subject: Re: OT: Question about transactions

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