Arieh Markel wrote:
<snip>
My assumptions are as follows:
- table lock granularity is what is in place in Derby
Are those assumptions true ?
Just wanted to point out , that by default Derby is configured for
row-level locking.
http://db.apache.org/derby/docs/10.0/manuals/develop/develop73.html#IDX690
This talks about a property derby.storage.rowLocking which is not there
in tuning manual. I think the documentation is off in that respect.
Derby supports the LOCK TABLE statement which can be used to explicitly
acquire a shared or exclusive table lock.
http://db.apache.org/derby/docs/dev/ref/rrefsqlj40506.html
Sunitha.