db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rick Hillegas <Richard.Hille...@Sun.COM>
Subject Re: cancel a running query?
Date Thu, 09 Oct 2008 17:50:08 GMT
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
>


Mime
View raw message