[Hibernate-issues] [Hibernate-JIRA] Created: (ANN-401) @OrderBy does not work with inherited properties

[Guido L. (JIRA) <no...@at...>]

@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.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://opensource.atlassian.com/projects/hibernate/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira