Hi, I am using jsp-mysal combination in my application. In my case i need the second user accessing the record to edit to get a error message "this record is being edited by another user. try later" if the record is being edited by first user.
In the page i have used i have set autocommit=0 then selected the record for update using select * from mytable where id=3 for update; now how will be i catch this so that second user can be informed about the lock. thanx in advance kishor _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
