Hibernate Community • View topic - Order results on property of associated entity

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

Order results on property of associated entity

Page 1 of 1

[ 3 posts ]

Previous topic | Next topic

Author

Message

Post subject: Order results on property of associated entity

Posted: Tue May 09, 2006 4:47 pm

Beginner

Joined: Wed Jan 25, 2006 10:18 am
Posts: 28

Hibernate version:
3.1.2

Hi.
I've been reading about the Criteria API but can't quite figure out how to order results on a property of an associated entity. I want something like this:

Code:

Criteria criteria = session.createCriteria(User.class);
criteria.addOrder(Order.asc("category.name"));

("category" is a many-to-one association)
This results in a QueryException "could not resolve property: category.name". I tried to add Fetchmode.EAGER for the "category" property but that didn't make any difference. Help?

Top

bkmr_77

Post subject:

Posted: Tue May 09, 2006 4:57 pm

Expert

Joined: Tue Apr 25, 2006 12:04 pm
Posts: 260

Code:

Criteria criteria = session.createCriteria(User.class); 
criteria.createAlias( "category", "catg" );
criteria.addOrder( Order.asc("catg.name") ); 

This worked fine for me.

Top

Post subject:

Posted: Tue May 09, 2006 5:37 pm

Beginner

Joined: Wed Jan 25, 2006 10:18 am
Posts: 28

Thanks, that works great.

Top

Page 1 of 1

[ 3 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum