Load with LockMode.UPGRADE doesn't lock with SQLServer

brockj · **Joined:** Mon Jun 20, 2005 2:55 am **Posts:** 2

We have recently migrated a product from hibernate 2.1.x to 3.0.x in the hope we could remove an ugly kludge for locking objects in SQLServer.

Hibernate 3.0 added support for the (rowlock, updlock) but this appears to only work when directly calling lock. If you call load with a lock mode the lock hint is not added. Loading with a lock mode seems to work for all other DB types (that support for update syntax). Is this expected behaviour?

I tracked the problem down to org.hibernate.sql.Select. It is not calling Dialect.appendLockHint (and can't really as there could be multiple tables involved).

The workaround is to load the object then lock it.

Any help would be appreciated.

alesj · **Posted:** Mon Jun 20, 2005 3:45 am

http://forum.hibernate.org/viewtopic.ph ... highlight=

brockj · **Joined:** Mon Jun 20, 2005 2:55 am **Posts:** 2

Thanks. How on earth did i not find that post?

I guess it is back to SQL kludge :)

alesj · **Posted:** Mon Jun 20, 2005 8:16 am

What's the reason not to use Session.lock()?

Basilio · **Posted:** Tue Jun 28, 2005 7:57 pm

alesj wrote:

What's the reason not to use Session.lock()?

I am having the same issue. Answer is, I do not need to load entity if it cannot be locked for any reason.