@OrderBy does not work with inherited properties ------------------------------------------------ Key: ANN-401 URL: http://opensource.atlassian.com/projects/hibernate/browse/ANN-401 Project: Hibernate Annotations Type: Bug

Components: binder Versions: 3.2.0.cr1 Environment: Hibernate 3.2, MySql 4, Windows XP Reporter: Guido Laures

Using an @OrderBy with an inherited property produces an SQL Exception. Example: @Entity class Base { ... public int getPropertyForOrderBy(){ return propertytoOrderBy; } ... } @Entity @PrimaryKeyJoinColumn(name="a_id") class A extends Base { ... } @Entity @PrimaryKeyJoinColumn(name="b_id") class B extends Base { ... @OneToMany(mappedBy = "someProp", cascade = { CascadeType.ALL }) @OrderBy("propertyToOrderBy") public Set<A> getASet() { return this.aSet; } ... } Thus, if A references a set of Bs and wants it to be ordered by a property of B's base class Base it crashes. The generated SQL string tries to find the property from the base class in the table of the inerited class (A) which fails.