Hi,

I have create a cacheable query like this :


the problem is that the query result does not seem to get cached.

the caching works for other cached queries returning mapped object - so no prob with the configuration, I think:-)

hibernate.cache.use_query_cache is set to 'true'
and I have <cache usage="read-only"/> in the mt.domain.geo.Land mapping.

I know it is not being cached because hibernate.show_sql is set to 'true' and I see a
each time the app is calling that query.

any idea ?

thanks,

Fred

Ok,

found it !

I changed it to
and now it's ok...

see ya,

Fred

thank you very much for posting a solution to your problem after you found it. I was having the same question and that solution fixed it for me as well.


=)

Dan

Thanks for reporting your findings.

In org.hibernate.hql.QueryTranslatorImpl, the code for list() does try to go through the query cache but that for iterate() always executes the query.

I would expect the iterate method to also try the query cache before executing the query. I wonder why the difference in behaviour.

Sanjiv