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
