I have a flat legacy table that has been denormalized and I would like to create a tree data structure from it. Is it possible to do this through hibernate?

The table has the following columns

segmentid - primary key
groupid
sectionid

and I would like to represent the data as a tree where sectionid is the root node, then groupids, finally segmentids are the leaves. Is there a way to describe this through the a hibernate mapping file.

Thank you for your time.
-Fazle

Yes, you can easily represent tree structures with hibenate. If what you want is a section with one or more groups with each group having one or more segments then create 3 POJOs: Section, Group, and Segment. Link Section and Group with a one-to-many association and link Group to Segment with a one-to-many association. I'll leave the implementation to you.

Grant