Timeout on executeQuery

[Ludovic Maillet]

Hi !

I'm using the last MySQL-Connector driver to connect to my MySQL database.
I'm only working with SELECT queries.

This night, the /persist/ directory, on the file system where my DB is installed, was full, and then the DB didn't reponse any more to requests... the java code was blocked on the preparedStatement.executeQuery()

Is there a solution to limit the time passed in a PreparedStatement.executeQuery ?
Setting a timeout on statement or on MySQL DB for example, or anything else ?

Thanks
Ludovic