Women in Technology

Hear us Roar



Article:
  Interruptible Database Queries
Subject:   What about the database?
Date:   2004-06-24 20:12:55
From:   slavomir
Response to: What about the database?

Sorry Nick for a delay with my reply.
You may have noticed that the cancel() method of the QueryExecutor class not only cancels the running query but also waits until the cancellation is completed. I'm not quite sure whether it originates in the driver on the client or on the server. Waiting until the server starts sending data would negate the whole idea of query cancellation. If database server vendors choose to implement query cancellation that does not stop a process still running on the server, then probably there is nothing we can do about it.