Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Date
Msg-id 46BE44AA.4030701@opencloud.com
Whole thread Raw
In response to Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter  (Andrea Spinelli <aspinelli@imteam.it>)
List 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

pgsql-jdbc by date:

Previous
From: Andrea Spinelli
Date:
Subject: Re: executeQuery hangs on busy server - PROPOSAL: socketTimeout parameter
Next
From: "Loredana Curugiu"
Date:
Subject: Re: Install two different versions of postgres which should run in parallel