Hibernate @OrderBy for nested properties

Question

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?

Vlad Mihalcea · Answer 1 · 2016-10-28T04:31:34.600

You can use the Hibernate @SortComparator annotation:

Like this:

@OneToMany(mappedBy = "paramSpec", cascade = CascadeType.ALL)
@SortComparator(ReleaseComparator.class)
private List<PkdbParameter> pkdbParams;

Where CameraNameComparator is:

public class ReleaseComparator implements Comparator<PkdbParameter> {
    @Override
    public int compare(PkdbParameter o1, PkdbParameter o2) {
        return o1.getRelease().getOrdinal().compareTo( o2.getRelease().getOrdinal() );
    }
}

score 4 · Accepted Answer · edited May 23 '17 at 12:33

4

@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

edited May 23 '17 at 12:33

Community

1
1

answered Mar 22 '13 at 10:36

anergy

1,374
2
13
29

score 0 · Answer 3 · answered May 26 '14 at 16:10

0

You can split the order statements and place it on non collection properties:

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

and

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

As a side effect, you have fixed sort order for PkdbParameter.

answered May 26 '14 at 16:10

Tires

1,529
16
27

1

I tried this one but it seems ordering a ManyToOne is just ignored. – Fabricio Buzeto Apr 07 '15 at 14:48
This will simply ``ORDER BY pkdbParams1_.release`` and ignore the ``ordinal`` property altogether, which is most certainly not what the original poster wants. – user1438038 Aug 15 '18 at 09:41
Is it possibly a different behavior on Hibernate versions? – Tires Aug 15 '18 at 12:47
Set ``hibernate.show_sql = true`` in your ``persistence.xml`` file and see for yourself, what SQL code is created by Hibernate. – user1438038 Aug 17 '18 at 08:53
Thank you for verifying this thesis. – Tires Aug 17 '18 at 19:35

Hibernate @OrderBy for nested properties

3 Answers3