Hi,
we am using the JDBCCacheLoader for my cache.(Jboss cache version used
is 1.4.1.SP8) CacheLoader Configuration for my cache is as follows,
org.jboss.cache.loader.JDBCCacheLoader
cache.jdbc.table.name=MyCache
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.driver=oracle.jdbc.OracleDriver
cache.jdbc.url=jdbc:oracle:thin:@myhost:1521:SID
cache.jdbc.user=myusr
cache.jdbc.password=myusrpwd
cache.async.batchSize=10000
cache.async.pollWait=100
cache.async.returnOld=true
cache.async.queueSize=100
cache.async.put=true
It is working fine as long as Database is up and running continously.
When database goes down in middle, i am getting "IllegalStateException: Failed
to load node : Closed Exception" from JDBCCacheLoader. This is fine. But when
the Database comes up again and running properly, still getting the same error
from JDBCCacheLoader.
org.jboss.cache.loader.JDBCCacheLoader --> Failed to load node for fqn
/MyNode: Closed Connection
java.sql.SQLException: Closed Connection
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:153)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:201)
at
oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:306)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:1009)
at
oracle.jdbc.driver.PhysicalConnection.prepareStatement(PhysicalConnection.java:915)
at
org.jboss.cache.loader.JDBCCacheLoader.loadNode(JDBCCacheLoader.java:1121)
at
org.jboss.cache.loader.JDBCCacheLoader.get(JDBCCacheLoader.java:269)
at
org.jboss.cache.loader.AsyncCacheLoader.get(AsyncCacheLoader.java:171)
at
org.jboss.cache.interceptors.CacheLoaderInterceptor.loadData(CacheLoaderInterceptor.java:452)
at
org.jboss.cache.interceptors.CacheLoaderInterceptor.loadNode(CacheLoaderInterceptor.java:362)
at
org.jboss.cache.interceptors.CacheLoaderInterceptor.invoke(CacheLoaderInterceptor.java:197)
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.ReplicationInterceptor.invoke(ReplicationInterceptor.java:39)
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:183)
at org.jboss.cache.TreeCache.invokeMethod(TreeCache.java:5917)
at org.jboss.cache.TreeCache.get(TreeCache.java:3550)
The connection is not re-established eventhough database became up. It
is using the same connection which is closed already when the Database gone
down.
Does anybody have idea? Is this problem fixed in any subsequent
version?.
Thanks in advance.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4187607#4187607
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4187607
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
