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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-jdbc by date

  From Date Subject
Next Message Raghuram 2008-08-13 10:12:44 Hello
Previous Message Paul Tomblin 2008-08-12 21:24:08 Re: OT: Question about transactions