Community
Participate
Working Groups
Build Identifier: BIRT Runtime 2.6.1 The task created to build a report does not stop the query when canceled. When a user picks bad parameters the query may run for a long time. Canceling the task does not cancel the query. Even quitting the program does not cancel the query. This leaves these long running queries without any way except going to a database tool in order to cancel them. The task should be able to cancel the query. Reproducible: Always Steps to Reproduce: 1. Build a long running report 2. Start the report generation 3. call task.cancel() to stop the report 4. Go to the database and see that the query is still running.
What's DBMS do you use? And could you please provide JDBC driver you're using? Could you have a check on whether this jdbc driver is supporting Statement.cancel() operator by writing test code?
Created attachment 181870 [details] Test case for driver close of query I have written a test case for the driver, which is MySQL 5.1.13. The output from this run is shown below. Test connection MySQLmysql-connector-java-5.1.13 ( Revision: ${bzr.revision-id} ) MySQL-AB JDBC Driver Start query Cancel trip true In cancel ..1 Error in query Statement cancelled due to client request Done with cancel What this little test does is create a connection and gets its version. Then it starts in another thread a query that takes some time. It waits a few seconds and detects if the thread is still running, if so, then it cancels the query. It then waits until the thread quits. What one sees is that the query statement gets canceled and throws an error in the thread. The thread then closes and the test ends. This shows that the driver is capable of cancelling a running query. It is my understanding from reading the old bug reports is that the cancel of a reporting task is only checked after the query returns a result set. What I need is to be able to cancel a query before that point in time. This means that the cancel needs to look at the process and cancel the query rather than wait for results to return. This is my quess.
The same here with an Oracle JDBC driver.
Fix it now.
Use SQLServer Profile to check the process status, when canceling the task, the query execution is canceled at once. Verified in the latest 2.6.2 build
