Cancel slow running queries

  • Alex

    Alex - 2014-08-20

    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.

  • Fred Toussi

    Fred Toussi - 2014-08-23

    You can connect to the database as another admin session and abort a running session. See the Guide chapter on sessions.

  • Alex

    Alex - 2014-08-25

    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?


Log in to post a comment.