Hi,

I'm currently evaluating to use Hibernate for stateless, criteria-query only fetching of object-records. I want to specify which associations are to be fetched beforehand instead of using lazy loading. StatelessSession and Criteria fits my needs so far. I'm using criteria.setFetchMode("association", FetchMode.JOIN) to get the associations eagerly-fetched. But I'm wondering: Is a JOIN in all cases the best/correct way to fetch associations? Don't you send huge additional amounts of data over the wire when fetching multiple associations using a join? I'm especially wondering because FetchMode.EAGER / FetchMode.SELECT don't work (they simply mean LAZY which is of no use for a Stateless session) and related bug reports was rejected as "they are not meant to be" (HHH-1211 FetchMode.SELECT not working on criteria queries).

Also, is there a way to buy Hibernate support only - the "Red Hat Developer Subscription" has a hefty price tag if you only want Hibernate support and not the full Red Hat support package...

Greetings,
Ralf
http://www.ralfebert.de/blog/