Hello all.
I have 3 classes

let's say Class A,B and C.

Class A has a manytoone to B and B has manytoone to C.

When i run a query by filtering all results of class A, it runs a select query for each row of class B.
Can't this be done in a single query?
I'm using

new Criterion[]{Restrictions.eq("id.companyId", companyId)}

for filter, not a string query and.

@ManyToOne( cascade = {CascadeType.ALL}, fetch = FetchType.EAGER )
@JoinColumn(name="COLUMNNAME")

for the 2 manytoone relations

Thnx in advance

OK it seems that the problem exists because class A has an embeddedId being a manytoOne relationship. In all other cases left outer join is ok.
Any ideas how we can "force" it to be done there too?