[jboss-user] [JBoss Cache: Core Edition] - JDBC Cache Loader always loads from DB

[karnivas]

I'm using JBoss Cache 1.4.1 SP8 and JGroups 2.4.1 SP4

I've configured my cache with JDBC Cacheloader and I see that for each request the cache is loading from the DB inspite of the data residing in the cache.

At what circumstances this might happen. The configuration i've used is 


  | <?xml version="1.0" encoding="UTF-8"?>
  | 
  | <server>
  | 
  |     <classpath codebase="./lib" archives="jboss-cache.jar, jgroups.jar"/>
  | 
  |     <mbean code="org.jboss.cache.TreeCache"
  |         name="jboss.cache:service=TreeCache">
  | 
  |         <depends>jboss:service=Naming</depends>
  |         <depends>jboss:service=TransactionManager</depends>
  | 
  |          <attribute name="NodeLockingScheme">PESSIMISTIC</attribute>
  | 
  |         <attribute name="IsolationLevel">READ_COMMITTED</attribute>
  | 
  |         <attribute name="CacheMode">REPL_SYNC</attribute>
  | 
  |         <attribute name="UseInterceptorMbeans">true</attribute>
  | 
  |         <attribute name="UseReplQueue">false</attribute>
  | 
  | 		<attribute name="ReplQueueInterval">0</attribute>
  | 
  | 		<attribute name="ReplQueueMaxElements">0</attribute>
  | 
  |         <attribute name="ClusterName">Cache-LABS</attribute>
  | 	
  | 		<attribute name="FetchInMemoryState">true</attribute>
  | 
  | 		<attribute name="ClusterConfig">
  | 			<config>
  | 				<UDP mcast_addr="224.40.50.60" mcast_port="49977"
  | 					ip_ttl="64" ip_mcast="true"
  | 					mcast_send_buf_size="150000" mcast_recv_buf_size="200000"
  | 					ucast_send_buf_size="150000" ucast_recv_buf_size="200000"
  | 					loopback="false" bind_addr="114.94.99.351"/>
  | 				<PING timeout="2000" num_initial_members="3"
  | 					up_thread="false" down_thread="false"/>
  | 				<MERGE2 min_interval="10000" max_interval="20000"/>
  | 				<FD shun="true" up_thread="true" down_thread="true" />
  | 				<FD_SOCK/>
  | 				<VERIFY_SUSPECT timeout="1500"
  | 					up_thread="false" down_thread="false"/>
  | 				<pbcast.NAKACK gc_lag="50" retransmit_timeout="600,1200,2400,4800"
  | 					max_xmit_size="8192" up_thread="false" down_thread="false" discard_delivered_msgs="true"/>
  | 				<UNICAST timeout="600,1200,2400" window_size="100" min_threshold="10"
  | 					down_thread="false"/>
  | 				<pbcast.STABLE desired_avg_gossip="20000"
  | 					up_thread="false" down_thread="false"/>
  | 				<FRAG frag_size="8192"
  | 					down_thread="false" up_thread="false"/>
  | 				<pbcast.GMS join_timeout="5000" join_retry_timeout="2000"
  | 					shun="true" print_local_addr="true"/>
  | 				<pbcast.STATE_TRANSFER up_thread="true" down_thread="true"/>
  | 			</config>
  | 		</attribute>
  | 
  | 		<attribute name="SyncReplTimeout">150000</attribute>
  | 
  | 		<attribute name="LockAcquisitionTimeout">120000</attribute>
  | 
  | 		 <attribute name="CacheLoaderConfiguration">
  | 			 <config>
  | 				 <passivation>false</passivation>
  | 				 <preload>/</preload>
  | 				 <shared>true</shared>
  | 				 <cacheloader>
  | 					<class>org.jboss.cache.loader.JDBCCacheLoader</class>
  | 					<properties>
  | 						cache.jdbc.table.name=DBCACHE
  | 						cache.jdbc.table.create=false
  | 						cache.jdbc.table.drop=false
  | 						cache.jdbc.table.primarykey=jbosscache_pk
  | 						cache.jdbc.fqn.column=fqn
  | 						cache.jdbc.fqn.type=varchar(255)
  | 						cache.jdbc.node.column=node
  | 						cache.jdbc.node.type=blob
  | 						cache.jdbc.parent.column=parent
  | 						cache.jdbc.datasource=jdbc/basic
  | 						cache.async.batchSize=10000
  | 						cache.async.pollWait=100
  | 						cache.async.returnOld=true
  | 						cache.async.queueSize=100
  | 						cache.async.put=true
  | 					</properties>
  | 					<async>false</async>
  | 					<fetchPersistentState>true</fetchPersistentState>
  | 					<ignoreModifications>false</ignoreModifications>
  | 					<purgeOnStartup>false</purgeOnStartup>
  | 				 </cacheloader>
  | 			 </config>
  | 		</attribute>
  | 
  | 		<attribute name="EvictionPolicyClass"></attribute>
  | 
  |     </mbean>
  | 
  | </server>
  | 


The log messages from jboss are as 

org.jboss.cache.loader.JDBCCacheLoader --> executing sql: select node from DBCACHE where fqn=?

Please suggest your thoughts on this.

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

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