[JNDI/Naming/Network] - Re: Getting DB connection from jboss pool via JNDI
by PeterJ
anonymous wrote : Is a Tomcat that runs on the same physical machine but in another process than JBoss a 'remote' client?
Yes. Any Java app that runs in another java process (not the java process running JBoss AS) is a remote client. And app that runs within the same java process as JBoss AS is considered to be a local client.
anonymous wrote : how do you go about letting also JSP's and JSP Beans used in Tomcat profit from the JBoss connection pooling WITHOUT using the Antipattern of putting db resources in the global JNDI namespace
You can't. I'm not exactly sure of why this was declared an anti-pattern, but I think it has more to do with the remote access to the datasource than to placing the datasource's name in the global JNDI area. Thus, even with the datasource name in global JNDI, any local access to the datasource is not exhibiting the anti-pattern.
anonymous wrote : Is the only alternative to run the tomcat instance embedded in jboss?
There is already a Tomcat instance embedded within JBoss AS. Though since 4.2.0 it is called JBoss Web which is based on Tomcat.
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241533#4241533
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241533
16 years, 9 months
[JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem
by 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@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
16 years, 9 months
[JBoss Cache: Core Edition] - Re: JDBCCacheLoader with Oracle 10g problem
by niuxuetao_fiserv
Hi Mircea,
Thanks for the response.
Do you mean the version I am using does not work for Oracle?
I actually have two problems:
1. Running with 1 thread, as pasted above, there are 3 exception traces logged by JBossCache at both WARN and ERROR level, they are not thrown by JbossCache as runtime exception. But these logs contain the exception stack trace which seems internally handled by JbossCache, but I am not sure what JbossCache does except for logging only.
These log messages happen a short while after I put something into pojo cache, and not to each put I do.
These messages are related to transactions. They are pasted below:
|
| [2009-07-02 16:57:21,067] [Detection1] ERROR JDBCCacheLoader - Failed to insert node :ORA-01461: can bind a LONG value only for insert into a LONG column
|
| [2009-07-02 16:57:21,067] [Detection1] 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 org.jboss.cache.transaction.DummyTransaction.notifyBeforeCompletion(DummyTransaction.java:284)
| at org.jboss.cache.transaction.DummyTransaction.commit(DummyTransaction.java:84)
| at org.jboss.cache.transaction.DummyBaseTransactionManager.commit(DummyBaseTransactionManager.java:99)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.endTransaction(PojoCacheImpl.java:152)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:116)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:93)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:88)
| at com.fiserv.detection.eventcache.jboss.JBossPojoCacheStorage.update(JBossPojoCacheStorage.java:50)
| at com.fiserv.detection.eventcache.statemachine.CacheAccessor.save(CacheAccessor.java:121)
| at com.fiserv.detection.eventcache.statemachine.CacheAccessor.matchAll(CacheAccessor.java:62)
| at com.fiserv.detection.patternmatching.PatternMatching.doDetection(PatternMatching.java:44)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.invoke(DetectionTaskInvoker.java:200)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.invoke(DetectionTaskInvoker.java:108)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.onEvent(DetectionTaskInvoker.java:119)
| at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.springframework.integration.util.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:89)
| at org.springframework.integration.handler.MessageMappingMethodInvoker.doInvokeMethod(MessageMappingMethodInvoker.java:127)
| at org.springframework.integration.handler.MessageMappingMethodInvoker.invokeMethod(MessageMappingMethodInvoker.java:100)
| at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:49)
| at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:90)
| at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:48)
| at org.springframework.integration.dispatcher.AbstractDispatcher.sendMessageToHandler(AbstractDispatcher.java:75)
| at org.springframework.integration.dispatcher.SimpleDispatcher.dispatch(SimpleDispatcher.java:45)
| at org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:56)
| at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:116)
| at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:94)
| at org.springframework.integration.channel.MessageChannelTemplate.doSend(MessageChannelTemplate.java:222)
| at org.springframework.integration.channel.MessageChannelTemplate.send(MessageChannelTemplate.java:179)
| at org.springframework.integration.gateway.AbstractMessagingGateway.send(AbstractMessagingGateway.java:128)
| at org.springframework.integration.gateway.GatewayProxyFactoryBean.invokeGatewayMethod(GatewayProxyFactoryBean.java:206)
| at org.springframework.integration.gateway.GatewayProxyFactoryBean.invoke(GatewayProxyFactoryBean.java:172)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
| at $Proxy48.processEvent(Unknown Source)
| at com.fiserv.esp.DetectionPipelineProcessor.processEvent(DetectionPipelineProcessor.java:107)
| at com.fiserv.tools.xcontainer.service.XEventProcessingTask.attempt(XEventProcessingTask.java:104)
| at com.fiserv.tools.xcontainer.service.XEventProcessingTask.run(XEventProcessingTask.java:67)
| at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
| at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
| at java.lang.Thread.run(Thread.java:595)
| 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.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
| at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:501)
| ... 69 more
|
And
| [2009-07-02 16:57:21,067] [Detection1] ERROR DummyTransaction - beforeCompletion() failed for tx=org.jboss.cache.transaction.DummyTransaction@289999, handlers=[TxInterceptor.LocalSynchronizationHandler(gtx=GlobalTransaction:<null>:31, tx=org.jboss.cache.transaction.DummyTransaction@289999)]
| 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 org.jboss.cache.transaction.DummyTransaction.notifyBeforeCompletion(DummyTransaction.java:284)
| at org.jboss.cache.transaction.DummyTransaction.commit(DummyTransaction.java:84)
| at org.jboss.cache.transaction.DummyBaseTransactionManager.commit(DummyBaseTransactionManager.java:99)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.endTransaction(PojoCacheImpl.java:152)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:116)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:93)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:88)
| at com.fiserv.detection.eventcache.jboss.JBossPojoCacheStorage.update(JBossPojoCacheStorage.java:50)
| at com.fiserv.detection.eventcache.statemachine.CacheAccessor.save(CacheAccessor.java:121)
| at com.fiserv.detection.eventcache.statemachine.CacheAccessor.matchAll(CacheAccessor.java:62)
| at com.fiserv.detection.patternmatching.PatternMatching.doDetection(PatternMatching.java:44)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.invoke(DetectionTaskInvoker.java:200)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.invoke(DetectionTaskInvoker.java:108)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.onEvent(DetectionTaskInvoker.java:119)
| at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.springframework.integration.util.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:89)
| at org.springframework.integration.handler.MessageMappingMethodInvoker.doInvokeMethod(MessageMappingMethodInvoker.java:127)
| at org.springframework.integration.handler.MessageMappingMethodInvoker.invokeMethod(MessageMappingMethodInvoker.java:100)
| at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:49)
| at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:90)
| at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:48)
| at org.springframework.integration.dispatcher.AbstractDispatcher.sendMessageToHandler(AbstractDispatcher.java:75)
| at org.springframework.integration.dispatcher.SimpleDispatcher.dispatch(SimpleDispatcher.java:45)
| at org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:56)
| at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:116)
| at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:94)
| at org.springframework.integration.channel.MessageChannelTemplate.doSend(MessageChannelTemplate.java:222)
| at org.springframework.integration.channel.MessageChannelTemplate.send(MessageChannelTemplate.java:179)
| at org.springframework.integration.gateway.AbstractMessagingGateway.send(AbstractMessagingGateway.java:128)
| at org.springframework.integration.gateway.GatewayProxyFactoryBean.invokeGatewayMethod(GatewayProxyFactoryBean.java:206)
| at org.springframework.integration.gateway.GatewayProxyFactoryBean.invoke(GatewayProxyFactoryBean.java:172)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
| at $Proxy48.processEvent(Unknown Source)
| at com.fiserv.esp.DetectionPipelineProcessor.processEvent(DetectionPipelineProcessor.java:107)
| at com.fiserv.tools.xcontainer.service.XEventProcessingTask.attempt(XEventProcessingTask.java:104)
| at com.fiserv.tools.xcontainer.service.XEventProcessingTask.run(XEventProcessingTask.java:67)
| at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
| at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
| at java.lang.Thread.run(Thread.java:595)
| 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.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
| at org.jboss.cache.loader.AdjListJDBCCacheLoader.insertNode(AdjListJDBCCacheLoader.java:501)
| ... 69 more
|
And
| [2009-07-02 16:57:21,083] [Detection1] WARN PojoCacheImpl - Could not end transaction for operation on: /RTDE/pattern-matching-threshold/663330655
| javax.transaction.RollbackException: outcome is false status: 1
| at org.jboss.cache.transaction.DummyTransaction.commit(DummyTransaction.java:98)
| at org.jboss.cache.transaction.DummyBaseTransactionManager.commit(DummyBaseTransactionManager.java:99)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.endTransaction(PojoCacheImpl.java:152)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:116)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:93)
| at org.jboss.cache.pojo.impl.PojoCacheImpl.attach(PojoCacheImpl.java:88)
| at com.fiserv.detection.eventcache.jboss.JBossPojoCacheStorage.update(JBossPojoCacheStorage.java:50)
| at com.fiserv.detection.eventcache.statemachine.CacheAccessor.save(CacheAccessor.java:121)
| at com.fiserv.detection.eventcache.statemachine.CacheAccessor.matchAll(CacheAccessor.java:62)
| at com.fiserv.detection.patternmatching.PatternMatching.doDetection(PatternMatching.java:44)
| at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
| at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.invoke(DetectionTaskInvoker.java:200)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.invoke(DetectionTaskInvoker.java:108)
| at com.fiserv.detection.pipeline.DetectionTaskInvoker.onEvent(DetectionTaskInvoker.java:119)
| at sun.reflect.GeneratedMethodAccessor79.invoke(Unknown Source)
| at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
| at java.lang.reflect.Method.invoke(Method.java:585)
| at org.springframework.integration.util.DefaultMethodInvoker.invokeMethod(DefaultMethodInvoker.java:89)
| at org.springframework.integration.handler.MessageMappingMethodInvoker.doInvokeMethod(MessageMappingMethodInvoker.java:127)
| at org.springframework.integration.handler.MessageMappingMethodInvoker.invokeMethod(MessageMappingMethodInvoker.java:100)
| at org.springframework.integration.handler.ServiceActivatingHandler.handleRequestMessage(ServiceActivatingHandler.java:49)
| at org.springframework.integration.handler.AbstractReplyProducingMessageHandler.handleMessageInternal(AbstractReplyProducingMessageHandler.java:90)
| at org.springframework.integration.handler.AbstractMessageHandler.handleMessage(AbstractMessageHandler.java:48)
| at org.springframework.integration.dispatcher.AbstractDispatcher.sendMessageToHandler(AbstractDispatcher.java:75)
| at org.springframework.integration.dispatcher.SimpleDispatcher.dispatch(SimpleDispatcher.java:45)
| at org.springframework.integration.channel.AbstractSubscribableChannel.doSend(AbstractSubscribableChannel.java:56)
| at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:116)
| at org.springframework.integration.channel.AbstractMessageChannel.send(AbstractMessageChannel.java:94)
| at org.springframework.integration.channel.MessageChannelTemplate.doSend(MessageChannelTemplate.java:222)
| at org.springframework.integration.channel.MessageChannelTemplate.send(MessageChannelTemplate.java:179)
| at org.springframework.integration.gateway.AbstractMessagingGateway.send(AbstractMessagingGateway.java:128)
| at org.springframework.integration.gateway.GatewayProxyFactoryBean.invokeGatewayMethod(GatewayProxyFactoryBean.java:206)
| at org.springframework.integration.gateway.GatewayProxyFactoryBean.invoke(GatewayProxyFactoryBean.java:172)
| at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
| at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
| at $Proxy48.processEvent(Unknown Source)
| at com.fiserv.esp.DetectionPipelineProcessor.processEvent(DetectionPipelineProcessor.java:107)
| at com.fiserv.tools.xcontainer.service.XEventProcessingTask.attempt(XEventProcessingTask.java:104)
| at com.fiserv.tools.xcontainer.service.XEventProcessingTask.run(XEventProcessingTask.java:67)
| at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:650)
| at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:675)
| at java.lang.Thread.run(Thread.java:595)
|
And the insert debug log right before this is:
| [2009-07-02 16:57:21,067] [Detection1] DEBUG JDBCCacheLoader - executing sql: INSERT INTO Cached_Events (fqn, node, parent) SELECT ?, ?, ? FROM Cached_Events_D WHERE NOT EXISTS (SELECT fqn FROM Cached_Events WHERE fqn = ?) (/__JBossInternal__/RTDE/pattern-matching-threshold/663330655/_ID_/aaaa-w80875-fwnlokgc-1-fwnloo17-w)
|
View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=4241518#4241518
Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=4241518
16 years, 9 months