Re: com.mysql.jdbc.exceptions.MySQLTimeoutException: Statement cancelled due to timeout or client request

[Vony John]

Hi Mark,

Thanks for reply, Yes we are using jboss 4.2.x

And earlier I tried using jboss mysql datasource configuration to enable statement timeout configuration. However the property that they mentioned is not available in jboss 4.2.x it is enabled in jboss 5.0

Following is the excerpt from RedHat jboss documentation.

<set-tx-query-timeout> - Whether to enable query timeout based on the length of time remaining until the transaction times out. This was not ported to 4.0.x until 4.0.3. Also, it exists in 4.2.x but doesn't function with the JBossTS transaction manager. JBossTS incorporated this functionality in 5.0. Default is false.

<query-timeout> - A static configuration of the maximum of seconds before a query times out (since 4.0.3). This value will be overridden appropriately if <set-tx-query-timeout> is true.

So we tried to set <query-timeout>, but no luck.

Any other pointer/reference i should look into ?

Thanks