title: Hibernate: eagerly fetching depth limit
body: <p>suppose i have a table named Products which is self-joined using a foreign key: parent_product_id -> id. Now in the corresponding hibernate Products model i got a Set which is consisted of all the child products of <em>this</em> product. Fetch mode is set to EAGER because i want to get all the children products of <em>this</em> product when <em>this</em> product is fetched. But, the thing is, i dont want to get all the children's children (grandsons of <em>this</em> product) or children's children's children (great-grandsons of <em>this</em> product), which is what i get with the EAGER fetching. I just want the first ones - just the first children of <em>this</em> product. It is like the Product should be first fetched eagerly, then it should switch to lazy fetching. What should i do?</p>
  
  <p>Thanks in advance </p>