Hi alls.
How could i set "order-by" condition in such case:
Table A {
....
}

Table B {
....
position integer
}

A <-- many-to-many --> B = A <-- C -- > B
so my mapping looks like this:

<bag
name="listB"
table="table_C"
lazy="false"
inverse="false"
cascade="save-update"
>
<key
column="a_id"
/>

<many-to-many
class="MyB_Blass"
column="b_id"
outer-join="auto"
/>
</bag>

Now i want to order by list of N\MyB_Class, but if i write bag so:
<bag
name="listB"
table="table_C"
order-by="position"
...
>

The hibernate looks for "position" column in table C ont B.
How can i say hibernate to looks in table B column ?

Thank's

The order-by attribute always refers to the "collection table". In the case of a many-to-many, this is the link table.

Yes, i know it. And i asked it is possible to sort such many-to-many ?

please see the Hibernate documentation. it mentions several options.