[jboss-user] [EJB 3.0] - query cache configuration

[apdo]

I 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






View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4194219#4194219

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4194219