I have a Java application that is connecting to a MySQL database via JDBC (Connector/J 3.0.10 connecting to MySQL 4.0.17 server). I would like to implement a time-limit on certain queries (all SELECTs) and kill the query if it exceeds a given limit. Is there a convenient way to do this?
Maybe there is something obvious that I've overlooked (certainly wouldn't be the first time), but I haven't hit on the right approach yet. I have tried interrupting the thread doing the query from another thread (Thread.interrupt()), but the InterruptedException doesn't happen until the query eventually finishes (or until I do a mysqladmin kill on the server). I have tried closing the JDBC connection from another thread. This makes my JDBC connection drop out like I had hoped, but the query remains running on the server. Suggestions? Thanks -keith -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
