[SQLObject] How to lock records

[Ales S. <al...@ve...>]

Hi!

I am writing a web application, where a user could select a record from 
database
(selectBy( ID = ...)), make some modifications and then update record in 
the database.
The problem is, that at the momen multiple users can select same record, 
which can
lead to inconsistencies, so I have to use a record lock/release mechanism.
I searched the web for possible solutions but I have found no relevant 
information.
So if anybody knows the solution to this problem please reply (with the 
answer of course ;-)).

With regards, ales