Second-level caching of HQL aliases

jasonab · **Joined:** Fri May 06, 2005 2:37 pm **Posts:** 39

We're using second-level caching with Hibernate, and LEFT JOIN FETCHing multiple collections, via aliases in HQL:

LEFT JOIN FETCH listing.secondaryTags tag
LEFT JOIN FETCH tag.keyphrases
LEFT JOIN FETCH tag.tagGroups

In monitoring our cache, it appears that the main objects are being cached properly, but keyphrases and tag groups are not being cached. Is this a limitation with hql aliases?

gonzao_diaz · **Joined:** Mon Nov 26, 2007 2:29 pm **Posts:** 443

At least as far as ehcache is concerned, you have to create another section in your ehcache.xml, mentioning the complete child path, for example:

Code:

    <cache name="for.example.Listing" maxElementsInMemory="8000" 
           eternal="true" overflowToDisk="true" />

    <cache name="for.example.Listing.keyphrases" maxElementsInMemory="8000" 
           eternal="true" overflowToDisk="true" />


    <cache name="for.example.Listing.tagGroups" maxElementsInMemory="8000" 
           eternal="true" overflowToDisk="true" />