Hi,

I have a entity Recipe and it has 3 collections images, comments and ingredients. The are mapped as a bag.

For a website I want to load the recipe collections with the recipe ie not lazy load so I discovered I could do that using this query

from Recipe r
left join fetch r.Images
left join fetch r.Ingredients
left join fetch r.Comments

But this gives an exception

Cannot fetch multiple collections in a single query if one of them is a bag

So how do I not lazy load my recipe and have the collections loaded allowing for the fact that there may not be any rows in that collection?

I'm new at this and need an explanation

Malcolm

Hi malcolms,
This is a limitation that you can't parallel load multiple collection eagerly using join if any one of collection is mapped using bag.

One solution which you can try is add following new attributes (lazy and fetch) in one-to-many element for Ingredients and Comments property -



and then try following query-