Basil Shubin <[EMAIL PROTECTED]> writes:

> Hi friends!
>
> Currently I have developing a medium size GUI application that use 
> SQLObject for working with database. There is ability to add/edit/delete 
> data in application. There is one small issue I don't how to resolve. 
> When one of user access some data for editing, than should be seted some 
> kind of lock that prevent other user to edit the same data in a same 
> time. How I can make so? BTW database backend is MySQL.

Kind of a SELECT FOR UPDATE in PostgreSQL?  From Google I got to
http://dev.mysql.com/doc/refman/5.0/en/internal-locking.html

You should be able to use sqlbuilder to issue those commands. 


Be seeing you,
-- 
Jorge Godoy      <[EMAIL PROTECTED]>


-------------------------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
sqlobject-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss

Reply via email to