Hi, I have a parent-child structure, and I would like to load a list of all the children, sorted by the path structure, using a one-shot HQL query.
Is it possible? ... I can't figure it out

E.g. the list should return
/a
/a/b
/aa
/aa/c
/aa/d
...

Thank you
Massimo

Not possible, use one of the things I've listed in this blog entry:

http://blog.hibernate.org/cgi-bin/blosx ... gettricked

Hi,

Í have seen the blog... The problem is that the solution shown is not database independence (It isn´t using Hibernate). Does anyone know a solution for this problem using Hibernate ?

Thanks in advance,

Sergio Stateri Jr.

No, Hibernate doesn't have any additional support for hierarchical queries (well, batch selects for lazy collections helps a lot). You can easily externalize your proprietary query in a mapping file and keep it documented.