Controlling query timeout period for deadlocks and long running queries

[David Wynter]

Hi,

Could not find a reference for how to do this. For lock timeouts in SQL Server I used to use this
timeoutStmt.executeUpdate("SET LOCK_TIMEOUT 20000");
This then works for just that connection. I catch the SQLException and test for
se.getErrorCode() == 1222
1222 being the native SQL server error code for a lock timeout.

How do I do the same in MySQL using JDBC? I was going to use
timeoutStmt.executeUpdate("SET @@session.wait_timeout = 20000");
until I realised wait_timeout is not related to the query but the connection.

Also of interest is when a query just takes too long, shouldn't happen, but I'd like to allow for it. Is there some way of setting a limit and a particular error code used when it is expired?

Thx.

David