db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendle...@amberpoint.com>
Subject Re: turn off row_locking
Date Thu, 25 May 2006 15:41:27 GMT
> What I would like to know is how can I disable row level locking

One way is to alter your application to do:

   stmt.executeUpdate("lock table CUSTOMER in exclusive mode");

Where "CUSTOMER", of course, is replaced by the actual name of your table.

Once you have done this, Derby will not take any row-level locks for
accesses to this table by this transaction.

thanks,

bryan





Mime
View raw message