Using JBossCache on a Java Persistence with Hibernate standa

[newbeee]

Hi There,

I am using JBossCache on a Java Persistence with Hibernate standalone program.

My persistence.xml file has

<persistence-unit name="ehiveimport" transaction-type="RESOURCE_LOCAL">

 <properties>
 <property name="hibernate.connection.url" value="jdbc:derby:importDB"/>
 <property name="hibernate.connection.driver_class" value="org.apache.derby.jdbc.EmbeddedDriver"/>
 <property name="hibernate.connection.password" value="importDB"/>
 <property name="hibernate.connection.username" value="importDB"/>
 <!-- <property name="hibernate.cache.provider_class" value="org.hibernate.cache.NoCacheProvider"/>-->
 <property name="hibernate.dialect" value="org.hibernate.dialect.DerbyDialect"/>

 <property name="hibernate.cache.use_second_level_cache" value="false"/>
 <!-- Provider is JBoss Cache with Optimistic locking -->
 <property name="hibernate.cache.provider_class" value="org.hibernate.cache.OptimisticTreeCacheProvider"/>
 <!-- JBoss Cache configuration file name -->
 <property name="hibernate.cache.provider_configuration_file_resource_path" value="jboss-cache.xml"/>
 <!-- Use query cache too -->
 <property name="hibernate.cache.use_query_cache" value="true"/>

 <property name="hibernate.transaction.manager_lookup_class" value="com.ehive.transaction.EHiveJBossTransactionManagerLookup"/>

</properties>

</persistence-unit>

And my jboss-cache.xml has

<?xml version="1.0" encoding="UTF-8" ?>
<server>
 <classpath codebase="./lib/jboss" archives="jboss-cache-jdk50.jar, jgroups.jar" />

 <!-- ==================================================================== -->
 <!-- Defines TreeCache configuration -->
 <!-- ==================================================================== -->
 <mbean code="org.jboss.cache.TreeCache" name="jboss.cache:service=TreeCache">
 <depends>jboss:service=Naming</depends>
 <depends>jboss:service=TransactionManager</depends>


 <!-- Configure the TransactionManager -->
 <attribute name="TransactionManagerLookupClass">
 org.jboss.cache.GenericTransactionManagerLookup
 </attribute>

<!--
Node locking scheme : PESSIMISTIC (default) OPTIMISTIC -->
<attribute name="NodeLockingScheme">OPTIMISTIC</attribute>

 <!--
 Node locking isolation level :
 SERIALIZABLE
 REPEATABLE_READ (default)
 READ_COMMITTED
 READ_UNCOMMITTED
 NONE

(ignored if NodeLockingScheme is OPTIMISTIC)
 -->
 <attribute name="IsolationLevel">REPEATABLE_READ</attribute>

 <!-- Lock parent before doing node additions/removes -->
 <attribute name="LockParentForChildInsertRemove">true</attribute>

 <!-- Valid modes are LOCAL
 REPL_ASYNC
 REPL_SYNC
 INVALIDATION_ASYNC
 INVALIDATION_SYNC
 -->
 <attribute name="CacheMode">REPL_SYNC</attribute>

 <!-- Whether each interceptor should have an mbean
 registered to capture and display its statistics. -->
 <attribute name="UseInterceptorMbeans">true</attribute>

 <!-- Name of cluster. Needs to be the same for all TreeCache nodes in a
 cluster, in order to find each other -->
 <attribute name="ClusterName">JBoss-Cache-Cluster</attribute>


 <!-- The max amount of time (in milliseconds) we wait until the
 initial state (ie. the contents of the cache) are retrieved from
 existing members in a clustered environment
 -->
 <attribute name="InitialStateRetrievalTimeout">5000</attribute>

 <!-- Number of milliseconds to wait until all responses for a
 synchronous call have been received.
 -->
 <attribute name="SyncReplTimeout">10000</attribute>

 <!-- Max number of milliseconds to wait for a lock acquisition -->
 <attribute name="LockAcquisitionTimeout">15000</attribute>



 </mbean>
</server>

In my entity beans I have
@Cache(usage = CacheConcurrencyStrategy.READ_ONLY)

Caching does not improve performance when I do a query entityManager.find(......)

With or without caching it takes same time.

Could you please let me know what am I missing and what needs to be done.

Thanks

[manik]

Caching is not a silver bullet. You need to analyse your application and your data access patterns and make sure you are applying caching where it can and will help.

I have actually seen systems with so many layers of caching (DB, JDBC driver, ORM framework, application, front-end, etc etc) that removing a lot of the caching actually made things a lot faster.

Especially with an ORM framework/JPA, you should look at the access patterns of your data. Caching may help overall performance with some entities, and not at all with others.

[genman]

I have found it's really hard to see if you are actually using the cache. I see this in your config:

 <property name="hibernate.cache.use_second_level_cache" value="false"/>

Which doesn't seem right. Try turning on debugging in hibernate and JBoss cache and see what's going on.

[jimball]

I'm pretty sure you need to turn the second level cache on to access the JBoss cache

[jimball]

So at the very least



needs to be

[jimball]

Apologies, as genman said. Turn the attribute value to true

HTH