Hi,

anyone knows if there is way for bidirectional associations (many-to-one-end, not-null) to use lazy loading or caching (second level or session)?

I have a problem where linked models keep loading the same data over and over. Resulting in very huge SQL selects and slow performance.

I could not find anything in the docs.

Regards and thank you in advance for any hint,

Alex

I search through the net how other tools handle this:

I found that a O/R tool called Cayenne has a mechanism called "Prefetching" for handling these situations:

http://objectstyle.org/cayenne/userguide/perform/prefetching.html

Can anyone please give my hint, what to do in hibernate?

Regards,

Alex

Critieria, FetchMode, "fetch" in HQL