inner fetch join results in 2 selects

dwsmith75 · **Joined:** Sat Oct 30, 2004 3:48 pm **Posts:** 14

With hibernate 2.1.7c I can not get the full object graph to load without 2 calls to the database

Code:

class XO{
  long id;
  String xString;
  Set yset
}
class YO{
  long id;
  String yString;
  Set zset
}
class ZO{
   long id;
   String zString;
}

from XO x
  left join fetch x.yset y
  left join fetch y.zset z
  where x.id = '21'
  and y.yString = "halb"

The select hibernate creates contains all 3 elements (XO,YO,and ZO) inner joined properly

As soon as I access YO another select is generated for YO, the sql doesn't have any elements of ZO. It appears ZO is fetched eagerly but YO isn't. Is there anyway to fetch the whole graph in one query?

dwsmith75 · **Joined:** Sat Oct 30, 2004 3:48 pm **Posts:** 14

I have tried both inner join fetch and left join fetch

anthony · **Posted:** Fri Dec 10, 2004 4:55 pm

only one collection can be fetched in a query as said in the doc

dwsmith75 · **Joined:** Sat Oct 30, 2004 3:48 pm **Posts:** 14

Could i start from the the middle, YO in this case if it has is bi directional, and fetch join X and Z?

dwsmith75 · **Joined:** Sat Oct 30, 2004 3:48 pm **Posts:** 14

Yea, it works thanks! :)