Hibernate @OrderBy for nested properties

java hibernate jpa orm hibernate-mapping
Piotr Sobczyk picture Piotr Sobczyk · May 9, 2012 · Viewed 8.3k times · Source

I need to use @OrderBy (JPA, Hibernate as provider) to sort collection for nested property:

@OneToMany(mappedBy = "paramSpec", cascade = CascadeType.ALL)
@OrderBy("release.ordinal")
private List<PkdbParameter> pkdbParams;

In PkdbParameter.java:

...
@ManyToOne
@JoinColumn(name = "release_id")
private Release release;
...

In Release.java:

...
private int ordinal;
...

(all of these fields have simple getters and setters provided)

Unfortunately I'm getting error:

Caused by: org.hibernate.AnnotationException: property from @OrderBy clause not found: some.package.PkdbParameter.release.ordinal

What's wrong with this code? If it's impossible to use nested properties notation is there any other way to order for ordinal property?

Answer

anergy picture anergy · Mar 22, 2013

@OrderBy works only with direct properties or embedded attributes. From Java EE 6 docs

The dot (".") notation is used to refer to an attribute within an embedded attribute

So if the Release is an embedded attribute, this could work. Otherwise you could use named query as suggested here

Related questions

How to map calculated properties with JPA and Hibernate

My Java bean has a childCount property. This property is not mapped to a database column. Instead, it should be calculated by the database with a COUNT() function operating on the join of my Java bean and its children. It …

Read More
Hibernate throws strange error: Class is not mapped

this is the error org.hibernate.hql.ast.QuerySyntaxException: Payment is not mapped [select p from Payment p] I don't understand how come this error is thrown, the class should be mapped as I will show you briefly. I have …

Read More
Delete child from parent and parent from child automatically with JPA annotations

Suppose that we have 3 Entities object class: class Parent { String name; List<Child> children; } class Child { String name; Parent parent; } class Toy { String name; Child child; } How can I use JPA2.x (or hibernate) annotations to: Delete all …

Read More