Two client modifies one record

[Alexey Boroday <a....@procreditbank.com.ua>]

Hello

 Could you help me please - I'm developing multiuser client-server
application. Two users could edit one record at one time - how could I
prevent this?

1user - get object data on the screen
2user - get object data on the screen
1user - edit 
2user - edit
1user - press OK and data are being saved to the database via update
statement .
2user - press OK and overwrites data, posted by 1user.

 I'd like to add field (integer or timestamp) to the table and make it as
"marker" that helps determine before run update statement - is it the same
record that was read or not. 

1user - get object data on the screen
2user - get object data on the screen
1user - edit 
2user - edit
1user - press OK. iBATIS checks that marker in the object are the same that
was read from DB. Data are being saved to the database via update statement.
Field that I call "marker" is being incremented.
2user - press OK. iBATIS checks that marker in the object are the same that
was read from DB
But the value is not the same and exception is being throwing - because data
was changed.

 Is there such functionality in the iBATIS or I should write it by yourself?

--     
Thank you


___________________________________________________________________________

This communication is confidential and may be legally privileged. 
If you believe you are not an intended recipient, please inform the sender, 
delete the e-mail and do not copy, print or use it or disclose it to others. 
You can inform the sender by replying to this e-mail or by telephone (+380 44 4906080).