Yes, I think this is the problem. But how can I make a read/write lock with only one lock? Best regards, Fabio. > ---------- > De: Gerald L. Clark[SMTP:[EMAIL PROTECTED]] > Enviado el: Martes, Marzo 20, 2001 04:33 PM > Para: Fabio Galarraga > CC: 'Mysql mailing list' > Asunto: Re: Read/write table lock > > Fabio Galarraga wrote: > > > > Hi to all: > > Somebody knows how to make a read/writa table lock? > > I'm trying with java source: > > > > stmt.execute("LOCK TABLES table-x READ, table-x WRITE"); > > ---- > > stmt.execute("UNLOCK TABLES"); > > > > but it fails. > > > > Best regards, > > Fabio Galarraga > > [EMAIL PROTECTED] > > > Well you are locking table-x twice in the same lock. >
--------------------------------------------------------------------- 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