[jboss-user] [JBossCache] - Re: Query cache and long query strings

[klaus_erber]

Ok sorry, I forgot some informations about the environment:

JBoss-4.0.5.GA ejb3-install (ejb3, Hibernate-3.2.0.GA, JBossCache 1.4.0.SP1)

The persisitence unit:

  | <persistence>
  | 
  | 	<persistence-unit name="pistats">
  | 		<jta-data-source>java:/pistats-ds</jta-data-source>
  | 		<properties>
  | 			<property name="hibernate.dialect"
  | 				value="org.hibernate.dialect.DerbyDialect" />
  | 			<property name="hibernate.hbm2ddl.auto" value="none" />
  | 			<property name="hibernate.generate_statistics" value="true" />
  | 			<property name="hibernate.cache.use_structured_entries" value="false" />
  | 			<property name="hibernate.cache.provider_class" value="org.jboss.ejb3.entity.TreeCacheProviderHook"/>
  | 			
  | 			<property name="hibernate.treecache.mbean.object_name" value="pistats.db:service=StockEntityCache"/>
  | 			<property name="hibernate.cache.use_query_cache" value="true"/>			
  | 		</properties>
  | 
  | 	</persistence-unit>
  | 		
  | </persistence>
  | 

Cache config:


  | 	<mbean code="org.jboss.cache.TreeCache"
  | 		name="pistats.db:service=StockEntityCache">
  | 		<depends>jboss:service=Naming</depends>
  | 		<depends>jboss:service=TransactionManager</depends>
  | 
  | 		<attribute name="TransactionManagerLookupClass">
  | 			org.jboss.cache.JBossTransactionManagerLookup
  | 		</attribute>
  | 
  | 		<attribute name="IsolationLevel">REPEATABLE_READ</attribute>
  | 
  | 		<attribute name="NodeLockingScheme">PESSIMISTIC</attribute>
  | 
  | 		<attribute name="CacheMode">LOCAL</attribute>
  | 		
  | 		<attribute name="LockAcquisitionTimeout">30000</attribute>
  | 
  | 		<attribute name="EvictionPolicyClass">
  | 			org.jboss.cache.eviction.LRUPolicy
  | 		</attribute>
  | 		
  | 		<attribute name="EvictionPolicyConfig">
  | 			<config>
  | 				<attribute name="wakeUpIntervalSeconds">5</attribute>
  | 				<region name="/_default_"
  | 					policyClass="org.jboss.cache.eviction.LRUPolicy">
  | 					<attribute name="maxNodes">1000</attribute>
  | 					<attribute name="timeToLiveSeconds">1800</attribute>
  | 					<attribute name="maxAgeSeconds">3600</attribute>
  | 				</region>
  | 				<region name="/stockdata"
  | 					policyClass="org.jboss.cache.eviction.LRUPolicy">
  | 					<attribute name="maxNodes">10000</attribute>
  | 					<attribute name="timeToLiveSeconds">3600</attribute>
  | 					<attribute name="maxAgeSeconds">3600</attribute>
  | 				</region>
  | 			</config>
  | 		</attribute>
  | 
  | 	</mbean>
  | 

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

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