I have the following classes mapped and I would like to be able to use the sortOrder property of the CorpWebLink class (which is a one-to-one mapping of the within the CorpSalesRepWebLink class) as an order-by of the corpSalesRepWebLinks set. Is this possible?

CorpSalesRepWeb
<class name="CorpSalesRepWeb" table="CORP_SALES_REP_WEB">
<id name="salesRepNumber" column="SALES_REP_NBR" type="integer">
<generator class="native" />
</id>

<property name="webName1" column="WEB_NAME1" type="string" />
<property name="webName2" column="WEB_NAME2" type="string" />

<set name="corpSalesRepWebLinks" cascade="all" inverse="true" lazy="false">
<key column="SALES_REP_NBR" />
<one-to-many class="CorpSalesRepWebLink" />
</set>

</class>

CorpSalesRepWebLink
<class name="CorpSalesRepWebLink" table="CORP_SALES_REP_WEB_LINKS">
<id name="webLinkId" column="WEB_LINK_ID" type="integer">
<generator class="native" />
</id>
<property name="salesRepNumber" column="SALES_REP_NBR" type="integer" />
<one-to-one name="corpWebLink" class="CorpWebLink" lazy="false"/>

</class>

CorpWebLink
<class name="CorpWebLink" table="CORP_WEB_LINKS">
<id name="webLinkId" column="WEB_LINK_ID" type="integer">
<generator class="native" />
</id>
<property name="linkType" column="LINK_TYPE" type="string" />
<property name="linkName" column="LINK_NAME" type="string" />
<property name="divisionCode" column="DIVISION_CODE" type="string" />
<property name="linkURL" column="LINK_URL" type="string" />
<property name="sortOrder" column="SORT_ORDER" type="integer" />
<property name="imageName" column="IMAGE_NAME" type="string" />
<one-to-one name="corpSalesRepWebLink" class="CorpSalesRepWebLink" lazy="false"/>
<one-to-one name="corpWebLinkType" class="CorpWebLinkType" lazy="false"/>

</class>

I don't think it's possible, since the orderBy clause is injected into the sql-statement. So if you wanted to order by CorpWebLink.sortOrder you needed to know the alias CorpWebLink's table gets in every statement.

Alternatively you could order the collection in CorpSalesRepWeb's setCorpSalesRepWebLinks(...) method.

I was able to get this working by mapping the sortOrder property of the CorpWebLink class to the CorpSalesRepWebLink class by using a property with a formula. Then I was able to use that property to sort the collection.