Re: Aborting SQL Statements

Derby's embedded JDBC driver doesn't support setQueryTimeOut() or cancel(). These are currently implemented to raise exception in EmbedStatement.java.

    public void setQueryTimeout(int seconds) throws SQLException {
        if (seconds != 0)
            throw Util.notImplemented("setQueryTimeout");
    }
    public void cancel() throws SQLException {
        throw Util.notImplemented("cancel");
    }

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.

Satheesh

Shreyas Kaushik wrote:

Hi all,

Can anyone let me know whether Derby supports aborting SQL Statements? And also is anybody working
to provide support for setQueryTimeOut() and cancel() in java.sql.Statement interface.

thanks
Shreyas