Innodb

2001-11-15 Thread Kishor K
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

Row level locking in InnoDB

2001-11-15 Thread Kishor K
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

Record Locking in InnoDB

2001-11-15 Thread Kishor K
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

Connect Error

2001-07-18 Thread Kishor K
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