Brian,
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.
