Hibernate version: 2.1.6

Sorry if someone posted before.

I have a lazy one-to-many association and want to get sorted items:
<set items table="JOIN_TABLE" cascade="save-update" inverse="false"
lazy="true" order-by="??????">
<key column="ITEM_ID"/>
<one-to-many class name="..."/>
</set>

How do I specify the order-by ? It seems that the I can only use a column in the JOIN_TABLE but what I want is to sort the items based on a column in the ITEMS table.

any solution ?

thanks
li xin

Have you tried? Seems like this is the expected behavior. if it is not working, please post more information about your mappings.

Here is the mapping file - A has one-to-many association with B:

A
===
<hibernate-mapping>
<class name="A" table="A">
<id name="aId" type="long" column="A_ID" unsaved-value="0">
<generator class="identity"/>
</id>

<property name="aName" type="string" not-null="true" column="NAME"/>
<set name="bs" table="A_B" cascade="save-update" inverse="false" lazy="true">
<key column="A_ID"/>
<one-to-many class="B"/>
</set>

</class>
</hibernate-mapping>


B
===

<hibernate-mapping>

<class name="B" table="B">
<id name="bId" type="long" column="B_ID" unsaved-value="0">
<generator class="identity"/>
</id>

<property name="bName" type="string" not-null="true" column="NAME"/>

<property name="sequence" type="integer" column="SEQUENCE"/>

</class>
</hibernate-mapping>

So what I would like is to have the 'order-by' in class A, sort the bs according to the column SEQUENCE in class b.

is it possible ?

thanks
li xin