I am interested in canceling a running query.
From this page I found the following comment: "Including 2.0, HSQLDB does not support aborting an SQL statement; calls to this method are ignored."
Does this mean that HSQLDB >2.0 does support aborting? Up to now, I was not able to abort a query.
You can connect to the database as another admin session and abort a running session. See the Guide chapter on sessions.
You are probably referring to the "ALTER SESSION <ID> CLOSE" statement? I tried it (using a separate connection) but it was not able to close a running query. What could I be doing wrong?
Does this help? http://stackoverflow.com/questions/34094074/how-to-abort-cancel-hsqldb-query?rq=1
Log in to post a comment.