Hibernate version: 3.2GA
DataBase: postgresql 8.1.5
Hi all,

I need some advice I have this object: Parent who has a collection of children, pretty much like this:



Children collection is lazy, and I want to write an HQL query to initialize the parentalong
with his children:

I've tried 2 solutions.
First:


But this wont return any Parent without children.
I've also tried:



But this would result in repeated Parent's on the list (once for every child).

Is there any other way of achieving this? Am I missing something?

Thanks in advance,

Miguel.

edit: I missed the fetch part of the second query

Well they were really about the second approach:

http://www.hibernate.org/hib_docs/v3/reference/en/html_single/#objectstate-querying-executing

At the last part of the section it says:



I guess this is far more efficient than a simple query and then initializing the collections at hand with Hibernate.initialize...

But particularly I would love this to work with inner joins, but I guess it doesn't due to the nature of inner joins.

cheers,

Miguel