Re: Controlling query timeout period for deadlocks and long running queries
Posted by: Mark Matthews
Date: February 01, 2007 03:24PM

omprakash Wrote:
-------------------------------------------------------
> Can we not simulate query timeout using
> socket.SetSoTimeout() inside the jdbc ?

Omprakash,

No you can't, because it would violate the JDBC contract for query timeouts. In any case, Connector/J 5.0 when used with MySQL-5.0 or newer supports Statement.setQueryTimeout(), and has for quite some time, so why not use it?

-Mark

Mark Matthews
Consulting Member Technical Staff - MySQL Enterprise Tools
Oracle
http://www.mysql.com/products/enterprise/monitor.html

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.