Interruptible Database Queries
Subject:   What about the database?
Date:   2004-06-17 14:11:31
From:   Nick_Evans
Although the technique described will interrupt the query from the Java point of view, the query on the database may continue to completion and will only be interrupted when it tries to return the result set to Java. This is certainly true with Oracle, although there are some signs in very recent patch releases that the behaviour is starting to change, but only for read-only statements.

If an end-user uses the facility to cancel a query and then re-issues it immmediately (as they mught do when response times are long) the database could become full of spurious (cancelled) queries that are still consuming resource

1 to 1 of 1
1 to 1 of 1