[jboss-user] [JBoss Cache: Core Edition] - Re: starting JDBCCacheLoader and transactions

vl_sadovnikov do-not-reply at jboss.com
Thu Jul 9 10:59:47 EDT 2009


The reported issue with COMMIT was due to a problem in our code: we've been creating multiple instances of PojoCacheFactory.createCache(config, true), giving the same configuration. Now only one PojoCacheFactory is created.

However, when server commits its processing transaction, TxInterceptor logs an exception, but does not roll-back the transaction. 

Would you think something is wrong on our side?


  | [2009-07-09 16:42:51,959] [Default : 18] ERROR JDBCCacheLoader - Failed to insert node :ORA-01461: can bind a LONG value only for insert into a LONG column
  | 
  | [2009-07-09 16:42:51,959] [Default : 18] WARN  TxInterceptor - Caught exception, will now set transaction to roll back
  | java.lang.IllegalStateException: Failed to insert node: ORA-01461: can bind a LONG value only for insert into a LONG column
  | 
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:514)
  | 	at org.jboss.cache.loader.JDBCCacheLoader.addNewSubtree(JDBCCacheLoader.java:345)
  | 	at org.jboss.cache.loader.JDBCCacheLoader.put(JDBCCacheLoader.java:147)
  | 	at org.jboss.cache.loader.AbstractCacheLoader.put(AbstractCacheLoader.java:294)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.prepare(AdjListJDBCCacheLoader.java:211)
  | 	at org.jboss.cache.interceptors.CacheStoreInterceptor.prepareCacheLoader(CacheStoreInterceptor.java:386)
  | 	at org.jboss.cache.interceptors.CacheStoreInterceptor.handlePrepareCommand(CacheStoreInterceptor.java:214)
  | 	at org.jboss.cache.interceptors.base.SkipCheckChainedInterceptor.visitPrepareCommand(SkipCheckChainedInterceptor.java:310)
  | 	at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
  | 	at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
  | 	at org.jboss.cache.interceptors.MVCCLockingInterceptor.handlePrepareCommand(MVCCLockingInterceptor.java:320)
  | 	at org.jboss.cache.interceptors.base.PrePostProcessingCommandInterceptor.visitPrepareCommand(PrePostProcessingCommandInterceptor.java:383)
  | 	at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
  | 	at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
  | 	at org.jboss.cache.interceptors.base.CommandInterceptor.handleDefault(CommandInterceptor.java:131)
  | 	at org.jboss.cache.commands.AbstractVisitor.visitPrepareCommand(AbstractVisitor.java:140)
  | 	at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
  | 	at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
  | 	at org.jboss.cache.interceptors.NotificationInterceptor.visitPrepareCommand(NotificationInterceptor.java:50)
  | 	at org.jboss.cache.commands.tx.PrepareCommand.acceptVisitor(PrepareCommand.java:68)
  | 	at org.jboss.cache.interceptors.base.CommandInterceptor.invokeNextInterceptor(CommandInterceptor.java:116)
  | 	at org.jboss.cache.interceptors.TxInterceptor.runPreparePhase(TxInterceptor.java:638)
  | 	at org.jboss.cache.interceptors.TxInterceptor$LocalSynchronizationHandler.beforeCompletion(TxInterceptor.java:1041)
  | 	at org.jboss.cache.interceptors.OrderedSynchronizationHandler.beforeCompletion(OrderedSynchronizationHandler.java:81)
  | 	at com.ibm.ws.Transaction.JTA.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:242)
  | 	at com.ibm.ws.Transaction.JTA.TransactionImpl.prePrepare(TransactionImpl.java:2399)
  | 	at com.ibm.ws.Transaction.JTA.TransactionImpl.stage1CommitProcessing(TransactionImpl.java:1632)
  | 	at com.ibm.ws.Transaction.JTA.TransactionImpl.processCommit(TransactionImpl.java:1603)
  | 	at com.ibm.ws.Transaction.JTA.TransactionImpl.commit(TransactionImpl.java:1538)
  | 	at com.ibm.ws.Transaction.JTA.TranManagerImpl.commit(TranManagerImpl.java:239)
  | 	at com.ibm.ws.Transaction.JTA.TranManagerSet.commit(TranManagerSet.java:163)
  | 	at com.ibm.ejs.csi.TranStrategy.commit(TranStrategy.java:782)
  | 	at com.ibm.ejs.csi.TranStrategy.postInvoke(TranStrategy.java:206)
  | 	at com.ibm.ejs.csi.RequiresNew.postInvoke(RequiresNew.java:93)
  | 	at com.ibm.ejs.csi.TransactionControlImpl.postInvoke(TransactionControlImpl.java:581)
  | 	at com.ibm.ejs.container.EJSContainer.postInvoke(EJSContainer.java:4210)
  | 	at com.fiserv.util.jee.beans.EJSLocal0SLDetectionPipelineBean_c78bfd96.processEvent(EJSLocal0SLDetectionPipelineBean_c78bfd96.java)
  | 	at com.fiserv.nextgen.detectionpipeline.DetectionProcessingMDB.onMessage(DetectionProcessingMDB.java:72)
  | 	at sun.reflect.GeneratedMethodAccessor165.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  | 	at java.lang.reflect.Method.invoke(Method.java:618)
  | 	at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:547)
  | 	at com.fiserv.util.jee.interceptors.ErrorHandlerMDB.checkError(ErrorHandlerMDB.java:45)
  | 	at sun.reflect.GeneratedMethodAccessor147.invoke(Unknown Source)
  | 	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  | 	at java.lang.reflect.Method.invoke(Method.java:618)
  | 	at com.ibm.ejs.container.interceptors.InterceptorProxy.invokeInterceptor(InterceptorProxy.java:227)
  | 	at com.ibm.ejs.container.interceptors.InvocationContextImpl.proceed(InvocationContextImpl.java:526)
  | 	at com.ibm.ejs.container.interceptors.InvocationContextImpl.doAroundInvoke(InvocationContextImpl.java:184)
  | 	at com.ibm.ejs.container.MessageEndpointHandler.invokeMdbMethod(MessageEndpointHandler.java:1073)
  | 	at com.ibm.ejs.container.MessageEndpointHandler.invoke(MessageEndpointHandler.java:773)
  | 	at $Proxy44.onMessage(Unknown Source)
  | 	at com.ibm.ws.sib.api.jmsra.impl.JmsJcaEndpointInvokerImpl.invokeEndpoint(JmsJcaEndpointInvokerImpl.java:201)
  | 	at com.ibm.ws.sib.ra.inbound.impl.SibRaDispatcher.dispatch(SibRaDispatcher.java:768)
  | 	at com.ibm.ws.sib.ra.inbound.impl.SibRaSingleProcessListener$SibRaWork.run(SibRaSingleProcessListener.java:584)
  | 	at com.ibm.ejs.j2c.work.WorkProxy.run(WorkProxy.java:419)
  | 	at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:1469)
  | Caused by: java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
  | 
  | 	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.executeUpdate(OraclePreparedStatement.java:3368)
  | 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteUpdate(WSJdbcPreparedStatement.java:948)
  | 	at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeUpdate(WSJdbcPreparedStatement.java:615)
  | 	at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:501)
  | 	... 56 more
  | 

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

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



More information about the jboss-user mailing list