I have Profile class that has two fields Person, Status.

class Profile{
private Person person;
private Status status;
}

class Person {
private String firstName;
private String lastName;
}

class Status{
private String status;
}

My requirement is to sort the results of Profile on Person.lastName. I am able to sort them on Person or Status. I have done on Status. Here is the HQL:


List _results = (List)session.createCriteria(Profile.class) .addOrder(Order.asc("status"))
.list();

Is there any option with HQL and Hibernate to add the sorting feature for this query on Person.lastName field.

If not, my alternative is to read the objects from _results List and sort them and store in a sorted results List.

TIA
Shyam

try this

List _results = (List)session.createCriteria(Profile.class)
.createAlias("person","person").addOrder(Order.asc("person.lastName"))
.list();

Thanks. It worked :)

I have weird problem. Here is my java class

public Profile{
public Person person;
public Person personHead;
public Person DeptHead;
}

Now when I search for the following

List _results = (List)session.createCriteria(Profile.class)
.createAlias("person","person")
.addOrder(Order.asc("person.lastName"))
.list();

Error message
**************
SEVERE: ORA-00904: "PERSON1_"."LASTNAME": invalid identifier
Query-->select * from T_PROFILE this_ order by person1_.lastName desc
Where the following two works fine.
------------------------------------------------------------------------------
List _results = (List)session.createCriteria(Profile.class)
.createAlias("personHead","person")
.addOrder(Order.asc("person.lastName"))
.list();

Hibernate: select * from T_PROFILE this_ inner join T_PERSON person1_ on this_.personHead=person1_.id
order by person1_.lastName asc



List _results = (List)session.createCriteria(Profile.class)
.createAlias("DeptHead","person")
.addOrder(Order.asc("person.lastName"))
.list();
This works fine.
-------------------------------------------------------------------------------

I have tried this. Still the same error message is coming:

List _results = (List)session.createCriteria(Profile.class)
.createAlias("person","per")
.addOrder(Order.asc("per.lastName"))
.list();

Is there any problem with createAlias method? It is giving error message when I give same name for alias and property?

Thanks