Hi
I'm using ehcache for caching the query results using th flg code ...

<!--In ehcache.xml-->
<cache name="query.ABC"
maxElementsInMemory="5"
eternal="false"
timeToLiveSeconds="86400"
overflowToDisk="true"/>

and in java class i added the flg code

query.setCacheable(true);
query.setCacheRegion("query.ABC");

<!-- In hibernate.cfg.xml-->

<property name="hibernate.cache.use_query_cache">true</property>
<property name="hibernate.cache.query_cache_factory">net.sf.hibernate.cache.StandardQueryCache</property>

I'm able to create cache but unable to find solution to retrieve the results from cache... anybody can help... Thanks in advance...

You need to set the class you are querying for to be cacheable too.

Use the <cache> element in the class mapping file.

HTH,

Ben

Hi,
I've also placed the cache tag in class mapping file...my query results are being cached...but I need to retrieve them from the cache.. which I'm unable to do it....Is there any API to retrieve results and display the list.

Isn't the idea that if you cache the results, it's transparent as far as the application code is concerned ? You cache the results, so that next time you do the query, it gets them from the cache rather than the database.