Hello,

I have 3 tables

A --- one to many --- B ---one to many ---C (they are related by Set collection)

I have the outer join turned off and lazy = true at global level.

For specific instances however, I do need to load all the related collections B and C if I query for A.

The HQL query that I am using is:

session.find("from A as aa left outer join fetch aa.b as bb left join fetch bb.c where aa.id = 1);

I get the object A back. However, after closing the session, if I do a get size of any of the A's related collection, I get lazy initialization error.

"
Failed to lazily initialize a collection - no session or session was closed"


I was under the impression that doing a fetch should load the collection eagerly and can be accessed even if I close the session.

For the timebeing I don't have any records in B and C. However, I shoud have got size as 0 based on my understanding.

Am i misunderstanding something?


Thanks
Shishir

i think you can only load collection of B but not collection of C


(with select a) this should return all a instances with its collections loaded, but for C ...

in the doc you have:

Crap:). You are right. It'd doing at only one level. What's the best way to implement thiis. My different business requirements require that sometime I traverse till B , or somethime I traverse all the way till C.

One approach is to have two methods in the business domain. One which just initializes the B . Other method doing Initialization of B as well as C for Each b. This then introduces duplication of code.

The other way is to load all the way till C in all cases. But then that's a permornce issue for cases C is being loaded when not required at all.

IMHO, I would go for duplication of code rather than the 2nd one. Any other suggestions ?

Thanks
Shishir

Also,

If I need to initialize B and C for A , how can I do it by join without iterating for each B obtained from A. In other words, how can I do it by breaking up the joins for A-B and B-C, note , I should get the same object A back and not another instance of A.

Thanks
Shishir

please reformulate

What I meant was

How to initialize Collection B and collection C after quering for A (with global lazy = true and outer join = false, using explicit join statements,

without having to do a nested iteration through collection B and initializing C for each B.