Re: Can't seem to force table level locking

[Bryan Pendleton]

> 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