ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Toby Thain <t...@smartgames.ca>
Subject Re: Transaction problem
Date Mon, 09 Jun 2008 12:47:48 GMT

On 9-Jun-08, at 3:43 AM, Dott. Christian OLIVIERI wrote:

> Hi, I'm a newbie and the following is my problem:  I have a db  
> MySQL managing personal information. That I would do is: everyone  
> can READ single record. If someone open the record x to update/ 
> delete no one other can do the same (edit/update) till first user  
> don't commit.
> I was thinking Local Transaction was the answer but if user A open  
> a record in update then user B open the same record, B is hanged  
> untill timeout ends.

Which is exactly what you asked for. :)

> How to alter timeout value?

It's a MySQL configuration setting (innodb_lock_wait_timeout).


> Thanks a lot.
> Christian

View raw message