Hi,

May be I'm missing something small but spent almost the whole day to figure out my problem. I have an object graph : Object A contains sets of Object B which inturn contains Object C. I could able to get the whole object graph with some criteria mentioned on the hbm.xml file but now I would like to get the object graph based on some conditions in Object B.


Here is my query:

select * from A,B,C where A.id = B.foreign_id and B.id = C.foreign_id and B.name = 'blah' and A. date>= Sysdate.

When i do the above query using sess.find(), I'm not getting Object A contains Object B contains Object C but rather the first element in the list Object A, the second element in the list is Object B and third is Object C.

Please let me know if I'm doing anything wrong. I'm using Hibernate 2.0 with Oracle

Thanks
Raghu