How to specify pessimistic lock with Criteria API?

Posted by Reddy on Stack Overflow See other posts from Stack Overflow or by Reddy
Published on 2010-06-12T11:24:32Z Indexed on 2010/06/12 11:33 UTC
Read the original article Hit count: 277

Filed under:

hibernate

|

criteria-api

I am retrieving a list of objects in hibernate using Criteria API. However I need lock on those objects as another thread executing at the same time will get the exact objects and only one of the thread will succeed in absence of a pessimistic lock.

I tried like below, but it is not working.

List esns=session.createCriteria(Reddy_Pool.class)
                  .add(Restrictions.eq("status", "AVAILABLE"))
                  .add(Restrictions.eq("name", "REDDY2"))
                  .addOrder(Order.asc("id"))
                  .setMaxResults(n)
                  .setLockMode(LockMode.PESSIMISTIC_WRITE) //not working at all
                  .list();

© Stack Overflow or respective owner

Related posts about hibernate

Hibernate unable to instantiate default tuplizer - cannot find getter

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to use Hibernate to persist a class that looks like this: public class Item implements Serializable, Comparable<Item> { // Item id private Integer id; // Description of item in inventory private String description; // Number of items described by this inventory item private int… >>> More
Hibernate + PostgreSQL : relation does not exist - SQL Error: 0, SQLState: 42P01

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am having some problems trying to work with PostgreSQL and Hibernate, more specifically, the issue mentioned in the title. I've been searching the net for a few hours now but none of the found solutions worked for me. I am using Eclipse Java EE IDE for Web Developers. Build id: 20090920-1017… >>> More
Problem connecting to Hsqldb via Hibernate when running a Eclipse GWT project.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to run a simple GWT project where I'm trying to do a simple persitence via hibernate to a HSQLDB database. The database I'm using I have been using for at least 2 years with several osgi applications without any problems. So all I done is reused the same configuration and added a simple… >>> More
Hibernate : load and

as seen on Stack Overflow - Search for 'Stack Overflow'
According to the tutorial : http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=27hibernateloadvshibernateget, If you initialize a JavaBean instance with a load method call, you can only access the properties of that JavaBean, for the first time, within the transactional context in which it… >>> More
Hibernate Exception, what wrong ? [[Exception in thread "main" org.hibernate.InvalidMappingException

as seen on Stack Overflow - Search for 'Stack Overflow'
I use netbean 6.7.1 to write "hello world" witch hibernate, but I get some errors, plz help me, thank you very much. my exception init: deps-module-jar: deps-ear-jar: deps-jar: Copying 1 file to F:\Documents and Settings\My Dropbox\DropboxNetBeanProjects\loginspring\build\web\WEB-INF\classes compile-single: run-main: Oct… >>> More

Related posts about criteria-api

Using NHibernate Criteria API to select sepcific set of data together with a count

as seen on Stack Overflow - Search for 'Stack Overflow'
I have the following domain set up for persistence with NHibernate: I am using the PaperConfiguration as the root aggregate. I want to select all PaperConfiguration objects for a given Tier and AcademicYearConfiguration. This works really well as per the following example: ICriteria criteria = session… >>> More
Dynamic JPA 2.0 query using Criteria API

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello all, I am a bit stucked constructing a dynamic query using the CriteriaBuilder of JPA 2.0. I have quite a common use case I guess: User supplies a arbitrary amount of search parameters X to be and / or concatenated: like : select e from Foo where (name = X1 or name = X2 .. or name = Xn ) The… >>> More
Hibernate. Convert HQL to Criteria API

as seen on Stack Overflow - Search for 'Stack Overflow'
How to convert the following hql to Criteria API var criteria = this.Session.CreateQuery("select m, m.Attachments.size from AdvanceMessage m"); ? Thanks >>> More
JPA 2 in Jboss and criteria api

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a working JPA 2 implementation for JBoss server? Or maybe there is some additional extension that provides JPA 2's criteria api equivalent? >>> More
NHibernate.Linq to Criteria API translation help needed

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm not sure how to add paging to this: Session.Linq<Article>() .Where(art => art.Tags.Any(t => t.Name == tag)).ToList(). So i decided to use Criteria API. var rowCount = Session.CreateCriteria(typeof(Article)) .SetProjection(Projections.RowCount()).FutureValue<Int32>(); var… >>> More