calling Connection.close() hangs

I have an interesting problem here I am wondering what the correct 
response is.

---------------
Driver: 3.1.13
Database: 5.0.15
Query:  SELECT SLEEP(120);
---------------

So we are using the sleep() function as a test for long running queries. 
  We want to basically monitor them and if they are taking longer than 
they should we want to kill them.

But when we call the close() on the Connection class that started them 
(connection pooling setup) then it merely hangs there waiting until the 
query completes before.

How can we implement this?

thanks


-- 
Alan Williamson, CTO Blog-City Ltd
   http://alan.blog-city.com/


-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]