How can i get only the first level of childrens in Hibernate

Question

If I have this three structure in a table,

-A
 |
 *---B
 |   |
 |   *---C
 |   |
 |   *---D
 |       |
 |       *---E
 |       |
 |       *---F
 |       |
 |       *---G
 *---H
     *---I
     |
     *---J

assuming list() method is called and it returns a colleccion of B and H. In this scenario I would like hibernate obtain C,D,I and J in a single query.(lazy=false is not working because I dont need E,F and G, just the FIRST LEVEL) thanks a lot

Answer 1

I don't think there is any way to achieve this. Let others know if you find something