Hey,

i need to do multiple left outer join, but if i do it more than twice i get an exception.

As i understand if i have a bag mapping i cant do left join more than two times.

I dont want to use set or list with index in the mapping , so how can i solve this problem?

Thank you

Hi,

I would suggest you check out the @CollectionId (the documentation says it is ONLY EXPERIMENTAL) annotation, as using this with "bags" means you can join/fetch multiple bags in a single query.


Cheers,

Andy

with order list and in my case i dont need order list.
i dont want extra column in the DB.

Thank you

If you do not want to use Lists with the @IndexColumn annotation, Sets, or "bags" (Collection or Lists w/o @IndexColumn) with out the @CollectionId, you have 2 options:

1) Split the query into sections where each section will not cause the "Cannot fetch multile bags" exception, and perform each seperately.

2) Use a Native Query and then map it back onto the entities.

If you don't want the schema modified then I would probably go with option 2, as option 1 will be slow.

Cheers,

Andy

I would probably go for a Set though
As for the EXPERIMENTAL mark, since it hasn't change for ages, then you can consider it non experimental :)

Emmanuel,

Thanks for the infomation regarding the @CollectionId annotation, i can start using it without any worries at the back of my mind :-) When will the Javadocs be updated ??

Cheers,

Andy

Ah I remember now, I'm not happy with the generator delcaration
But it's either gonna stay the same or be changed with @GenericGenerator();
so the migration will be smooth