query cache configuration
apdo Dec 4, 2008 2:17 AMI am using jboss 4.2.3 GA
I want to use EJB3 with caching. I don't plan in the short term to use clustering. Is Jboss cache the most common caching mechanism to be use for EJB3 on Jboss?
To enable caching on the default configuration, I follow the french instruction provided in at the following location:
http://wiki.objetdirect.com/wiki/index.php?title=Cache_2nd_niveau_Hibernate
It says to copy the following file from the all configuration to the default configuration:
jboss-cache*.jar
jgroup*.jar (most probably useless in my case since I doesn't use clustoring.)
ejb-entity-cache-service.xml
I have confured ejb-entity-cache-service.xml with LOCAL since I am not using clustering.
My persistence.xml file look like this:
<persistence> <persistence-unit name="securityEJB3"> <jta-data-source>java:/securityEJB3DS</jta-data-source> <properties > <property name="hibernate.hbm2ddl.auto" value="update"/> <property name="hibernate.dialect" value="org.hibernate.dialect.SQLServerDialect"/> <property name="hibernate.show_sql" value="true"/> <property name="hibernate.cache.use_query_cache" value="true"/> <property name="hibernate.cache.provider_class" value="org.jboss.ejb3.entity.TreeCacheProviderHook" /> <property name="hibernate.treecache.mbean.object_name" value="jboss.cache:service=EJB3EntityTreeCache" /> </properties > </persistence-unit> </persistence>
According to my test, caching is working well if I find object using the entitymanager .find method and when I find entity children of another entity. I conclude that it is working find since after activating the second level caching I see Hibernate query in my server.log only for the first time I get an entity. The following call to entitymanager.find for the same entity doesn't generate hibernate query in my log.
However, I think that my configuration didn't enable the query cache since for every execution of the same query using entitymanager.createQuery
I see the hibernate query in my server.log file.
Could you please tell me what is missing in my configuration to make the query cache working?
Thank you,
An Phong Do