ORDER BY using Criteria API

Question

When I write a HQL query  Query q   session createQuery  SELECT cat from Cat as cat ORDER BY cat mother kind value    return q list      Everything is fine  However  when I write a Criteria  Criteria c   session createCriteria Cat class   c addOrder Order asc  mother kind value     return c list      I get an exception org hibernate QueryException  could not resolve property  kind value of  my sample data entities Cat  If I want to use Criteria and Order  how should I express my  order by

User · Accepted Answer

You need to create an alias for the mother kind  You do this like so   Criteria c   session createCriteria Cat class   c createAlias  mother kind    motherKind    c addOrder Order asc  motherKind value     return c list

User · Answer

This is what you have to do since sess createCriteria is deprecated   CriteriaBuilder builder   getSession   getCriteriaBuilder    CriteriaQuery lt User gt  q   builder createQuery User class   Root lt User gt  usr   q from User class   ParameterExpression lt String gt  p   builder parameter String class   q select usr  where builder like usr get  name   p      orderBy builder asc usr get  name      TypedQuery lt User gt  query   getSession   createQuery q   query setParameter p        Main filterName         List lt User gt  list   query getResultList

User · Answer

It s hard to know for sure without seeing the mappings  see  Juha s comment   but I think you want something like the following   Criteria c   session createCriteria Cat class   Criteria c2   c createCriteria  mother    Criteria c3   c2 createCriteria  kind    c3 addOrder Order asc  value     return c list

User · Answer

For Hibernate 5 2 and above  use CriteriaBuilder as follows  CriteriaBuilder builder   sessionFactory getCriteriaBuilder    CriteriaQuery lt Cat gt  query   builder createQuery Cat class   Root lt Cat gt  rootCat   query from Cat class   Join lt Cat Mother gt  joinMother   rootCat join  mother         lt -attribute name Join lt Mother Kind gt  joinMotherKind   joinMother join  kind    query select rootCat  orderBy builder asc joinMotherKind get  value      Query lt Cat gt  q   sessionFactory getCurrentSession   createQuery query   List lt Cat gt  cats   q getResultList

User · Answer

You can add join type as well   Criteria c2   c createCriteria  mother    mother   CriteriaSpecification LEFT JOIN   Criteria c3   c2 createCriteria  kind    kind   CriteriaSpecification LEFT JOIN

[java] ORDER BY using Criteria API

Examples related to java

Examples related to hibernate

Examples related to sql-order-by

Examples related to hql