Need help with Hibernate? Read this first:
http://www.hibernate.org/ForumMailingli ... AskForHelp

Hibernate version:3.1.3

Name and version of the database you are using:SQL Express 2005

I have an HQL query like this:

select b from A as a
join a.B as b
join fetch b.C
join fetch b.D

Where A many-to-one B
B many-to-one C
B many-to-one D

then I tried to iterate through the result
b, b.C, b.D

It worked all fine for one DB. But for other DB with different data set,
some b.C are not fetched. If session is not closed it will issue extra SQL query to get the b.C; while if the session is closed, it will exception out.

I guess this could be data problem, however, I can hardly image any cases this would have happened.