tags:

views:

29

answers:

1
Q: 

Pessimistic locking is not working with Query API 

List esns=session.createQuery("from Pool e where e.status=:status "+
                        "order by uuid asc")
                        .setString("status", "AVAILABLE")
                        .setMaxResults(n)
                        .setLockMode("e", LockMode.PESSIMISTIC_WRITE)
                        .list();

I have the above query written, however it is not generating for update query and simultaneous updates are happening.

I am using 3.5.2 version and it has a bug in Criteria API, is the same bug present in query API as well or I am doing something wrong?

A: 

setLockOptions is working fine. It is the same bug as this one.

Reddy  2010-06-16 13:58:29

related questions

Is it worth the effort to move from a hand crafted hibernate mapping file to annotaions?
Hibernate Tools and the ever changing database
What is the best way to load a Hibernate object graph before using it in a UI?
HQL querying columns in a set
Is it possible to use analytic functions in Hibernate?
Hibernate (JPA) how to do an eager query, loading all child objects
Hibernate mapping a composite key with null values
Mixing EJB 2.x BMP entity beans with Hibernate 3.x
Lazy loading property and session.get problem
Hibernate - maxElementsOnDisk from EHCache to TreeCache
Hibernate criteria _ how to use criteria to return only one element of an object instead the entire object
When can/should you go whole hog with the ORM approach?
How do you "OR" criteria together when using a criteria query with hibernate?
Looking for an HQL builder (Hibernate Query Language)
Enabling Hibernate second-level cache with JPA on JBoss 4.2
Getting hibernate to log clob parameters
Hibernate crops clob values oddly
(N)Hibernate - is it possible to dynamically map multiple tables to the one class
Querying collections of value type in the Criteria API in Hibernate
How to maintain Hibernate cache consistency running two Java applications?
Why @OneToMany does not work with inheritance in Hibernate
data 'security' with java and hibernate
Using Hibernate to work with Text Files
Giant NodeManagerLogs from hibernate in weblogic
Hibernate saveOrUpdate with another object in the session