I have two tables. Both tables are entities. (see below)
Anyway, I have a one-to-many from att_option_group to att_option.
There si a sort_order on the att_option table. When I retrieve the current set of att_option objects, I would like to be able to put them into a list in order by the sort_order. Then I could shuffle the List, and persist the data again, changing the sort order dynamically. I do not want to do an order_by clause. I would like hibernate to understand the sort_order and be able to shuffle the List.

Here is my current map from att_option_group to att_option.

<set name="options" cascade="all" lazy="false" inverse="false">
<key column="att_opt_grp_id" />
<one-to-many class="com.mb.purcell.model.AttOptions" />
</set>

Could someone please .. help me with this.

Scott



mysql> select * from att_option_group
-> ;
+----------------+------------------+------------+
| att_opt_grp_id | att_opt_grp_name | sort_order |
+----------------+------------------+------------+
| 1 | Stories | 1 |
| 2 | Baths | 2 |
+----------------+------------------+------------+
2 rows in set (0.17 sec)

mysql> select * from att_option;
+------------+----------------+------------+---------------+
| att_opt_id | att_opt_grp_id | sort_order | att_opt_value |
+------------+----------------+------------+---------------+
| 1 | 1 | 1 | 1 |
| 2 | 1 | 2 | 1.5 |
| 3 | 1 | 3 | 2 |
| 4 | 2 | 1 | 2 |
| 5 | 2 | 2 | 2.5 |
| 6 | 2 | 3 | 3 |
+------------+----------------+------------+---------------+
6 rows in set (0.09 sec)

I am not sure how you exactly want a solution. In case if below scenario helps... you can try it in your implementation