6 Replies Latest reply on Aug 25, 2010 12:29 PM by sathyaprakash

    MySQL 5.1 with JBoss ESB 5.0.0

      Hi, hope someone can help.  I'm pretty new to building environments, so have posted this in Beginner's corner to avoid annoying people who know what they're doing!

       

      I have successfully installed JBoss SOA Platform 5.0.0 on a Fedra platform, and verified that the server is up and running.

      I have also successfully installed MySQL 5.1 and verified that this is working.

       

      I would now like to configure JBoss SOA Platofrm to use MySQL as a datasource, but am finding it extremely difficult to work out how to do this.  The best lead I have so far is:

      http://soaengine.wordpress.com/2009/09/16/switch-jbossas-4-2-3-and-jbossesb-4-5-from-hsql-to-mysql/

      ... but I can't seem to get anywhere with this.

       

      Can someone outline the steps required to configure JBoss ESB 5.0.0 to use MySQL 5.1?

       

      And yes, I've read the manuals but I'm afraid they didn't make much sense to me (and for the record I HAVE achieved a similar feat for the JBoss Portal server by following manuals!).

        • 1. Re: MySQL 5.1 with JBoss ESB 5.0.0
          peterj

          Looking at that link, it appears that they are giving the steps for replacing HSQL with MySQL for all of the services, not just for strictly the ESB portions. Though I guess that in a production environment that is really what you want to do anyway. But that leaves a lot of possibilities as to what wen wrong. You might want to try things one step at a time. I recommend doing the basic JBoss AS services first, well everything except JBoss Messaging. Then do Messaging, And finally tackle ESB.

           

          Here is a prior disucssion on moving JBoss AS to MySQL:

          http://community.jboss.org/message/204473

           

          Here are some links that might also help:

          http://community.jboss.org/wiki/JBossESB47switchfromHSQLDBtoPotsgresqlonJBoss423GA

           

          If none of this helps, please post the first exception stack trace that you are seeing in the console log.

          • 2. Re: MySQL 5.1 with JBoss ESB 5.0.0

            Hi Peter, thanks for the response.  We have a little progress, but I'm cautious to not change too many things at once.

             

            1.  I have created a MySQL database called "jboss_soa" with user "jboss".  Host setup, and grant priviliges are all correct.

            2.  Create a mysql-ds.xml file in the deploy directory:

            <?xml version="1.0" encoding="UTF-8"?>
            <!-- $Id: mysql-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
            <!--  Datasource config for MySQL using 3.0.9 available from:
            http://www.mysql.com/downloads/api-jdbc-stable.html
            -->
            <datasources>
              <local-tx-datasource>
                <jndi-name>DefaultDS</jndi-name>
                <connection-url>jdbc:mysql://localhost:3306/jboss_soa</connection-url>
                <driver-class>com.mysql.jdbc.Driver</driver-class>
                <user-name>jboss</user-name>
                <password>jboss</password>
                <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
                <min-pool-size>1</min-pool-size>
                <max-pool-size>20</max-pool-size>
                <metadata>
                   <type-mapping>mySQL</type-mapping>
                </metadata>
              </local-tx-datasource>
            </datasources>
            
            

            3.  Copied in the mysql-persistence-service.xml file into the deploy directory.

            4.  Started the service.

             

            Results:

            a) I now have a number of tables created in the database:

             

            mysql> show tables from jboss_soa;
            +---------------------+
            | Tables_in_jboss_soa |
            +---------------------+
            | HILOSEQUENCES       |
            | JBM_COUNTER         |
            | JBM_DUAL            |
            | JBM_ID_CACHE        |
            | JBM_MSG_REF         |
            | JBM_ROLE            |
            | JBM_TX              |
            | JBM_USER            |
            | TIMERS              |
            +---------------------+
            9 rows in set (0.00 sec)

             

            b) Errors appearing in the console log (edited for just WARN and ERROR mesages)

            2010-03-16 08:55:48,519 WARN  [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PersistenceManager
            javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PersistenceManager",type=Component already registered.
            " at org.jboss.mx.server.registry.BasicMBeanRegistry.add(BasicMBeanRegistry.java:756)"
            (Stack trace removed)
            " at java.lang.Thread.run(Thread.java:619)"
            2010-03-16 08:55:48,523 WARN  [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PostOffice
            javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PostOffice",type=Component already registered.
            " at org.jboss.mx.server.registry.BasicMBeanRegistry.add(BasicMBeanRegistry.java:756)"
            (Stack trace removed)
            " at java.lang.Thread.run(Thread.java:619)"
            2010-03-16 08:55:48,525 WARN  [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=JMSUserManager
            javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=JMSUserManager",type=Component already registered.
            " at org.jboss.mx.server.registry.BasicMBeanRegistry.add(BasicMBeanRegistry.java:756)"
            (Stack trace removed)
            " at java.lang.Thread.run(Thread.java:619)"
            2010-03-16 08:55:48,551 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/usr/jboss/jboss-as/server/default/deploy/mysql-persistence-service.xml state=PreReal mode=Manual requiredState=Real
            org.jboss.deployers.spi.DeploymentException: Error deploying: jboss.messaging:service=PersistenceManager
            " at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)"
            (Stack trace removed)
            " at java.lang.Thread.run(Thread.java:619)"
            Caused by: java.lang.IllegalStateException: jboss.messaging:service=PersistenceManager is already installed.
            2010-03-16 08:55:52,278 WARN  [org.jboss.jms.server.jbosssx.JBossASSecurityMetadataStore] (main) WARNING! POTENTIAL SECURITY RISK. It has been detected that the MessageSucker component which sucks messages from one node to another has not had its password changed from the installation default. Please see the JBoss Messaging user guide for instructions on how to do this.
            2010-03-16 08:55:59,442 WARN  [org.hibernate.ejb.Ejb3Configuration] (main) Persistence provider caller does not implement the EJB3 spec correctly. PersistenceUnitInfo.getNewTempClassLoader() is null.
            2010-03-16 08:56:06,020 WARN  [org.hibernate.impl.SessionFactoryObjectFactory] (main) InitialContext did not implement EventContext
            2010-03-16 08:56:08,231 WARN  [org.hibernate.impl.SessionFactoryImpl] (main) JTASessionContext being used with JDBCTransactionFactory; auto-flush will not operate correctly with getCurrentSession()
            2010-03-16 08:56:18,212 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1
            com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1
            " at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)"
            " at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)"
            " at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)"
            " at java.lang.reflect.Constructor.newInstance(Constructor.java:513)"
            " at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)"
            " at com.mysql.jdbc.Util.getInstance(Util.java:381)"
            " at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1030)"
            " at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)"
            " at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)"
            " at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)"
            " at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1959)"
            " at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2109)"
            " at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2643)"
            " at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2077)"
            " at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:2228)"
            " at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:342)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2647)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice$1LoadBindings.doTransaction(MessagingPostOffice.java:2630)"
            " at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.execute(JDBCSupport.java:394)"
            " at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:416)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2698)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:369)"
            " at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:462)"
            " at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:376)"
            " at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:269)"
            " 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:597)"
            " at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:157)"
            " at org.jboss.mx.server.Invocation.dispatch(Invocation.java:96)"
            " at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:138)"
            " at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)"
            " at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:140)"
            " at org.jboss.mx.server.Invocation.invoke(Invocation.java:90)"
            " at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)"
            " at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:668)"
            " at org.jboss.system.microcontainer.ServiceProxy.invoke(ServiceProxy.java:206)"
            " at $Proxy38.start(Unknown Source)"
            " at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:42)"
            " at org.jboss.system.microcontainer.StartStopLifecycleAction.installAction(StartStopLifecycleAction.java:37)"
            " at org.jboss.dependency.plugins.action.SimpleControllerContextAction.simpleInstallAction(SimpleControllerContextAction.java:62)"
            " at org.jboss.dependency.plugins.action.AccessControllerContextAction.install(AccessControllerContextAction.java:71)"
            " at org.jboss.dependency.plugins.AbstractControllerContextActions.install(AbstractControllerContextActions.java:51)"
            " at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)"
            " at org.jboss.system.microcontainer.ServiceControllerContext.install(ServiceControllerContext.java:297)"
            " at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1633)"
            " at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:935)"
            " at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1083)"
            " at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:985)"
            " at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:823)"
            " at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)"
            " at org.jboss.system.ServiceController.doChange(ServiceController.java:688)"
            " at org.jboss.system.ServiceController.start(ServiceController.java:460)"
            " at org.jboss.system.deployers.ServiceDeployer.start(ServiceDeployer.java:163)"
            " at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:99)"
            " at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)"
            " at org.jboss.deployers.spi.deployer.helpers.AbstractSimpleRealDeployer.internalDeploy(AbstractSimpleRealDeployer.java:62)"
            " at org.jboss.deployers.spi.deployer.helpers.AbstractRealDeployer.deploy(AbstractRealDeployer.java:50)"
            " at org.jboss.deployers.plugins.deployers.DeployerWrapper.deploy(DeployerWrapper.java:171)"
            " at org.jboss.deployers.plugins.deployers.DeployersImpl.doDeploy(DeployersImpl.java:1440)"
            " at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1158)"
            " at org.jboss.deployers.plugins.deployers.DeployersImpl.doInstallParentFirst(DeployersImpl.java:1179)"
            " at org.jboss.deployers.plugins.deployers.DeployersImpl.install(DeployersImpl.java:1099)"
            " at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)"
            " at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1633)"
            " at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:935)"
            " at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1083)"
            " at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:985)"
            " at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:823)"
            " at org.jboss.dependency.plugins.AbstractController.change(AbstractController.java:553)"
            " at org.jboss.deployers.plugins.deployers.DeployersImpl.process(DeployersImpl.java:782)"
            " at org.jboss.deployers.plugins.main.MainDeployerImpl.process(MainDeployerImpl.java:702)"
            " at org.jboss.system.server.profileservice.repository.MainDeployerAdapter.process(MainDeployerAdapter.java:117)"
            " at org.jboss.system.server.profileservice.repository.ProfileDeployAction.install(ProfileDeployAction.java:70)"
            " at org.jboss.system.server.profileservice.repository.AbstractProfileAction.install(AbstractProfileAction.java:53)"
            " at org.jboss.system.server.profileservice.repository.AbstractProfileService.install(AbstractProfileService.java:403)"
            " at org.jboss.dependency.plugins.AbstractControllerContext.install(AbstractControllerContext.java:348)"
            " at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:1633)"
            " at org.jboss.dependency.plugins.AbstractController.incrementState(AbstractController.java:935)"
            " at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:1083)"
            " at org.jboss.dependency.plugins.AbstractController.resolveContexts(AbstractController.java:985)"
            " at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:775)"
            " at org.jboss.dependency.plugins.AbstractController.install(AbstractController.java:540)"
            " at org.jboss.system.server.profileservice.repository.AbstractProfileService.registerProfile(AbstractProfileService.java:308)"
            " at org.jboss.system.server.profileservice.ProfileServiceBootstrap.start(ProfileServiceBootstrap.java:256)"
            " at org.jboss.bootstrap.AbstractServerImpl.start(AbstractServerImpl.java:461)"
            " at org.jboss.Main.boot(Main.java:221)"
            " at org.jboss.Main$1.run(Main.java:556)"
            " at java.lang.Thread.run(Thread.java:619)"
            2010-03-16 08:56:18,216 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) Trying again after a pause
            2010-03-16 08:56:18,331 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:2
            2010-03-16 08:56:18,773 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:3
            2010-03-16 08:56:18,878 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:4
            2010-03-16 08:56:19,366 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:5
            2010-03-16 08:56:19,457 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:6
            2010-03-16 08:56:19,691 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:7
            2010-03-16 08:56:19,995 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:8
            2010-03-16 08:56:20,448 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:9
            2010-03-16 08:56:20,945 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:10
            2010-03-16 08:56:21,328 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:11
            2010-03-16 08:56:21,433 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:12
            2010-03-16 08:56:21,732 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:13
            2010-03-16 08:56:22,032 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:14
            2010-03-16 08:56:22,112 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:15
            2010-03-16 08:56:22,615 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:16
            2010-03-16 08:56:22,658 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:17
            2010-03-16 08:56:22,791 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:18
            2010-03-16 08:56:22,828 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:19
            2010-03-16 08:56:22,862 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:20
            2010-03-16 08:56:23,108 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:21
            2010-03-16 08:56:23,166 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:22
            2010-03-16 08:56:23,222 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:23
            2010-03-16 08:56:23,255 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:24
            2010-03-16 08:56:23,280 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:25
            2010-03-16 08:56:23,300 ERROR [org.jboss.messaging.core.impl.JDBCSupport] (main) Retried 25 times, now giving up
            2010-03-16 08:56:23,321 ERROR [org.jboss.messaging.util.ExceptionUtil] (main)
            org.jboss.messaging.core.jmx.MessagingPostOfficeService@1a64c3b startService
            java.lang.IllegalStateException: Failed to excecute transaction
            " at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:432)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2698)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:369)"
            " at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:462)"
            (Stack trace removed)
            2010-03-16 08:56:23,347 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.messaging:service=PostOffice state=Create mode=Manual requiredState=Installed
            java.lang.IllegalStateException: Failed to excecute transaction
            " at org.jboss.messaging.core.impl.JDBCSupport$JDBCTxRunner.executeWithRetry(JDBCSupport.java:432)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.getBindingsFromStorage(MessagingPostOffice.java:2698)"
            " at org.jboss.messaging.core.impl.postoffice.MessagingPostOffice.start(MessagingPostOffice.java:369)"
            " at org.jboss.messaging.core.jmx.MessagingPostOfficeService.startService(MessagingPostOfficeService.java:462)"
            (Stack trace removed)
            2010-03-16 08:56:33,966 ERROR [org.jboss.messaging.util.ExceptionUtil] (main) Queue[null, name=DeadMessageQueue] startService
            java.lang.NullPointerException
            " at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
            " at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
            (Stack trace removed)
            2010-03-16 08:56:33,982 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb.destination:name=DeadMessageQueue,service=Queue state=Create mode=Manual requiredState=Installed
            java.lang.NullPointerException
            " at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
            " at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
            (Stack trace removed)
            2010-03-16 08:56:34,608 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbossesb.esb/ state=PreReal mode=Manual requiredState=Real
            org.jboss.deployers.spi.DeploymentException: Error deploying: jboss.esb.destination:service=Queue,name=DeadMessageQueue
            " at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)"
            " at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:118)"
            " at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)"
            (Stack trace removed)
            2010-03-16 08:56:36,393 ERROR [org.jboss.messaging.util.ExceptionUtil] (main) Queue[null, name=CallbackQueue] startService
            java.lang.NullPointerException
            " at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
            " at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
            (Stack trace removed)
            2010-03-16 08:56:36,400 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Start: name=jboss.esb.destination:name=CallbackQueue,service=Queue state=Create mode=Manual requiredState=Installed
            java.lang.NullPointerException
            " at org.jboss.jms.server.ServerPeer.getPostOfficeInstance(ServerPeer.java:1389)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.setMaxSizeForQueues(DestinationServiceSupport.java:281)"
            " at org.jboss.jms.server.destination.DestinationServiceSupport.startService(DestinationServiceSupport.java:118)"
            " at org.jboss.jms.server.destination.QueueService.startService(QueueService.java:65)"
            (Stack trace removed)
            2010-03-16 08:56:36,553 ERROR [org.jboss.kernel.plugins.dependency.AbstractKernelController] (main) Error installing to Real: name=vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbpm.esb/ state=PreReal mode=Manual requiredState=Real
            org.jboss.deployers.spi.DeploymentException: Error deploying: jboss.esb.destination:service=Queue,name=CallbackQueue
            " at org.jboss.deployers.spi.DeploymentException.rethrowAsDeploymentException(DeploymentException.java:49)"
            " at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:118)"
            " at org.jboss.system.deployers.ServiceDeployer.deploy(ServiceDeployer.java:46)"
            (Stack trace removed)
            2010-03-16 08:56:42,860 ERROR [org.jboss.system.server.profileservice.ProfileServiceBootstrap] (main) Failed to load profile: Summary of incomplete deployments (SEE PREVIOUS ERRORS FOR DETAILS):

            DEPLOYMENTS MISSING DEPENDENCIES:
            Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbrules.esb/" is missing the following dependencies:
            Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbrules.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
            Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/slsb.esb/" is missing the following dependencies:
            Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/slsb.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
            Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/smooks.esb/" is missing the following dependencies:
            Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/smooks.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
            Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/soap.esb/" is missing the following dependencies:
            Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/soap.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
            Deployment "jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/spring.esb/" is missing the following dependencies:
            Dependency "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/spring.esb/>" (should be in state "PreInstall", but is actually in state "** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **")
            Deployment "jboss.messaging.connectionfactory:service=ClusterPullConnectionFactory" is missing the following dependencies:
            Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
            Dependency "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" (should be in state "Create", but is actually in state "Configured")
            Deployment "jboss.messaging.connectionfactory:service=ClusteredConnectionFactory" is missing the following dependencies:
            Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
            Deployment "jboss.messaging.connectionfactory:service=ConnectionFactory" is missing the following dependencies:
            Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
            Deployment "jboss.messaging.destination:name=DLQ,service=Queue" is missing the following dependencies:
            Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")
            Deployment "jboss.messaging.destination:name=ExpiryQueue,service=Queue" is missing the following dependencies:
            Dependency "jboss.messaging:service=PostOffice" (should be in state "Create", but is actually in state "**ERROR**")

            DEPLOYMENTS IN ERROR:
            Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/slsb.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
            Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/smooks.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
            Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/spring.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
            Deployment "vfsfile:/usr/jboss/jboss-as/server/default/deploy/mysql-persistence-service.xml" is in error due to the following reason(s): java.lang.IllegalStateException: jboss.messaging:service=PersistenceManager is already installed.
            Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbrules.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
            Deployment "vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbossesb.esb/" is in error due to the following reason(s): java.lang.NullPointerException
            Deployment "jboss.messaging:service=PostOffice" is in error due to the following reason(s): java.lang.IllegalStateException: Failed to excecute transaction, **ERROR**
            Deployment "<UNKNOWN jboss.esb.vfsfile:/usr/jboss/jboss-as/server/default/deploy/soap.esb/>" is in error due to the following reason(s): ** UNRESOLVED Demands 'jboss.esb:deployment=jbossesb.esb' **
            Deployment "vfsfile:/usr/jboss/jboss-as/server/default/deploy/jbpm.esb/" is in error due to the following reason(s): java.lang.NullPointerException

            2010-03-16 08:56:42,945 INFO  [org.apache.coyote.http11.Http11Protocol] (main) Starting Coyote HTTP/1.1 on http-127.0.0.1-8080
            2010-03-16 08:56:43,018 INFO  [org.apache.coyote.ajp.AjpProtocol] (main) Starting Coyote AJP/1.3 on ajp-127.0.0.1-8009
            2010-03-16 08:56:43,166 INFO  [org.jboss.bootstrap.microcontainer.ServerImpl] (main) JBoss (Microcontainer) [5.0.0.Beta1_SOA (build: SVNTag=5.0.0.Beta1_SOA date=200912141601)] Started in 2m:8s:62ms

             

            Doesn't look very healthy!  Can you see what else I've got wrong?

            • 3. Re: MySQL 5.1 with JBoss ESB 5.0.0
              peterj

              2010-03-16 08:55:48,519 WARN  [org.jboss.deployers.structure.spi.helpers.AbstractDeploymentContext] (main) Unable to register deployment mbean jboss.messaging:service=PersistenceManager
              javax.management.InstanceAlreadyExistsException: jboss.deployment:id="jboss.messaging:service=PersistenceManager",type=Component already registered.

               

              I'm not sure if that is a probllem or not. Try grepping the config files for jboss.messaging:service=PersistenceManager to see if you have multiple of them declared.

               

              2010-03-16 08:56:18,212 WARN  [org.jboss.messaging.core.impl.JDBCSupport] (main) SQLException caught, SQLState 42000 code:1064- assuming deadlock detected, try:1
              com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CONDITION, SELECTOR, CHANNEL_ID, CLUSTERED, ALL_NODES FROM JBM_POSTOFFICE WHERE ' at line 1

               

              This sounds like you did not replace the server/xxx/deploy/messaging/hsqldb-persistence-service.xml with the one for MySQL, which you can find at docs/examples/jms/mysql-persistence-service.xml. (Or do you have both files in .../deploy/messaging? That could explain the first warning - you should have only one of these files.)

              • 4. Re: MySQL 5.1 with JBoss ESB 5.0.0

                Just closing the loop on this even though its been a couple of months.  Thanks for all the help - I basically reinstalled the whole thing, and methodically went back through all of the config and datasources one by one, making sure they worked with MySQL before doing the next one.  It took me about an hour to get everything right, and I now have all the services using MySQL.

                 

                Dumb user error!

                 

                Thanks again, problem solved!

                • 5. Re: MySQL 5.1 with JBoss ESB 5.0.0
                  sathyaprakash

                  Hi ,

                   

                  I have created mysql Datasoucre.xml and copied to deploy folder and hsql datasoucre.xml.

                  <datasources>
                    <local-tx-datasource>
                      <jndi-name>DefaultJNDI</jndi-name>
                      <connection-url>jdbc:mysql://10.10.10.10:3306;DatabaseName=spc</connection-url>
                      <driver-class>com.mysql.jdbc.Driver</driver-class>
                      <user-name>tp_user</user-name>
                      <password>tp_user</password>
                      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                      <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
                      <min-pool-size>1</min-pool-size>
                      <max-pool-size>20</max-pool-size>
                      <metadata>
                         <type-mapping>mySQL</type-mapping>
                      </metadata>
                    </local-tx-datasource>
                  </datasources>

                   

                  Is there any more to do changes?

                  • 6. Re: MySQL 5.1 with JBoss ESB 5.0.0
                    sathyaprakash

                    Hi  Tony,

                     

                    Have you did only the four step for migrating to mysql.

                     

                    I have one question as you said point no 3.Copied in the mysql-persistence-service.xml file into the deploy directory.

                     

                    from where you have Copied the mysql-persistence-service.xml.

                     

                    Any changes in mysql-persistence-service.xml is required.

                     

                    Many Thanks in Advance.