Another lock question. Now about LockTables

Discussion of open issues, suggestions and bugs regarding MyDAC (Data Access Components for MySQL) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
GuzunNicolae
Posts: 78
Joined: Wed 17 Jan 2007 14:16

Another lock question. Now about LockTables

Post by GuzunNicolae » Fri 29 Jun 2007 10:20

Hello

Here I have another locking question.

I am doing MyQuery.locktable on one table. Then from other application I try to edit a field from that table. I cannot do this. Which is correct. But the problem is that I do not get a lock timeout exception. Is this right?

And if I am editing a record in one application and issue LockTable in another I can get the lock on the table but I cannot post the record from the first application. Which let's say I can understand, but I still do not get lock timeout exception.

Is this right not to get the exception?

Antaeus
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Post by Antaeus » Tue 03 Jul 2007 15:06

Try to perform immediate lock before editing a record. After the time interval specified in the innodb_lock_wait_timeout server variable expires, an exception will be raised. See the Lock demo of MyDAC for more information.

We will investigate possibility to improve work with locking in MyDAC.

Post Reply