Re: MySQL Error 1205

[Peter Kaye]

Thanks.
Under normal circumstances the transactions processing time is very short.

The problem is handling situations where the transaction has commenced and some updates made but the internet line to the client drops before either a Commit or Rollback. (It's not related to the user being able to start a transaction and then prevent its completion).

When the internet connection is broken the records affected in the transaction remain locked for a period of several minutes and this is the problem I want to solve. Interestingly it seems that this problem does not apply for INSERT statements - I suppose because no locking is required.

I'm connecting via ODBC using the 5.1 driver.

I found the setting innodb_lock_wait_timeout in documentation (http://dev.mysql.com/doc/innodb/1.1/en/innodb-other-changes-innodb_lock_wait_timeout.html). Is this relevant to my problem ?

But when I look at the odbc documentation (http://dev.mysql.com/doc/connector-odbc/en/connector-odbc-configuration-connection-parameters.html ) I can't see any way of setting this.

This issue would be solved if the MySQL db could be configured to hold transaction locks for 60 secs and then Rollback automatically. I'd like to know what settings need to be changed to achieve this.

Thanks.