3 Replies Latest reply on Apr 19, 2006 10:22 AM by nm_pereira

Messaging on Oracle

nm_pereira Apr 19, 2006 6:43 AM

Hi,

I am using Messaging 1.0 with JBoss 4.03SP1. I have configured Messaging to use Oracle Persistence (9.2.0.4.0) using th files found in FishEye (/jboss-jms/docs/examples/config/):

oracle-jdbcchannelmapper-service.xml

oracle-jdbcpersistencemanager-service.xml

This files will be included in Messaging 1.0.1.

I am having problems with this files after configuring Messaging i get this error (Invalid column index):

2006-04-19 12:26:28,475 ERROR [org.jboss.messaging.core.ChannelSupport] Failed to handle message
java.sql.SQLException: Indice di colonna non valido
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:208)
at oracle.jdbc.driver.OraclePreparedStatement.setIntInternal(OraclePreparedStatement.java:4571)
at oracle.jdbc.driver.OraclePreparedStatement.setInt(OraclePreparedStatement.java:4563)
at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.setInt(WrappedPreparedStatement.java:97)
at org.jboss.messaging.core.plugin.JDBCPersistenceManager.storeMessage(JDBCPersistenceManager.java:4066)
at org.jboss.messaging.core.plugin.JDBCPersistenceManager.addReference(JDBCPersistenceManager.java:1654)
at org.jboss.messaging.core.ChannelState.addReference(ChannelState.java:211)
at org.jboss.messaging.core.ChannelSupport.handle(ChannelSupport.java:129)
at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(ServerConnectionEndpoint.java:744)
at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessionEndpoint.java:366)
at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$
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:324)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
at org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspect.java:150)
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:324)
at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
at org.jboss.jms.server.container.ServerLogInterceptor.invoke(ServerLogInterceptor.java:105)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
at org.jboss.aop.Advisor.dynamicInvoke(Advisor.java:719)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:99)
at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:126)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:831)
at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:72)
at org.jboss.remoting.Client.invoke(Client.java:527)
at org.jboss.remoting.Client.invoke(Client.java:490)
at org.jboss.jms.client.delegate.DelegateSupport.invoke(DelegateSupport.java:112)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.TransactionAspect.handleSend(TransactionAspect.java:151)
at org.jboss.aop.advice.org.jboss.jms.client.container.TransactionAspect11.invoke(TransactionAspect11.java)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:130)
at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:69)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.delegate.ClientSessionDelegate.send(ClientSessionDelegate.java)
at org.jboss.jms.client.container.ProducerAspect.handleSend(ProducerAspect.java:238)
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:324)
at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:130)
at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:69)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.delegate.ClientProducerDelegate.send(ClientProducerDelegate.java)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:164)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:208)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:145)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:136)
at es.ftech.rti.caronte.utils.QueueClient.sendJMSCaronte(QueueClient.java:34)
at es.ftech.rti.caronte.Thread.UDPThread.run(UDPThread.java:119)
2006-04-19 12:26:28,477 ERROR [org.jboss.jms.server.endpoint.ServerConnectionEndpoint] The message was not acknowledged by
2006-04-19 12:26:28,478 ERROR [org.jboss.jms.client.container.ExceptionInterceptor] Linked exception is:
org.jboss.jms.util.MessagingJMSException: The message was not acknowledged by destination CoreQueue[20]
at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(ServerConnectionEndpoint.java:761)
at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessionEndpoint.java:366)
at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$
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:324)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
at org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspect.java:150)
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:324)
at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
at org.jboss.jms.server.container.ServerLogInterceptor.invoke(ServerLogInterceptor.java:105)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
at org.jboss.aop.Advisor.dynamicInvoke(Advisor.java:719)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:99)
at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:126)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:831)
at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:72)
at org.jboss.remoting.Client.invoke(Client.java:527)
at org.jboss.remoting.Client.invoke(Client.java:490)
at org.jboss.jms.client.delegate.DelegateSupport.invoke(DelegateSupport.java:112)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.TransactionAspect.handleSend(TransactionAspect.java:151)
at org.jboss.aop.advice.org.jboss.jms.client.container.TransactionAspect11.invoke(TransactionAspect11.java)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:130)
at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:69)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.delegate.ClientSessionDelegate.send(ClientSessionDelegate.java)
at org.jboss.jms.client.container.ProducerAspect.handleSend(ProducerAspect.java:238)
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:324)
at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:130)
at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:69)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.delegate.ClientProducerDelegate.send(ClientProducerDelegate.java)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:164)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:208)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:145)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:136)
at es.ftech.rti.caronte.utils.QueueClient.sendJMSCaronte(QueueClient.java:34)
at es.ftech.rti.caronte.Thread.UDPThread.run(UDPThread.java:119)
2006-04-19 12:26:28,480 ERROR [org.jboss.jms.client.container.ExceptionInterceptor] Linked exception is:
org.jboss.jms.util.MessagingJMSException: The message was not acknowledged by destination CoreQueue[20]
at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(ServerConnectionEndpoint.java:761)
at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessionEndpoint.java:366)
at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$
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:324)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
at org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspect.java:150)
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:324)
at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
at org.jboss.jms.server.container.ServerLogInterceptor.invoke(ServerLogInterceptor.java:105)
at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
at org.jboss.aop.Advisor.dynamicInvoke(Advisor.java:719)
at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:99)
at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvocationHandler.java:126)
at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:831)
at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker.java:72)
at org.jboss.remoting.Client.invoke(Client.java:527)
at org.jboss.remoting.Client.invoke(Client.java:490)
at org.jboss.jms.client.delegate.DelegateSupport.invoke(DelegateSupport.java:112)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.TransactionAspect.handleSend(TransactionAspect.java:151)
at org.jboss.aop.advice.org.jboss.jms.client.container.TransactionAspect11.invoke(TransactionAspect11.java)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:130)
at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:69)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.invokeNext(ClientSessionDelegate$
at org.jboss.jms.client.delegate.ClientSessionDelegate.send(ClientSessionDelegate.java)
at org.jboss.jms.client.container.ProducerAspect.handleSend(ProducerAspect.java:238)
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:324)
at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:130)
at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:117)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor.java:69)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor.java:107)
at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.invokeNext(ClientProducerDelegate
at org.jboss.jms.client.delegate.ClientProducerDelegate.send(ClientProducerDelegate.java)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:164)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:208)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:145)
at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:136)
at es.ftech.rti.caronte.utils.QueueClient.sendJMSCaronte(QueueClient.java:34)
at es.ftech.rti.caronte.Thread.UDPThread.run(UDPThread.java:119)
2006-04-19 12:26:28,481 INFO [STDOUT] org.jboss.jms.util.MessagingJMSException: Failed to send message
2006-04-19 12:26:28,482 INFO [STDOUT] at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage(ServerConnec
2006-04-19 12:26:28,482 INFO [STDOUT] at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send(ServerSessionEndpoint.
2006-04-19 12:26:28,482 INFO [STDOUT] at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpo
2006-04-19 12:26:28,482 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2006-04-19 12:26:28,482 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2006-04-19 12:26:28,482 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
2006-04-19 12:26:28,482 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
2006-04-19 12:26:28,483 INFO [STDOUT] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
2006-04-19 12:26:28,483 INFO [STDOUT] at org.jboss.jms.server.container.SecurityAspect.handleSend(SecurityAspect.java:15
2006-04-19 12:26:28,483 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2006-04-19 12:26:28,483 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2006-04-19 12:26:28,483 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
2006-04-19 12:26:28,483 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
2006-04-19 12:26:28,483 INFO [STDOUT] at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.jms.server.container.ServerLogInterceptor.invoke(ServerLogInterceptor
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.aop.Advisor.dynamicInvoke(Advisor.java:719)
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:99)
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke(JMSServerInvoca
2006-04-19 12:26:28,484 INFO [STDOUT] at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:831)
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.remoting.transport.local.LocalClientInvoker.invoke(LocalClientInvoker
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.remoting.Client.invoke(Client.java:527)
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.remoting.Client.invoke(Client.java:490)
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.jms.client.delegate.DelegateSupport.invoke(DelegateSupport.java:112)
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.i
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.jms.client.container.TransactionAspect.handleSend(TransactionAspect.j
2006-04-19 12:26:28,485 INFO [STDOUT] at org.jboss.aop.advice.org.jboss.jms.client.container.TransactionAspect11.invoke(
2006-04-19 12:26:28,486 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.i
2006-04-19 12:26:28,486 INFO [STDOUT] at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:
2006-04-19 12:26:28,486 INFO [STDOUT] at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:
2006-04-19 12:26:28,486 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.i
2006-04-19 12:26:28,486 INFO [STDOUT] at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor
2006-04-19 12:26:28,486 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.i
2006-04-19 12:26:28,487 INFO [STDOUT] at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor
2006-04-19 12:26:28,487 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientSessionDelegate$send_N3028277934545793941.i
2006-04-19 12:26:28,487 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientSessionDelegate.send(ClientSessionDelegate.
2006-04-19 12:26:28,487 INFO [STDOUT] at org.jboss.jms.client.container.ProducerAspect.handleSend(ProducerAspect.java:23
2006-04-19 12:26:28,487 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
2006-04-19 12:26:28,488 INFO [STDOUT] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
2006-04-19 12:26:28,488 INFO [STDOUT] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.ja
2006-04-19 12:26:28,488 INFO [STDOUT] at java.lang.reflect.Method.invoke(Method.java:324)
2006-04-19 12:26:28,488 INFO [STDOUT] at org.jboss.aop.advice.PerInstanceAdvice.invoke(PerInstanceAdvice.java:130)
2006-04-19 12:26:28,488 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.i
2006-04-19 12:26:28,489 INFO [STDOUT] at org.jboss.jms.client.container.ClosedInterceptor.invoke(ClosedInterceptor.java:
2006-04-19 12:26:28,489 INFO [STDOUT] at org.jboss.aop.advice.PerInstanceInterceptor.invoke(PerInstanceInterceptor.java:
2006-04-19 12:26:28,489 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.i
2006-04-19 12:26:28,489 INFO [STDOUT] at org.jboss.jms.client.container.ExceptionInterceptor.invoke(ExceptionInterceptor
2006-04-19 12:26:28,490 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.i
2006-04-19 12:26:28,490 INFO [STDOUT] at org.jboss.jms.client.container.ClientLogInterceptor.invoke(ClientLogInterceptor
2006-04-19 12:26:28,490 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientProducerDelegate$send_3961598017717988886.i
2006-04-19 12:26:28,490 INFO [STDOUT] at org.jboss.jms.client.delegate.ClientProducerDelegate.send(ClientProducerDelegat
2006-04-19 12:26:28,490 INFO [STDOUT] at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:164)
2006-04-19 12:26:28,491 INFO [STDOUT] at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:208)
2006-04-19 12:26:28,491 INFO [STDOUT] at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:145)
2006-04-19 12:26:28,491 INFO [STDOUT] at org.jboss.jms.client.JBossMessageProducer.send(JBossMessageProducer.java:136)
2006-04-19 12:26:28,491 INFO [STDOUT] at es.ftech.rti.caronte.utils.QueueClient.sendJMSCaronte(QueueClient.java:34)
2006-04-19 12:26:28,492 INFO [STDOUT] at es.ftech.rti.caronte.Thread.UDPThread.run(UDPThread.java:119)
2006-04-19 12:26:28,494 INFO [es.ftech.rti.caronte.Thread.UDPThread] Messaggio UDP100, MAC:00A0A2062780 0:26 19/3/1858
2006-04-19 12:26:28,541 ERROR [org.jboss.messaging.core.ChannelSupport] Failed to handle message

My jboss-service.xml of Messaging is this:

<?xml version="1.0" encoding="UTF-8"?>



<loader-repository>jboss.messaging:loader=ScopedLoaderRepository
<loader-repository-config>java2ParentDelegation=false</loader-repository-config>
</loader-repository>

<mbean code="org.jboss.remoting.transport.Connector"
xmbean-dd="org/jboss/remoting/transport/Connector.xml"
name="jboss.messaging:service=Connector,transport=socket"
display-name="Socket transport Connector">

org.jboss.jms.server.remoting.JMSWireFormat
org.jboss.jms.server.remoting.JMSWireFormat
jboss
jms
false
0
${jboss.bind.address}
4457

org.jboss.jms.server.remoting.JMSServerInvocationHandler

jboss.messaging:service=NetworkRegistry




<mbean code="org.jboss.jms.server.ServerPeer"
name="jboss.messaging:service=ServerPeer"
xmbean-dd="xmdesc/ServerPeer-xmbean.xml">







<depends optional-attribute-name="Connector">jboss.messaging:service=Connector,transport=socket
<depends optional-attribute-name="ThreadPool">jboss.messaging:service=ThreadPool
<depends optional-attribute-name="PersistenceManager">jboss.messaging:service=PersistenceManager
<depends optional-attribute-name="MessageStore">jboss.messaging:service=MessageStore
<depends optional-attribute-name="ChannelMapper">jboss.messaging:service=ChannelMapper


20000
java:/jaas/messaging



<mbean code="org.jboss.jms.server.plugin.DefaultThreadPool"
name="jboss.messaging:service=ThreadPool"
xmbean-dd="xmdesc/DefaultThreadPool-xmbean.xml">



<mbean code="org.jboss.messaging.core.plugin.JDBCPersistenceManager" name="jboss.messaging:service=PersistenceManager" xmbean-dd="xmdesc/JDBCPersistenceManager-xmbean.xml">
jboss.jca:service=DataSourceBinding,name=ORACLE_JMS_DS
<depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager
<depends optional-attribute-name="ChannelMapper">jboss.messaging:service=ChannelMapper
java:/ORACLE_JMS_DS
true
true
<![CDATA[
CREATE_MESSAGE_REF=CREATE TABLE JMS_MESSAGE_REFERENCE (CHANNELID INTEGER, MESSAGEID INTEGER, TRANSACTIONID INTEGER, STATE CHAR(1), ORD INTEGER, DELIVERYCOUNT INTEGER, RELIABLE CHAR(1), LOADED CHAR(1), PRIMARY KEY(CHANNELID, MESSAGEID))
CREATE_IDX_MESSAGE_REF_TX=CREATE INDEX JMS_MESSAGE_REF_TX ON JMS_MESSAGE_REFERENCE (TRANSACTIONID)
CREATE_IDX_MESSAGE_REF_ORD=CREATE INDEX JMS_MESSAGE_REF_ORD ON JMS_MESSAGE_REFERENCE (ORD)
CREATE_IDX_MESSAGE_REF_MESSAGEID=CREATE INDEX JMS_MESSAGE_REF_MESSAGEID ON JMS_MESSAGE_REFERENCE (MESSAGEID)
CREATE_IDX_MESSAGE_REF_LOADED=CREATE INDEX JMS_MESSAGE_REF_LOADED ON JMS_MESSAGE_REFERENCE (LOADED)
CREATE_IDX_MESSAGE_REF_RELIABLE=CREATE INDEX JMS_MESSAGE_REF_RELIABLE ON JMS_MESSAGE_REFERENCE (RELIABLE)
INSERT_MESSAGE_REF=INSERT INTO JMS_MESSAGE_REFERENCE (CHANNELID, MESSAGEID, TRANSACTIONID, STATE, ORD, DELIVERYCOUNT, RELIABLE, LOADED) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
DELETE_MESSAGE_REF=DELETE FROM JMS_MESSAGE_REFERENCE WHERE MESSAGEID=? AND CHANNELID=? AND STATE='C'
UPDATE_MESSAGE_REF=UPDATE JMS_MESSAGE_REFERENCE SET TRANSACTIONID=?, STATE='-' WHERE MESSAGEID=? AND CHANNELID=? AND STATE='C'
UPDATE_MESSAGE_REF_NOT_LOADED=UPDATE JMS_MESSAGE_REFERENCE SET LOADED='N' WHERE MESSAGEID=? AND CHANNELID=?
COMMIT_MESSAGE_REF1=UPDATE JMS_MESSAGE_REFERENCE SET STATE='C', TRANSACTIONID = NULL WHERE TRANSACTIONID=? AND STATE='+'
COMMIT_MESSAGE_REF2=DELETE FROM JMS_MESSAGE_REFERENCE WHERE TRANSACTIONID=? AND STATE='-'
ROLLBACK_MESSAGE_REF1=DELETE FROM JMS_MESSAGE_REFERENCE WHERE TRANSACTIONID=? AND STATE='+'
ROLLBACK_MESSAGE_REF2=UPDATE JMS_MESSAGE_REFERENCE SET STATE='C', TRANSACTIONID = NULL WHERE TRANSACTIONID=? AND STATE='-'
LOAD_REF_INFO=SELECT MESSAGEID, ORD, DELIVERYCOUNT FROM JMS_MESSAGE_REFERENCE WHERE CHANNELID=? AND STATE <> '+' AND LOADED = 'N' AND ORD BETWEEN ? AND ? ORDER BY ORD
SELECT_COUNT_REFS=SELECT COUNT(MESSAGEID) FROM JMS_MESSAGE_REFERENCE WHERE CHANNELID=? AND STATE <> '+' AND LOADED='N'
UPDATE_RELIABLE_REFS=UPDATE JMS_MESSAGE_REFERENCE SET LOADED='Y' WHERE ORD BETWEEN ? AND ? AND CHANNELID=? AND RELIABLE='Y' AND STATE <> '+'
DELETE_CHANNEL_MESSAGE_REFS=DELETE FROM JMS_MESSAGE_REFERENCE WHERE CHANNELID=?
REMOVE_ALL_NONRELIABLE_REFS=DELETE FROM JMS_MESSAGE_REFERENCE WHERE RELIABLE='N'
UPDATE_ALL_RELIABLE_REFS=UPDATE JMS_MESSAGE_REFERENCE SET LOADED='N'
SELECT_MIN_ORDERING=SELECT MIN(ORD) FROM JMS_MESSAGE_REFERENCE WHERE CHANNELID=? AND STATE <> '+' AND LOADED = 'N'
DELETE_NON_DURABLE=DELETE FROM JMS_MESSAGE_REFERENCE WHERE CHANNELID NOT IN (SELECT ID FROM JMS_CHANNEL_MAPPING)
CREATE_MESSAGE=CREATE TABLE JMS_MESSAGE (MESSAGEID INTEGER, RELIABLE CHAR(1), EXPIRATION INTEGER, TIMESTAMP INTEGER, PRIORITY INTEGER, COREHEADERS BLOB, PAYLOAD BLOB, CHANNELCOUNT INTEGER, TYPE INTEGER, JMSTYPE VARCHAR2(255), CORRELATIONID VARCHAR2(255), CORRELATIONID_BYTES RAW(254), DESTINATION_ID INTEGER, REPLYTO_ID INTEGER, JMSPROPERTIES BLOB, PRIMARY KEY (MESSAGEID))
LOAD_MESSAGES=SELECT MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID, CORRELATIONID_BYTES, DESTINATION_ID, REPLYTO_ID, JMSPROPERTIES FROM JMS_MESSAGE
INSERT_MESSAGE=INSERT INTO JMS_MESSAGE (MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID, CORRELATIONID_BYTES, DESTINATION_ID, REPLYTO_ID, JMSPROPERTIES) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
UPDATE_MESSAGE_CHANNEL_COUNT=UPDATE JMS_MESSAGE SET CHANNELCOUNT=? WHERE MESSAGEID=?
DELETE_MESSAGE=DELETE FROM JMS_MESSAGE WHERE MESSAGEID=?
MESSAGE_ID_COLUMN=MESSAGEID
REMOVE_ALL_NONRELIABLE_MSGS=DELETE FROM JMS_MESSAGE WHERE RELIABLE='N'
DELETE_ALL_MESSAGES=DELETE FROM JMS_MESSAGE
CREATE_TRANSACTION=CREATE TABLE JMS_TRANSACTION (TRANSACTIONID INTEGER, BRANCH_QUAL RAW(254), FORMAT_ID INTEGER, GLOBAL_TXID RAW(254), PRIMARY KEY (TRANSACTIONID))
INSERT_TRANSACTION=INSERT INTO JMS_TRANSACTION (TRANSACTIONID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TXID) VALUES(?, ?, ?, ?)
DELETE_TRANSACTION=DELETE FROM JMS_TRANSACTION WHERE TRANSACTIONID = ?
SELECT_PREPARED_TRANSACTIONS=SELECT TRANSACTIONID, BRANCH_QUAL, FORMAT_ID, GLOBAL_TXID FROM JMS_TRANSACTION
DELETE_ALL_TRANSACTIONS=DELETE FROM JMS_TRANSACTION
CREATE_COUNTER=CREATE TABLE JMS_COUNTER (NAME VARCHAR2(255), NEXT_ID INTEGER, PRIMARY KEY(NAME))
UPDATE_COUNTER=UPDATE JMS_COUNTER SET NEXT_ID = ? WHERE NAME=?
SELECT_COUNTER=SELECT NEXT_ID FROM JMS_COUNTER WHERE NAME=?
INSERT_COUNTER=INSERT INTO JMS_COUNTER (NAME, NEXT_ID) VALUES (?, ?)
DELETE_ALL_COUNTERS=DELETE FROM JMS_COUNTER
]]>
500

<mbean code="org.jboss.messaging.core.plugin.SimpleMessageStore"
name="jboss.messaging:service=MessageStore"
xmbean-dd="xmdesc/SimpleMessageStore-xmbean.xml">



<mbean code="org.jboss.jms.server.plugin.JDBCChannelMapper" name="jboss.messaging:service=ChannelMapper" xmbean-dd="xmdesc/JDBCChannelMapper-xmbean.xml">
jboss.jca:service=DataSourceBinding,name=ORACLE_JMS_DS
<depends optional-attribute-name="TransactionManager">jboss:service=TransactionManager
java:/ORACLE_JMS_DS
<![CDATA[
CREATE_USER_TABLE=CREATE TABLE JMS_USER (USERID VARCHAR2(32) NOT NULL, PASSWD VARCHAR2(32) NOT NULL, CLIENTID VARCHAR2(128), PRIMARY KEY(USERID))
CREATE_ROLE_TABLE=CREATE TABLE JMS_ROLE (ROLEID VARCHAR2(32) NOT NULL, USERID VARCHAR2(32) NOT NULL, PRIMARY KEY(USERID, ROLEID))
SELECT_PRECONF_CLIENTID=SELECT CLIENTID FROM JMS_USER WHERE USERID=?
CREATE_MAPPING_TABLE=CREATE TABLE JMS_CHANNEL_MAPPING (ID INTEGER, TYPE CHAR(1), JMS_DEST_NAME VARCHAR2(1024), JMS_SUB_NAME VARCHAR2(1024), CLIENT_ID VARCHAR2(128), SELECTOR VARCHAR2(1024), NO_LOCAL CHAR(1), PRIMARY KEY(ID))
INSERT_MAPPING=INSERT INTO JMS_CHANNEL_MAPPING (ID, TYPE, JMS_DEST_NAME, JMS_SUB_NAME, CLIENT_ID, SELECTOR, NO_LOCAL) VALUES (?, ?, ?, ?, ?, ?, ?)
DELETE_MAPPING=DELETE FROM JMS_CHANNEL_MAPPING WHERE ID = ?
SELECT_ID_FOR_DESTINATION=SELECT ID FROM JMS_CHANNEL_MAPPING WHERE TYPE=? AND JMS_DEST_NAME=?
SELECT_DURABLE_SUB=SELECT JMS_DEST_NAME, ID, SELECTOR, NO_LOCAL FROM JMS_CHANNEL_MAPPING WHERE CLIENT_ID=? AND JMS_SUB_NAME=?
SELECT_SUBSCRIPTIONS_FOR_TOPIC=SELECT ID, CLIENT_ID, JMS_SUB_NAME, SELECTOR, NO_LOCAL FROM JMS_CHANNEL_MAPPING WHERE TYPE='D' AND JMS_DEST_NAME=?
]]>



<mbean code="org.jboss.jms.server.connectionfactory.ConnectionFactory"
name="jboss.messaging.destination:service=ConnectionFactory"
xmbean-dd="xmdesc/ConnectionFactory-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

/ConnectionFactory
/XAConnectionFactory
java:/ConnectionFactory
java:/XAConnectionFactory



<mbean code="org.jboss.jms.server.destination.Topic"
name="jboss.messaging.destination:service=Topic,name=testTopic"
xmbean-dd="xmdesc/Topic-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Topic"
name="jboss.messaging.destination:service=Topic,name=securedTopic"
xmbean-dd="xmdesc/Topic-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Topic"
name="jboss.messaging.destination:service=Topic,name=testDurableTopic"
xmbean-dd="xmdesc/Topic-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=testQueue"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer



<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=DLQ"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer



<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=A"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=B"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=C"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=D"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Queue"
name="jboss.messaging.destination:service=Queue,name=ex"
xmbean-dd="xmdesc/Queue-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

<mbean code="org.jboss.jms.server.destination.Topic"
name="jboss.messaging.destination:service=Queue,name=openTopic"
xmbean-dd="xmdesc/Topic-xmbean.xml">
<depends optional-attribute-name="ServerPeer">jboss.messaging:service=ServerPeer

I am not sure if this is a configuration issue, an incompatibility between 1.0 and 1.0.1 or a problem with the Oracle Persisten configuration files.

Thanks in advance,

Nuno

1. Re: Messaging on Oracle

timfox Apr 19, 2006 8:35 AM (in response to nm_pereira)

Nuno-

The version in CVS has a slightly different db structure than the 1.0.0 version you are using, hence the error when you try to use the config from CVS.

1.0.1 will be released very shortly, if you can wait until then it will be greatly appreciated.
Actions

2. Re: Messaging on Oracle

timfox Apr 19, 2006 8:55 AM (in response to nm_pereira)

If you desperate to get it working now, you should be able to just add a dummy column on the JMS_MESSAGE table:

INSERT_MESSAGE=INSERT INTO JMS_MESSAGE (MESSAGEID, RELIABLE, EXPIRATION, TIMESTAMP, PRIORITY, COREHEADERS, PAYLOAD, CHANNELCOUNT, TYPE, JMSTYPE, CORRELATIONID, CORRELATIONID_BYTES, DESTINATION_ID, REPLYTO_ID, JMSPROPERTIES, DUMMY) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

 CREATE TABLE JMS_MESSAGE (MESSAGEID INTEGER, RELIABLE CHAR(1), EXPIRATION INTEGER, TIMESTAMP INTEGER, PRIORITY INTEGER, COREHEADERS BLOB, PAYLOAD BLOB, CHANNELCOUNT INTEGER, TYPE INTEGER, JMSTYPE VARCHAR2(255), CORRELATIONID VARCHAR2(255), CORRELATIONID_BYTES RAW(254), DESTINATION_ID INTEGER, REPLYTO_ID INTEGER, JMSPROPERTIES BLOB, DUMMY INTEGER, PRIMARY KEY (MESSAGEID))

3. Re: Messaging on Oracle

nm_pereira Apr 19, 2006 10:22 AM (in response to nm_pereira)

Thank you Tim.

It is working, but we will install version 1.0.1 as soon as it is available.
Actions

Go to original post