How to use @OrderBy with a composite key

nickcodefresh · **Joined:** Mon Feb 12, 2007 6:57 am **Posts:** 9

Hi,

I'd like to order my one-to-many collection by a field within my composite key. Specifically, something like this:

Code:

@OneToMany(mappedBy = "product", fetch = FetchType.EAGER)
@OrderBy("pk.dateOfValuation")
private Set<Valuation> valuations;

Alas Hibernate errors when I try this.

Code:

Caused by: org.hibernate.AnnotationException: property from @OrderBy clause not found: Valuation.pk.id

If I try just "pk" then it works fine. Can what I want be done?

Thanks

Nick[/code]

mmerder · **Posted:** Thu Jan 29, 2009 6:34 am

@OrderBy is the SQL-clause to be used, when fetching the collection. Have you tried just to put the column name of dateOfValuation (@OrderBy("dateOfValuation_column"))?

nickcodefresh · **Joined:** Mon Feb 12, 2007 6:57 am **Posts:** 9

No that doesn't work I'm afraid. It needs to be one of the persistant fields.

Code:

Caused by: org.hibernate.AnnotationException: property from @OrderBy clause not found: Valuation.DATE_OF_VALUATION

mmerder · **Posted:** Thu Jan 29, 2009 10:30 am

Could you also provide code of your IdClass and your Valuation-class?