[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