Re: Avoiding Statement.cancel() races - Mailing list pgsql-jdbc

From Kris Jurka
Subject Re: Avoiding Statement.cancel() races
Date
Msg-id Pine.LNX.4.33.0311210615030.32612-100000@leary.csoft.net
Whole thread Raw
In response to Avoiding Statement.cancel() races  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Avoiding Statement.cancel() races  (Oliver Jowett <oliver@opencloud.com>)
List pgsql-jdbc

On Fri, 21 Nov 2003, Oliver Jowett wrote:

> However there's an obvious race condition here between starting query
> execution and cancelling the statement -- it's possible for
> stopWorkerThread() to run at just the wrong time and "cancel" the statement
> before it starts execution, having no effect and leaving the worker thread
> still running a query (at least as I understand cancel() .. that's how it's
> implemented in the postgresql driver anyway).

What if calling cancel on a non running statement threw an SQLException?
Then your stopWorkerThread could retry the cancel.

Kris Jurka


pgsql-jdbc by date:

Previous
From: Oliver Jowett
Date:
Subject: Avoiding Statement.cancel() races
Next
From: "guan zhifan"
Date:
Subject: forhelp