Re: cancel a running query?

Fri, 10 Oct 2008 05:26:47 -0700


Doesn't Derby support Statement.setQueryTimeout() ?


Dirk


[EMAIL PROTECTED] wrote: 
A rollback doesn't "cancel" a query. Meaning that you can't stop the query
until it completes.

The rollback will reverse the results of a transaction after the SQL
statement completes. A query is unaffected because its not a SQL statement
that changes the database. (query == SELECT, other statements UPDATE,DELETE,
INSERT, etc ... do change the data.)

So if you start  a query, there isn't a way to have some sort of query
timeout or call to prematurely end the query. (Perhaps you need to consider
threading your app...)

HTH

-Mike


  
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 09, 2008 9:09 PM
To: Derby Discussion
Subject: Re: cancel a running query?

Rick Hillegas <[EMAIL PROTECTED]> writes:

    
 conn.rollback();
      
Doesn't the rollback block on synchronizion on the connection?

Dag

Reply via email to