Re: Mysql Row Lock Problem

2002-02-14 Thread TAKAHASHI, Tomohiro
Hi, Amit What kind problem do you have? I can't understand your problem. In JDBC API, Connection.commit() method does not return affected row count. Generally, Statement.executeUpdate(String) method returns that count. Thanks. Amit Dilip Lonkar wrote: > > HI > > I am using java. i

Mysql Row Lock Problem

2002-02-13 Thread Amit Dilip Lonkar
Hi I have set lock on a row in Mysql by the command "SELECT " + selCols + " FROM ATTRIBUTE LOCK IN SHARE MODE"; Now when the user who has set the lock updates the record the the lock is still not released. Hence no other user is able to update. How do i release this lock ? Also If i hav