CODEWITHSUNDEEP
javasqlibatis
uzilan
uzilan

Reputation: 2624

Is it possible to abort a long running query using iBATIS?

I have a GUI which allows users to run long running queries. Sometimes, the users regret running the queries and would like to cancel them. The queries are running using iBATIS against an Oracle database, and I know that the java.sql.Statement interface defines a cancel method that might or might not be implemented by the driver. So my question is, is it possible to use iBATIS to invoke this method to cancel the query (given the right driver), or is there any other way of aborting an ongoing long running query.

Upvotes: 3

Views: 941

Answers (1)

Yair Zaslavsky
Yair Zaslavsky

Reputation: 4137

Well,
I guess that once the got to the DB server, cancelling it is really a "DB vendor specific" issue.
If your requirement is to cancel the query,
when it comes to your application
(i.e - if it reaches the Oracle DB server, and is run there, you are fine, as long as you will not get the result), consider using the Future interface which has a cancel method.
You can submit a "Callable" to run your query, and it will return a proper object of type which is an implementation.
If you need to abort - just use the "cancel" method of the future object. You can also check using "isCanceled" to see if submission was cancelled, and make proper treatment at your code.

Upvotes: 2

Related Questions