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

[Emmanuel Bernard (JIRA)]

    [ http://opensource.atlassian.com/projects/hibernate/browse/ANN-401?page=comments#action_24096 ] 

Emmanuel Bernard commented on ANN-401:
--------------------------------------

yuk
I don't really know how to work around this one.

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