Hibernate version:
2.1.6

Code between sessionFactory.openSession() and session.close():
run the query only

Full stack trace of any exception that occurs:
No exception

Name and version of the database you are using:
Mysql

I have a class with, let's say, 3 one-to-many collections.
How can I retrieve the the 3 collections together with the parent object in one query? This should be done with FETCH, but I find that one query can use with ONE fetch only. Any suggestion is welcome.

Thanks in advance.

Sounds like you answered your own question :) Perhaps you just didn't like the answer...

Only a single collection association can be fetched at a time.

There are other ways to do it. There was a post just last week about how to approximate this behavior.

Steve, you mean this one?
http://forum.hibernate.org/viewtopic.php?t=935555

(I'm trying to collect a bunch of different ways of doing this and some other tricky things that people keep messing up in our project. So if this is one of the accepted ways of querying multiple one-to-many collections, I want to put it in our doco).

For honesty, I do prefer multiple-fetch as it seems to be essential and basic to most of the proj in the world ( I strongly believe that )


Compare to set everyting non-lazy, multiple-fetch is much more practical and fleasible.

Anyway, thanks a lot.