Order By with Criteria

chrism · **Joined:** Fri Oct 29, 2004 9:39 am **Posts:** 5

Hibernate version: 3.2

Name and version of the database you are using: Oracle 10g

I have the following classes with properly mapped HBM files:

Code:

public class Workbench {
   Long id;
   Tool tool;
   public Tool getTool();
}

public class Tool {
   Long id;
   String name;
   public String getName();
}

If I try to do the following in code:

DetachedCriteria criteria = DetachedCriteria.forClass(Workbench.class)
.addOrder( Property.forName("tool.name").asc() );

I get the following error:

HibernateQueryException: could not resolve property: tool.name

Is this a limitation of Hibernate, in that you can't sort on a joined record using Criteria? It seems to work ok with HQL.

chrism · **Joined:** Fri Oct 29, 2004 9:39 am **Posts:** 5

OK, I found the answer:

Code:

DetachedCriteria criteria = DetachedCriteria.forClass(Workbench.class)
   .createAlias("tool", "t")
   .addOrder( Property.forName("t.name").asc() ); 

However, not a single example on the web that I previously looked at actually shows this, and nor does the documentation. I happened to find this by more thoroughly looking through the forums here.

amila733 · **Posted:** Wed May 23, 2007 9:06 am

Hi

Code:

DetachedCriteria criteria = DetachedCriteria.forClass(Workbench.class,"w").createCriteria("tool").addOrder( Property.forName("name").asc() );

Amila

(Don't forget to rate if it helps)