| Subject | Cancel long running queries |
|---|---|
| Author | jason.berry62 |
| Post date | 2009-06-15T15:52:20Z |
Hello
Using Firebird 2.1.2 does the following command only stop queries that are still being processed:
'delete from mon$statements where MON$STATEMENT_ID = 123'
For example if the SQL statement we wish to stop was a select which had already returned the results but had not yet been committed. Can you use the 'delete from mon$statements' to effectively cancel the transaction? So that the OAT would be released.
Using Firebird 2.1.2 does the following command only stop queries that are still being processed:
'delete from mon$statements where MON$STATEMENT_ID = 123'
For example if the SQL statement we wish to stop was a select which had already returned the results but had not yet been committed. Can you use the 'delete from mon$statements' to effectively cancel the transaction? So that the OAT would be released.