querycache « Query « JPA Q&A





1. How to config QueryCache in ehcache.xml    stackoverflow.com

From my sql log file, I think the QueryCache's physical properties are configured by the element:

  <defaultCache
              ...

2. ehcache.xml: QueryCache configuration    forum.hibernate.org

3. Configuring a QueryCache region with JBossCache    forum.hibernate.org

Hi, I have been trying to configure a particular group of queries using a cache region as specified in the documentation. Our deployment is Hibernate 2.1.8, JBossCache 1.1.1 and Spring. All mappings are generated using xdoclet annotations in each persistent object. Hibernate DB configuration is set using a properties file injected into the Spring session factory bean at startup-time. The same ...

4. QueryCache giving exceptions with FileCacheLoader    forum.hibernate.org

Hi we are using JBoss 4.0, hibernate 3.0, in our application. We are using hibernate second level cache and now we want to use Query Caching in our application. We are using FileCacheLoader for caching. When we try to cache a query, it is giving the following exceptions: Code: org.jboss.util.NestedRuntimeException: C:\jboss-4.0.2\server\default\data\org\hibernate\cache\StandardQueryCache.fdb\sql: select deliveryty0_.id as id, deliveryty0_.delivery_type_txt as delivery2_266_ from delivery_type deliveryty0_ ...

5. mySQL QueryCache and Hibernate    forum.hibernate.org

Hibernate version: 3.1 Name and version of the database you are using: mySQL 5.0.11 We are currently wrinting something using Jboss, Hibernate and mySQL and we were looking at caching strategies. mySQL provides some nice fast QueryCaching that we had used before. We did a nice simple operation in Hibernate and right enough the query shows up in the mySQL logs. ...

6. Anyone written a QueryCache for a per Session basis?    forum.hibernate.org

I've had a good look at the QueryCache implementation and wondered if anyone has written a query cache implementation that works on a per session basis (e.g. each session has it's own query cache)? It seems like it'd be a simple change of the StandardQueryCache and UpdateQueryCache - these are fine until a session does an update - then the cache ...

8. Hibernate QueryCache    forum.hibernate.org

I am using org.hibernate.cache.StandardQueryCache. the configuration file is below: org.hibernate.dialect.PostgreSQLDialect org.postgresql.Driver postgres postgres jdbc:postgresql://localhost:5432/pep_dev 0 5 50 1800 50 1 org.hibernate.cache.EhCacheProvider true true ...

9. How to reset/clear Hibernate QueryCache?    forum.hibernate.org

Thanks for this tip I've also written the following public static void evictEntity(String schemaName, String entityName) { getSessionFactory(schemaName).evictEntity(entityName); } public static void evictQueries(String schemaName) { getSessionFactory(schemaName).evictQueries(); } @SuppressWarnings("unchecked") public static void evictAll(String schemaName) { evictQueries(schemaName); Map metadata = getSessionFactory(schemaName).getAllClassMetadata(); for (Iterator i = metadata.values().iterator(); i.hasNext(); ) { ClassMetadata classMetadata = (ClassMetadata) i.next(); evictEntity(schemaName, classMetadata.getEntityName()); } }





10. CollectionCacheEntry unsafe with QueryCache?    forum.hibernate.org

Newbie Joined: Thu Aug 16, 2007 1:34 pm Posts: 3 Hi, I have two cached queries that return a collection of the same type of object. The first query returns a subset of an association, and then the second query returns a different subset of the same association. The problem is that there is only one CollectionCacheEntry in the cache, and ...

11. QueryCache misses all the time?    forum.hibernate.org

Author Message ninomartinez Post subject: QueryCache misses all the time? Posted: Tue Aug 12, 2008 4:48 am Beginner Joined: Thu Jan 31, 2008 7:09 am Posts: 34 Need help with Hibernate? Read this first: http://www.hibernate.org/ForumMailingli ... AskForHelp Hibernate version: org.hibernate hibernate 3.2.6.ga org.hibernate hibernate-annotations 3.3.0.ga org.hibernate hibernate-entitymanager 3.3.1.ga Mapping documents: Done with JPA ...