Re: Aborting SQL Statements

Satheesh Bandaram wrote:


> But I think Derby's client JDBC driver, currently the IBM Universal
> driver, has some support. (I haven't tested it..) IBM recently announced
> contributing a Derby Client to Apache. If this client code is accepted
> and has the implementation for setQueryTimeOut() and cancel(), it might
> be easy to adapt that code to Embed driver as well.

Cancel() is a requirement for setQueryTimeout(), as I think once the
timeout has expired, setQueryTimeout() would just call cancel() or its
underlying logic. Thus if you want to implement these features, you need
to start with cancel.

I don't think the cancel in a network client will help in any way in
implementing cancel() in embedded. The cancel in embedded needs to know
about how queries or statements are executed. A starting point for
investigation would be to see how the engine handles Thread.interrupt().
Currently if a thread is interrupted the session/connection is closed, a
similar mechanism would be needed for cancel. And it might make sense to
change it so that if the thread is interrupted only the active statement
is cancelled, I know the connection closing surprised some Cloudscape
customers.

Dan.