[jboss-user] [JBoss Messaging] - Problem occured when changing the db of JBoss Messaging from hsqldb to mysqldb

Younes Yahyaoui [http://community.jboss.org/people/ingedeut] created the discussion "Problem occured when changing the db of JBoss Messaging from hsqldb to mysqldb" To view the discussion, visit: http://community.jboss.org/message/566133#566133 -------------------------------------------------------------- Hello, i use JBoss SOA Platform 4.3.0 . When triying to change the db of JBoss messaging from hsqldb to MySQL, the following error is occured. Can someone please help me? it's urgent. 20:25:05,586 ERROR [ChannelSupport] Failed to handle message java.lang.NullPointerException at java.util.concurrent.ConcurrentHashMap.put(Unknown Source) at org.jboss.messaging.core.impl.JDBCPersistenceManager.cacheID( JDBCPersistenceManager.java:1632) at org.jboss.messaging.core.impl.JDBCPersistenceManager$1AddReferenceRunner.doTransaction( JDBCPersistenceManager.java:1358) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.execute( JDBCSupport.java:474) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry( JDBCSupport.java:512) at org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference( JDBCPersistenceManager.java:1396) at org.jboss.messaging.core.impl.ChannelSupport.handle( ChannelSupport.java:226) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal( MessagingPostOffice.java:2208) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route( MessagingPostOffice.java:494) at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:755) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:05,591 ERROR [ExceptionUtil] SessionEndpoint[o2-9omq37fg-1-ctsm37fg-h167w5-194o4c5] send [p2-z1nq37fg-1-ctsm37fg-h167w5-194o4c5] javax.jms.JMSException : Failed to route Reference[21084699122810940]:RELIABLE to org_pi4soa_fcdchain_fcdchain_FcdChainProcess_DataImporterParticipant at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:757) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:05,645 ERROR [ChannelSupport] Failed to handle message java.lang.NullPointerException at java.util.concurrent.ConcurrentHashMap.put(Unknown Source) at org.jboss.messaging.core.impl.JDBCPersistenceManager.cacheID( JDBCPersistenceManager.java:1632) at org.jboss.messaging.core.impl.JDBCPersistenceManager$1AddReferenceRunner.doTransaction( JDBCPersistenceManager.java:1358) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.execute( JDBCSupport.java:474) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry( JDBCSupport.java:512) at org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference( JDBCPersistenceManager.java:1396) at org.jboss.messaging.core.impl.ChannelSupport.handle( ChannelSupport.java:226) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal( MessagingPostOffice.java:2208) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route( MessagingPostOffice.java:494) at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:755) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:05,646 ERROR [ExceptionUtil] SessionEndpoint[o2-9omq37fg-1-ctsm37fg-h167w5-194o4c5] send [q2-i3nq37fg-1-ctsm37fg-h167w5-194o4c5] javax.jms.JMSException : Failed to route Reference[21084699125415997]:RELIABLE to org_pi4soa_fcdchain_fcdchain_FcdChainProcess_DataImporterParticipant at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:757) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:16,888 ERROR [ChannelSupport] Failed to handle message java.lang.NullPointerException at java.util.concurrent.ConcurrentHashMap.put(Unknown Source) at org.jboss.messaging.core.impl.JDBCPersistenceManager.cacheID( JDBCPersistenceManager.java:1632) at org.jboss.messaging.core.impl.JDBCPersistenceManager$1AddReferenceRunner.doTransaction( JDBCPersistenceManager.java:1358) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.execute( JDBCSupport.java:474) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry( JDBCSupport.java:512) at org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference( JDBCPersistenceManager.java:1396) at org.jboss.messaging.core.impl.ChannelSupport.handle( ChannelSupport.java:226) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal( MessagingPostOffice.java:2208) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route( MessagingPostOffice.java:494) at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:755) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:16,889 ERROR [ExceptionUtil] SessionEndpoint[u2-mpvq37fg-1-ctsm37fg-h167w5-194o4c5] send [v2-trvq37fg-1-ctsm37fg-h167w5-194o4c5] javax.jms.JMSException : Failed to route Reference[21084699309162558]:RELIABLE to DeadMessageQueue at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:757) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:16,948 ERROR [ChannelSupport] Failed to handle message java.lang.NullPointerException at java.util.concurrent.ConcurrentHashMap.put(Unknown Source) at org.jboss.messaging.core.impl.JDBCPersistenceManager.cacheID( JDBCPersistenceManager.java:1632) at org.jboss.messaging.core.impl.JDBCPersistenceManager$1AddReferenceRunner.doTransaction( JDBCPersistenceManager.java:1358) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.execute( JDBCSupport.java:474) at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner2.executeWithRetry( JDBCSupport.java:512) at org.jboss.messaging.core.impl.JDBCPersistenceManager.addReference( JDBCPersistenceManager.java:1396) at org.jboss.messaging.core.impl.ChannelSupport.handle( ChannelSupport.java:226) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.routeInternal( MessagingPostOffice.java:2208) at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.route( MessagingPostOffice.java:494) at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:755) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) 20:25:16,949 ERROR [ExceptionUtil] SessionEndpoint[u2-mpvq37fg-1-ctsm37fg-h167w5-194o4c5] send [w2-htvq37fg-1-ctsm37fg-h167w5-194o4c5] javax.jms.JMSException : Failed to route Reference[21084699310538815]:RELIABLE to DeadMessageQueue at org.jboss.jms.server.endpoint.ServerConnectionEndpoint.sendMessage( ServerConnectionEndpoint.java:757) at org.jboss.jms.server.endpoint.ServerSessionEndpoint.send( ServerSessionEndpoint.java:391) at org.jboss.jms.server.endpoint.advised.SessionAdvised.org$jboss$jms$server$endpoint$advised$SessionAdvised$send$aop( SessionAdvised.java:87) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.container.SecurityAspect.handleSend( SecurityAspect.java:157) at sun.reflect.GeneratedMethodAccessor129.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.jboss.aop.advice.PerInstanceAdvice.invoke( PerInstanceAdvice.java:121) at org.jboss.jms.server.endpoint.advised.SessionAdvised$send_7280680627620114891.invokeNext(SessionAdvised$send_7280680627620114891.java) at org.jboss.jms.server.endpoint.advised.SessionAdvised.send(SessionAdvised.java) at org.jboss.jms.wireformat.SessionSendRequest.serverInvoke( SessionSendRequest.java:95) at org.jboss.jms.server.remoting.JMSServerInvocationHandler.invoke( JMSServerInvocationHandler.java:143) at org.jboss.remoting.ServerInvoker.invoke( ServerInvoker.java:866) at org.jboss.remoting.transport.socket.ServerThread.processInvocation( ServerThread.java:608) at org.jboss.remoting.transport.socket.ServerThread.dorun( ServerThread.java:420) at org.jboss.remoting.transport.socket.ServerThread.run( ServerThread.java:173) Thank you very much Younes -------------------------------------------------------------- Reply to this message by going to Community [http://community.jboss.org/message/566133#566133] Start a new discussion in JBoss Messaging at Community [http://community.jboss.org/choose-container!input.jspa?contentType=1&...]