Hi,

I've been trying to map out an object hierarchy so that I can load it with a set amount of selects (I've been having N+1 issues when simply trying to select all objects at once). I'm starting to think this sort of mapping is not possible to express efficiently in Hibernate and was hoping someone could give their opinions on whether or not this looks possible.

My mapping looks like so:

Abstract Class A;

Class B;
@ManyToOne A;

Class subA1;
@ManyToMany List<B> bList;


I can't find a proper way to map these 3 classes such that I could select all of Class A (subA1 really) without Hibernate doing a select for each List<B> in each A. Ideas?