Re: Controlling query timeout period for deadlocks and long running queries

[Dirk B.]

Hi David,

did you find a solution how to handle the timout of long running queries? I think there must be configuration solution, maybe configurable with param properties on getting the connection or within config files if persistence broker a framework is used, but didn't found. :-(

If another peeving problem. Its more related to tomcat 4 I use but also depends on mysql. The follow statements are sequentiell in code of my servlet application:

Statement _statement = _con.createStatement();
_statement.execute(_sb.toString());

If I set a breakpoint before execute() if works fine but if not the second will not be reached. The http request to the servlet container will be lost when it runs directely into the long mysql request. Do you have an idea how to hold the browser request? If I have the breakpoint tomcat may hold the connection anyway.

Thx

Dirk