Re: PreparedStatement timeouts?

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