Hi

Is row level locking available in hibernate?

Thanks
Yogs

I don't think row level locking is native to hibernate. However, you might want to check out the following section in regards to versioning and locking.

http://www.hibernate.org/hib_docs/reference/html/transactions.html

you can lock an object:



Refer to the api for LockMode.

As for my Object it can be either a transient or persistent object[/code]

But does locking a session as you have suggested have the same effect as a true row level locking? After all, sessions aren't threadsafe.

Both concepts are not related. If you use an exclusive LockMode, the database will have an exclusive lock, as Hibernate never locks in memory. A concurrent Session will either have to wait or immediately throw a SQL lock exception.

Hi

Thanks for your information. Then when we are using session.saveOrUpdate(object), does that mean that concurrent session calling session2.saveOrUpdate(object) i.e. for the same object will overlap with first one?

Thanks
Yogs

No, usually you have optimistic concurrency with version checks. There is even a chapter about all this in the reference documentation, please read it.

I think that is the link I posted earlier in the thread. For implicit row level locking I am considering the use of a ProcessLock table that keeps a record of processes that are locked and the lock is removed once the processing is completed.

This is a bottleneck. You should first have a good overview on optimistic and pessimistic locking, search Google for those keywords.