How to achieve "not in" by using Restrictions and criteria in Hibernate?

Question

I have list of category. I need a list of category by excluding 2,3 row. Can we achieve through hibernate by using Criteria and Restriction?

Answer 1

Your question is somewhat unclear. Assuming "Category" is a root entity and "2,3" are ids (or values of some property of the category") you can exclude them using the following:

Criteria criteria = ...; // obtain criteria from somewhere, like session.createCriteria() 
criteria.add(
  Restrictions.not(
     // replace "id" below with property name, depending on what you're filtering against
    Restrictions.in("id", new long[] {2, 3})
  )
);

Same can be done with DetachedCriteria.

Answer 2

Session session=(Session) getEntityManager().getDelegate(); Criteria criteria=session.createCriteria(RoomMaster.class); //restriction used or inner restriction ... criteria.add(Restrictions.not(Restrictions.in("roomNumber",new String[] { "GA8", "GA7"}))); criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); List roomMasters=criteria.list();