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 _______________________________________________ jboss-user mailing list [email protected] https://lists.jboss.org/mailman/listinfo/jboss-user
