How to get entries from the second level query cache ?

Posted by fabien7474 on Stack Overflow See other posts from Stack Overflow or by fabien7474
Published on 2010-05-15T21:51:18Z Indexed on 2010/05/15 22:50 UTC
Read the original article Hit count: 333

Filed under:

hibernate

|

grails

|

second-level-cache

|

java

In my grails application, I want to display all the current entries of the second-level cache from all regions.

My code is as following :

def getCacheStats() {
  StatisticsImpl stats = sessionFactory.statistics
  for (regionName in stats.secondLevelCacheRegionNames) {
    log.debug stats.getSecondLevelCacheStatistics(regionName).entries
  }
}

However everything works fine as long as the region name is not org.hibernate.cache.StandardQueryCache (region used for Query Cache). In that case, an exception is thrown :

java.lang.ClassCastException: org.hibernate.cache.QueryKey cannot be cast to org.hibernate.cache.CacheKey

Having googling around, I didn't find any clues about how to display the list of entries of the cached query result sets associated with regions StandardQueryCache and UpdateTimestampsCache.

Could you please help me find a solution for this?

© Stack Overflow or respective owner

Related posts about hibernate

Hibernate unable to instantiate default tuplizer - cannot find getter

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to use Hibernate to persist a class that looks like this: public class Item implements Serializable, Comparable<Item> { // Item id private Integer id; // Description of item in inventory private String description; // Number of items described by this inventory item private int… >>> More
Hibernate + PostgreSQL : relation does not exist - SQL Error: 0, SQLState: 42P01

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I am having some problems trying to work with PostgreSQL and Hibernate, more specifically, the issue mentioned in the title. I've been searching the net for a few hours now but none of the found solutions worked for me. I am using Eclipse Java EE IDE for Web Developers. Build id: 20090920-1017… >>> More
Problem connecting to Hsqldb via Hibernate when running a Eclipse GWT project.

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I'm trying to run a simple GWT project where I'm trying to do a simple persitence via hibernate to a HSQLDB database. The database I'm using I have been using for at least 2 years with several osgi applications without any problems. So all I done is reused the same configuration and added a simple… >>> More
Hibernate : load and

as seen on Stack Overflow - Search for 'Stack Overflow'
According to the tutorial : http://jpa.ezhibernate.com/Javacode/learn.jsp?tutorial=27hibernateloadvshibernateget, If you initialize a JavaBean instance with a load method call, you can only access the properties of that JavaBean, for the first time, within the transactional context in which it… >>> More
Hibernate Exception, what wrong ? [[Exception in thread "main" org.hibernate.InvalidMappingException

as seen on Stack Overflow - Search for 'Stack Overflow'
I use netbean 6.7.1 to write "hello world" witch hibernate, but I get some errors, plz help me, thank you very much. my exception init: deps-module-jar: deps-ear-jar: deps-jar: Copying 1 file to F:\Documents and Settings\My Dropbox\DropboxNetBeanProjects\loginspring\build\web\WEB-INF\classes compile-single: run-main: Oct… >>> More

Related posts about grails

Grails, app-engine, jpa - beginner having trouble with grails generate-all

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to learn about grails with Google App Engine and JPA by following a few tutorials: http://www.morkeleb.com/2009/08/12/grails-and-google-appengine-beginners-guide/ http://inhouse32.appspot.com/index.html http://grails.org/plugin/app-engine I've got grails 1.3.0 RC 2, and App Engine SDK… >>> More
Grails Warnings/Errors during run-app

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm currently seeing the warnings below when trying to run my Google App Engine/Grails test app in Eclipse. Warning, target causing name overwriting of name startLogging Warning: C:\Users\Some Person.grails\1.2.0\projects\test-grails\plugins\app-engine-0.8.8\grails-app\conf\spring not found. Warning:… >>> More
Grails, app-engine, jpa - TargetInvocationException

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to learn about grails with Google App Engine and JPA by following a few tutorials: http://www.morkeleb.com/2009/08/12/grails-and-google-appengine-beginners-guide/ http://inhouse32.appspot.com/index.html http://grails.org/plugin/app-engine I've got grails 1.3.0 RC 2, and App Engine SDK… >>> More
Inject log object in Grails class outside of grails-app

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a class in src/groovy in my grails project. How do i make a log field that gets injected with the correct logger for that class ? Is there a commons logging or just log4j in grails ? >>> More
grails run-war connects to mysql but grails run-war doesn't

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I have a unexpected problem. I had create a war with grails war. Then I had deployed in Tomcat. For my surprise the crud works fine but I don't know what persistence is using. So I did this test: Compare grails prod run-app with grails prod run-war. The first works fine, and does conect with… >>> More