I have a table that is structured like so:

MENU_NO <PK>
MENU_NAME <varchar>
MENU_PARENT (refers back to MENU_NO)<numeric>
MENU_ORDER<numeric>

would there be a way to have hibernate populate the MENU_ORDER column automatically. The MENU_ORDER column should go in numerical order based on the MENU_PARENT column. If it is the top level menu row, the parent is 0. For example:

Menu_no, Menu_name, Menu_parent, Menu_ord
1, menu name, 0, 1

2, menu name, 0, 2

3, menu name, 1, 1

4, menu name, 1, 2

5, menu name, 1, 3

Thanks for the help

Paul