order-by in <set name=""> in mapping not wor

rajeev2009 · **Joined:** Thu Mar 05, 2009 2:58 am **Posts:** 4

Hibernate version: 3.0.5

In my.hbm file I am fetching a table as a set

<set name="someSet" table="someTable" lazy="false" inverse="true"
order-by="columnName desc" cascade="all-delete-orphan">
<key>
....
</key>
<one-to-many class="package.className" />
</set>

The order-by clause is not working

What could be the reason?

mmerder · **Posted:** Thu Mar 05, 2009 3:39 am

What do you mean with not working? Is there no order by in the sql string or is the collection not ordered? If you provide some more code, we can maybe help.

mmerder · **Posted:** Thu Mar 05, 2009 3:44 am

What do you mean with not working? Is there no order by in the sql string or is the collection not ordered? If you provide some more code, we can maybe help.

rajeev2009 · **Joined:** Thu Mar 05, 2009 2:58 am **Posts:** 4

When I add the attribute order-by in the .hbm file, I expected the list of records that is fetched from database to be sorted on that column in DESC order.

But that did not happen.
What could be the reason?

mmerder · **Posted:** Thu Mar 05, 2009 10:05 am

Could you provide some more information like code or mapping?