Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter

From: Oliver Jowett <oliver(at)opencloud(dot)com>
To: Andrea Spinelli <aspinelli(at)imteam(dot)it>
Cc: Kris Jurka <books(at)ejurka(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Date: 2007-08-11 23:22:18
Message-ID: 46BE44AA.4030701@opencloud.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Andrea Spinelli wrote:

> I see your point, but - as far as I know - there is no way of
> interrupting a running query (short of exiting from the main
> executable);

Statement.cancel(). If the communication between the client and server
is intact and the server is still responding, that will eventually
cancel the query. (In your case, due to a server bug the server is off
in lala land so I'd guess that cancels won't work)

-O

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Loredana Curugiu 2007-08-13 08:19:52 Re: Install two different versions of postgres which should run in parallel
Previous Message Andrea Spinelli 2007-08-10 16:53:45 Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter