Re: turn off row_locking

[Satheesh Bandaram]

Bryan Pendleton wrote: 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 Another option may be to set derby.locks.escalationThreshold 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. Satheesh