I am trying to order a set by a property of the child object. Whenever I do this, the sql generated thinks that the order-by property belongs to the parent object and not the child.

The main object is called Split and contains a set of Regions. I am trying to order the set of regions in Split by the property Regions.name. The mapping is:

<class name="Split" table="split">
...
<set name="regions" lazy="true" cascade="none" table="split_region" order-by="name_region">
<key column="id_split"/>
<many-to-many class="com.pga.matrix.geo.Region" column="id_region"/>
</set>
</class>

<class name="Region" table="geo_region">
<id name="id" type="int">
<column name="id_region"/>
<generator class="native"/>
</id>
<property name="name" column="name_region" type="string" not-null="true" length="50"/>
</class>

The generated SQL (show_sql=true):

Hibernate: select regions0_.id_split as id_split__, regions0_.id_region as id_region__, region1_.id_region as id_region0_, region1_.name_region as name_reg2_0_, region1_.shortname_region as shortnam3_0_, region1_.region_number as region_n4_0_ from split_region regions0_ inner join geo_region region1_ on regions0_.id_region=region1_.id_region where regions0_.id_split=? order by regions0_.name_region


Hibernate version: 2.1.6

How can I get the order-by clause to work correctly? The correct sql in the snippet above should be "... order by region1_.name_region".

As far as I remember the only way for this would be a custom Comparator class which you have to implement by your own. Use then the sort attribute for your set. Example:


HTH
Thomas

See:

http://forum.hibernate.org/viewtopic.ph ... ny+orderby

This is what you want to do right?

That answers my question. It isn't currently supported.