Hello everybody !
As you can see, I am new on this forum. I am also new to hibernate.
I have a problem that may be very simple, but after 2 days reading documentations, I don't seem to find any answer :-(.

Here is my situation :
Hibernate version: 2.1.7
Mapping documents:
http://jerome.duquennoy.fr/tmp/DBSoftware.hbm.xml
and
http://jerome.duquennoy.fr/tmp/DBSoftwa ... on.hbm.xml

Code between sessionFactory.openSession() and session.close():
Criteria criteria = session.createCriteria(DBSoftwareVersion.class());
criteria.addOrder(Order.asc("software.name"));
result = criteria.list();

Resulting error
I get an HibernateException with this message :
could not resolve property: software.name of: com.rte.myapp.data.model.DBSoftwareVersion

Problem description :
I have a DBSoftwareVersion object that references a DBSoftware object (many to one).
I need to load a DBSoftwareVersion list, ordered by the names of the associated softwares.

It works wonderfully with an Order.asc("software.id"), but i cannot make it work with Order.asc("software.name").

Dones anyone have an idea ?
Any help would be greatly appreciated !

Thank you in advance !

try

Thanks for this suggestion kochcp.
Unfortunatly, it causes another error : "subcriteria cannot be ordered".

After a few more research, it simply seems to be impossible.
The only sorting keys available are the fields of the DBSoftwareVersion's table.

in your mapping type of DbSoftware, you should probably declare what type (Integer, Long, String, etc) the property 'name' should be. this might make it able to be ordered upon