Record Locking in InnoDB
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
Row level locking in InnoDB
Hi, We are trying to implement row level locking in our appln. we have a table Order we are locking the table using SELECT * FROM Order FOR UPDATE; but still another user is able to update this table. why? we have autocommit set to zero. Our requirement is 1. user selects a order for editing. 2. then another user should not be able to edit this order. any ideas? 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
Innodb
hi, I have been using mysql isam tables for a while. Today i installed mysql3.23.44 and created the example table customer in the test database. But when i do a select or insert for this table i am getting the following error. Can't open file: 'customer.InnoDB' Any ideas? 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
Connect Error
i am getting error 10060 when i try to connect to a remote mysql server. Any idea why this is happening 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