[jboss-user] [JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem

[niuxuetao_fiserv]

The 2nd problem I have occurs when running with multiple threads. This is a runtime exception being thrown, not a log message. (besides the 1-thread problem still arises in multiple thread environment)

This problem appears differently in JSE environment (where only DummyTransactionManager is used), and in Websphere6.1.

The exception stack in JSE environment was pasted on the 1st floor of this thread. The stack trace of running in Websphere6.1 is pasted below:

  | Caused by: org.jboss.cache.pojo.PojoCacheException: init org.jboss.cache.config.Configuration at f7de972e failed
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.<init>(PojoCacheImpl.java:75)
  | 	at org.jboss.cache.pojo.PojoCacheFactory.createCache(PojoCacheFactory.java:54)
  | 	at com.fiserv.detection.eventcache.jboss.JBossPojoCacheStorage.<init>(JBossPojoCacheStorage.java:26)
  | 	at com.fiserv.detection.eventcache.jboss.JBossPojoCacheStorageFactory.getCacheStorage(JBossPojoCacheStorageFactory.java:100)
  | 	at com.fiserv.detection.eventcache.statemachine.CacheAccessorFactory.createAccessor(CacheAccessorFactory.java:38)
  | 	at com.fiserv.detection.eventcache.api.EventCacheService.createCacheAccessor(EventCacheService.java:62)
  | 	at com.fiserv.detection.patternmatching.PatternMatching.init(PatternMatching.java:99)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  | 	at java.lang.reflect.Method.invoke(Method.java:618)
  | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1414)
  | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1375)
  | 	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1335)
  | 	... 88 more
  | Caused by: org.jboss.cache.CacheException: java.lang.reflect.InvocationTargetException
  | 	at org.jboss.cache.util.reflect.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:148)
  | 	at org.jboss.cache.factories.ComponentRegistry$PrioritizedMethod.invoke(ComponentRegistry.java:970)
  | 	at org.jboss.cache.factories.ComponentRegistry.internalStart(ComponentRegistry.java:746)
  | 	at org.jboss.cache.factories.ComponentRegistry.start(ComponentRegistry.java:610)
  | 	at org.jboss.cache.invocation.CacheInvocationDelegate.start(CacheInvocationDelegate.java:355)
  | 	at org.jboss.cache.DefaultCacheFactory.createCache(DefaultCacheFactory.java:121)
  | 	at org.jboss.cache.pojo.impl.PojoCacheImpl.<init>(PojoCacheImpl.java:71)
  | 	... 101 more
  | Caused by: java.lang.reflect.InvocationTargetException
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  | 	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  | 	at java.lang.reflect.Method.invoke(Method.java:618)
  | 	at org.jboss.cache.util.reflect.ReflectionUtil.invokeAccessibly(ReflectionUtil.java:144)
  | 	... 107 more
  | Caused by: org.jboss.cache.CacheException: Unable to start cache loaders
  | 	at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:467)
  | 	... 112 more
  | Caused by: java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session
  | 
  | 	at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
  | 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
  | 	at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
  | 	at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
  | 	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
  | 	at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
  | 	at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
  | 	at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
  | 	at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3390)
  | 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecute(WSJdbcPreparedStatement.java:735)
  | 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.execute(WSJdbcPreparedStatement.java:503)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.createDummyTableIfNeeded(AdjListJDBCCacheLoader.java:296)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.start(AdjListJDBCCacheLoader.java:269)
  | 	at org.jboss.cache.loader.JDBCCacheLoader.start(JDBCCacheLoader.java:376)
  | 	at org.jboss.cache.loader.CacheLoaderManager.startCacheLoader(CacheLoaderManager.java:461)
  | 	... 112 more
  | 

I checked the Javadoc of GenericTransactionManagerLookup class, it does not say Websphere6.1 is supported, could this be the problem? I will try to run it on Glassfish2 to see what happens.

Xuetao

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

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