db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sunitha Kambhampati <ksunitha...@gmail.com>
Subject Re: Concurrency in connections and Threads
Date Wed, 09 Nov 2005 21:28:35 GMT
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.

Mime
View raw message