JDBCCacheLoader Problem

[indiavitus]

Hi,

I am using jboss cache with hibernate. While reading from cache sometime following exception is thrown.

java.lang.IllegalStateException: Failed to load node for fqn /fare/DEL/NAG/09-11-08: Interrupted while requesting permit! Waited 0 ms; - nested throwable: (javax.resource.ResourceException: Interrupted while requesting permit! Waited 0 ms)
at org.jboss.cache.loader.JDBCCacheLoader.loadNode(JDBCCacheLoader.java:1121)
at org.jboss.cache.loader.JDBCCacheLoader.get(JDBCCacheLoader.java:263)
at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadData(CacheLoaderInterceptor.java:443)
at org.jboss.cache.interceptors.CacheLoaderInterceptor.loadNode(CacheLoaderInterceptor.java:353)
at org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:180)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:68)
at org.jboss.cache.interceptors.UnlockInterceptor.invoke(UnlockInterceptor.java:32)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:68)
at org.jboss.cache.interceptors.TxInterceptor.handleNonTxMethod(TxInterceptor.java:365)
at org.jboss.cache.interceptors.TxInterceptor.invoke(TxInterceptor.java:160)
at org.jboss.cache.interceptors.Interceptor.invoke(Interceptor.java:68)
at org.jboss.cache.interceptors.CacheMgmtInterceptor.invoke(CacheMgmtInterceptor.java:138)
at org.jboss.cache.TreeCache.invokeMethod(TreeCache.java:5863)
at org.jboss.cache.TreeCache.get(TreeCache.java:3627)
at org.jboss.cache.TreeCache.get(TreeCache.java:3608)
at com.tg.cache.manager.FareCacheProviderImpl.getFromCache(FareCacheProviderImpl.java:170)
at com.tg.ws.abacus.AbacusFareService.getResponseFromCache(AbacusFareService.java:765)
at com.tg.ws.abacus.AbacusFareService.responseExistInCache(AbacusFareService.java:891)
at com.tg.ws.abacus.AbacusFareService_1_5.getFaresFromCacheOrWSForRequest(AbacusFareService_1_5.java:222)
at com.tg.ws.abacus.FarePoolHandler.execute(FarePoolHandler.java:29)
at com.tg.ws.abacus.FarePoolHandler.execute(FarePoolHandler.java:15)
at com.tg.parallel.concurrent.JavaConcurrentPoolExecutor$CallableAdapter.call(JavaConcurrentPoolExecutor.java:93)
at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
at java.util.concurrent.FutureTask.run(FutureTask.java:138)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:885)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:907)
at java.lang.Thread.run(Thread.java:619)


Please let me know the work around for this.

Regard,
- Manoj

[manik]

Why would you use a JDBC cache loader when using JBC as a 2nd level cache in Hibernate? Storing stuff in a DB twice over is pretty wasteful, IMO.

[indiavitus]

sorry to putting wrong word in last post. jboss caching is not used with Hibernate. simple JDBC is used for jboss caching.

Please let me know why i am getting this error.

Regard,
-Manoj

[manik]

Hang on, I'm confused - so you don't use Hibernate and you don't make direct JDBC calls, am I correct? You just want to use the JDBCCacheLoader?