locking tables

Hi,


I need to obtain a lock on an entire table whilst I am executing an insert query

AND at the same time a lock on a particular row of another table which allows only update

am trying out something like
stm_u.executeQuery("LOCK TABLES sequence WRITE");

and to unlock: stm_u.executeQuery("UNLOCK TABLES");

can anyone help me out with the query??

Am using MySQL 3.23


The query syntax runs fine with PHP... but not with JSP---


TIA,
sands