Bug #36243 setQueryTimeout does not work
Submitted: 22 Apr 2008 6:37 Modified: 22 Apr 2008 6:46
Reporter: Amitm Mujawar Email Updates:
Status: Duplicate Impact on me:
None 
Category:Connector / J Severity:S2 (Serious)
Version:5.1.5 OS:Any
Assigned to: CPU Architecture:Any

[22 Apr 2008 6:37] Amitm Mujawar 
Description:
The MySQL connector 5.1.5 and even the older ones do not support the Statement.setQueryTimeout api.

I do not get any exception on the supplied timeout value in seconds and the caller keeps waiting for longer durations [maybe controlled by other global settings..not sure since I am new to MySQL]

How to repeat:
call statement.setQueryTimeout(1) which should throw an exception in case the accessed records are in locked state and are not released within 1 second.

But this does not happen and the client waits much much more than 1 second.
There is no effect of changing this parameter value.
[22 Apr 2008 6:38] Amitm Mujawar 
I am using InnoDB as engine. with MySQL 5.1.5
[22 Apr 2008 6:46] Tonci Grgin 
Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Explanation: Hi Amitm and thanks for your report. This is a duplicate of Bug#31698.