db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Satheesh Bandaram <banda...@gmail.com>
Subject Re: turn off row_locking
Date Thu, 25 May 2006 16:36:50 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
  <title></title>
</head>
<body bgcolor="#ffffff" text="#000000">
Bryan Pendleton wrote:<br>
<blockquote cite="mid4475D027.2030706@amberpoint.com" type="cite">
  <blockquote type="cite">What I would like to know is how can I
disable row level locking
    <br>
  </blockquote>
  <br>
One way is to alter your application to do:
  <br>
  <br>
  stmt.executeUpdate("lock table CUSTOMER in exclusive mode");
  <br>
  <br>
Where "CUSTOMER", of course, is replaced by the actual name of your
table.
  <br>
  <br>
Once you have done this, Derby will not take any row-level locks for
  <br>
accesses to this table by this transaction.
  <br>
  <br>
thanks,
  <br>
  <br>
bryan
  <br>
</blockquote>
Another option may be to set <b>derby.locks.escalationThreshold</b>
property to minimum value... While this still starts with row locks
until it hits the value, it has the advantage of being applied to all
tables without changes to application.<br>
<br>
Satheesh<br>
<br>
<br>
</body>
</html>


Mime
View raw message