Re: PreparedStatement timeouts? - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: PreparedStatement timeouts?
Date
Msg-id 48A21E9D.7030005@opencloud.com
Whole thread Raw
In response to PreparedStatement timeouts?  ("Paul Tomblin" <ptomblin@gmail.com>)
List 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

pgsql-jdbc by date:

Previous
From: Paul Tomblin
Date:
Subject: Re: OT: Question about transactions
Next
From: Warren Bell
Date:
Subject: Problem escaping, nonstandard use of \\ in a string literal