Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:

3.2.1GA

Name and version of the database you are using:

MySQL 5.0.27

Problem

Unlike Restrictions, Order.asc(String propertyName) and Order.desc(String propertyName) only seem to be able to process one property level. For instance, where criteria.add(Restrictions.like("property.subproperty", "%foo%") works fine, criteria.addOrder(Order.asc("property.subproperty")) throws an "org.hibernate.QueryException: could not resolve property: ...".

One, where would I report this as a feature request? Two, is there a workaround without resorting to using a Query? (session.createQuery("from Table t order by t.property.subproperty") does work just fine).

Thanks,

Derek

edit: oops, i might have been too fast, you're using MySQL.
if you mean another table by "subproperty", you might want to look into createAlias("tablename", "name for usage")

can you post your mappings and full code to generate the query?

Aliases do indeed work. But this is nowhere documented. (The documentation on ordering is actually a joke.) Nor is it in any way intuitive. But from the source code it's obvious that only aliases are working.

I modified Hibernate's CriteriaQueryTranslator to work with association paths as well. Be aware that you need to create the criterias for the associations in advance.

Hope this helps,

Joerg

Solution is:

Criteria subCriteria = criteria.createCriteria("property");

subCriteria.addOrder(Order.asc("subproperty")) ;