Retereive data by ORDER BY

[Mike Boota]

Hi I need a small help in getting the data as per the order it's entered in the table. I am building a menu that has sub-menus.
In SUB_MENU table I also have a order_by column and in my hbm.xml file I specify orderby on that column it returns me data in correct order.

ParentMenu does not have order_by column how can I get the data ordered by on id column for my ParentMenu i.e. a sequence. Or do I need a order_by column in ParentMenu table and then specify ordyby on that column too.

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.ref.menu.ParentMenu" table="MENU">
        <id name="id" column="ME_ID" type="long">
            <generator class="sequence">
            <param name="sequence">MENU_SEQ</param>
        </generator>
        </id>
<property name="Title" type="string" length="50" column="TITLE" not-null="true"/>
<property name="Url" type="string" length="250" column="URL" not-null="true"/>
<property name="crDate" type="timestamp" column="CREATED_DATE"/>
    <property name="crBy" type="string" length="35" column="CREATED_BY"/>
    <property name="targ" type="string" length="10" column="TARGET"/>
    <set name="subMenu" table="EPL_SUB_MENU" order-by="ORDER_BY">
        <key>
            <column name="ME_ID"/>
        </key>
        <one-to-many class="com.ref.menu.SubMenu" />
    </set>
    </class>
</hibernate-mapping>
 

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping>
    <class name="com.ref.menu.SubMenu" table="SUB_MENU">
        <id name="id" column="SUB_ME_ID" type="long">
            <generator class="sequence">
            <param name="sequence">SUB_MENU_SEQ</param>
        </generator>
        </id>
<many-to-one name="parentMenu" class="com.ref.menu.ParentMenu">
        <column name="ME_ID" />
    </many-to-one>
<property name="subMenuTitle" type="string" length="50" column="SUB_MENU_TITLE" not-null="true"/>
<property name="subMenuUrl" type="string" length="250" column="SUB_MENU_URL" not-null="true"/>
<property name="subMenuActive" type="string" length="1" column="SUB_MENU_ACTIVE" not-null="true"/>        
<property name="createdDate" type="timestamp" column="CREATED_DATE"/>
    <property name="createdBy" type="string" length="35" column="CREATED_BY"/>
    <property name="target" type="string" length="35" column="TARGET"/>
    <property name="orderBy" column="ORDER_BY" not-null="true"/>
    </class>
</hibernate-mapping>

Thanks

[Mike Boota]

Any idea how I can achieve this. Thanks

[newbie awo]

What happens if you try adding something like sort="MyComparatorClass" to the set of SubMenus (in the ParentMenu mapping)?

(Then you could implement a class which implements java.util.Comparator and whose compareTo method allows the SubMenu objects to be sorted by the property that maps to your order-by column.)
[ September 06, 2006: Message edited by: newbie awo ]

[Mike Boota]

My Sub Menu is in order as I have

<set name="subMenu" table="SUB_MENU" order-by="ORDER_BY">

But the issue is how to get the data ordered by id column on my Parent Menu. id is a number field in my Menu Table. That is my Parent menu is not ordered. e.g. in my Parent Menu table If I have the following data

A 32
B 2
C 4

it shows up in that order, but I would like to see it in the following order i.e. order by id

B
C
A

Thanks