db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From anthonyri <anthony.r...@inbox.com>
Subject Re: Can't seem to force table level locking
Date Wed, 01 Feb 2012 07:16:11 GMT

Bryan,

Yes, autocommit is turned off.

Any other thoughts?

Regards,

Anthony


Bryan Pendleton-3 wrote:
> 
>> I have tried to force table level locking by;
>>
>> 1. SQL - lock table wayNodes6 in share mode
>> 2. st.execute("call
>> SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY('derby.locks.escalationThreshold','1')");
>>
>> But the query execution plan always states it has chosen row level
>> locking
> 
> Do you have autocommit turned off?
> 
> Otherwise Derby is committing (and releasing your table lock) after step
> (1).
> 
> thanks,
> 
> bryan
> 
> 

-- 
View this message in context: http://old.nabble.com/Can%27t-seem-to-force-table-level-locking-tp33240337p33241503.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message