Re: Read/write table lock

2001-03-21 Thread Gerald L. Clark
, 2001 04:33 PM > > Para: Fabio Galarraga > > CC: 'Mysql mailing list' > > Asunto: Re: Read/write table lock > > > > Fabio Galarraga wrote: If you issue a READ lock, nobody can write to the table. If you Issue a Write lock, only you may read or write

RE: Read/write table lock

2001-03-21 Thread Fabio Galarraga
iling 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, ta

Re: Read/write table lock

2001-03-20 Thread Gerald L. Clark
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 PROTECT

Re: Read/write table lock

2001-03-20 Thread Jeremy D. Zawodny
On Tue, Mar 20, 2001 at 03:05:53PM -0300, 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. And what is t

Read/write table lock

2001-03-20 Thread Fabio Galarraga
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] -