Hi Mikael,
If you can get your hands on the connection which ran the query, then I
think that you can kill the query by rolling back the transaction and
closing the connection:
conn.rollback();
conn.close();
Hope this helps,
-Rick
Mikael Sundberg wrote:
Hi
is there anyway to cancel a running query?
i know you can se the current running querys with for example:
select XID,STATUS,SQL_TEXT from SYSCS_DIAG.TRANSACTION_TABLE
where SQL_TEXT is not NULL;
but if you accidently enter a query that takes forever how do i cancel it?
im using the latest derby.
/Micke
