How do you deal with composite pattern when using hibernate and domain-driven design?

Question

Does hibernate has support for hierarchical data in a database where

• you use a parentId
• you use a parentId and an orderId
• you use Modified Preorder Tree Traversal

Answer 1

You can try this

Answer 2

Hibernate supports Modified Preorder Tree Traversal in that lets you define the left/right properties. It does not support hierarchic queries however, but it's pretty trivial to re-hierarchize objects out of linear query if you order that by left value.