I have a named query in my hibernate mapping file:



Note that cacheable is true, and I'm not providing a cache region so the query is cached in the default region. I want to get a list of all the queries that are currently cached in the default region, so I have the following code:



This code yields a ClassCastException on Line 50 of SecondLevelCacheStatistics.java because the key is of type QueryKey but it is being cast to a CacheKey.



I had a similar issue before and Gavin told me my problem was that I was putting cached objects in the same region as cached queries. I've solved that problem, but now I'm doing something much simpler and I still have pretty much the same issue. If I'm not supposed to be accessing the standard query cache via the second level cache statistics api that's fine, but then I'd argue that "org.hibernate.cache.StandardQueryCache" shouldn't come back when I call sessionFactory.getAllSecondLevelCacheRegions().

Can anyone see what I'm doing wrong, or is there something amiss here?

Thanks,
Max

Hibernate version:
3.0.4
Mapping documents:

Code between sessionFactory.openSession() and session.close():
None, I'm doing this outside a session.
Full stack trace of any exception that occurs:
java.lang.ClassCastException: org.hibernate.cache.QueryKey
at org.hibernate.stat.SecondLevelCacheStatistics.getEntries(SecondLevelCacheStatistics.java:50)

Name and version of the database you are using:
MySql

I agree. At the moment (v 3.0.5), you cannot use the Statistics Api to display query cache entries.

The issue is very simple to reproduce in any hibernate app:

- run a cacheable query so the cache region has an entry
- get the SecondLevelCacheStatistics for this region
- call getEntries
- bang! ClassCastException

It's not the end of the world (I can go direct into my cache provider to get this info) but it would be nice if this worked. On a quick browse of the source, maybe could be fixed by having QueryKey and CacheKey implement a common interface with a getKey method.