db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bryan Pendleton <bpendleton.de...@gmail.com>
Subject Re: Can't seem to force table level locking
Date Wed, 01 Feb 2012 01:52:27 GMT
> 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

Mime
View raw message