> I am aware of the note from the manual that says "Iterating results is not possible with queries that fetch-join a collection-valued association. The nature of such SQL result sets is not suitable for incremental hydration.". But is there a work-around for this? I need to retrieve a set of fetch-joined entities and I really would like to hydrate them one by one instead of loading the all the entities in memory. The obvious alternative is to load each association of each entity (and the associations' associations) manually (by accessing them), but this will trigger way too much queries. I should mention that retrieving the result set as arrays doesn't help me, what I need are the entities (and their loaded associations).