Pessimistic locking is not working with Query API

Question

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?

Reddy · Accepted Answer · 2010-09-14T12:43:52.993

3

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

edited Sep 14 '10 at 12:43

answered Jun 16 '10 at 13:58

Reddy

8,737
11
55
73

score 1 · Answer 2 · edited May 23 '17 at 11:50

1

Try to use LockModeType.PESSIMISTIC_FORCE_INCREMENT, take a look at this solution.

edited May 23 '17 at 11:50

Community

1
1

answered Apr 30 '15 at 14:20

Ricardo Vila

1,626
1
18
34

Pessimistic locking is not working with Query API

2 Answers2