4 Replies Latest reply on Dec 24, 2004 3:10 PM by gurka

    Changing use of HyperSonic  with PostgreSQL for JMS Persista

    gurka Newbie

      Can anyone write out a step-by-step for doing this? I read the post @ http://www.jboss.org/wiki/Wiki.jsp?page=ConfigJBossMQDB and I still have doubts.

      if anyone has done this successfully, would appreciate your help.

      We are using PostGreSQL currently as part of a deployed app under JBoss, but are only now making use of JMS, and heavily. We have noticed strange errors, and have decided to make the switch from Hypersonic to PostGreSQL.

      Thanks for any help.

        • 1. JBoss and SonicMQ
          Scott Stark Master

          Hello,
          I am trying to integrate SonicMQ into JBoss as JMS
          provider. I almost managed to do that but I still get
          a JMS exception as soon as I deploy more than one MDB :
          ______________________________________________________
          [Container factory] Serious error in init: javax.jms.JMSException: [129] progress.message.client.EUserAlreadyConnected: 8884927054856847360
          [Container factory] java.lang.Exception: javax.jms.JMSException: [129] progress.message.client.EUserAlreadyConnected: 8884927054856847360
          [Container factory] at org.jboss.ejb.MessageDrivenContainer.init(MessageDrivenContainer.java:173)
          [Container factory] at org.jboss.ejb.Application.init(Application.java:202)
          [Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:372)
          [Container factory] at org.jboss.ejb.ContainerFactory.deploy(ContainerFactory.java:304)
          [Container factory] at java.lang.reflect.Method.invoke(Native Method)
          [Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
          [Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          [Container factory] at org.jboss.deployment.J2eeDeployer.startModules(J2eeDeployer.java:486)
          [Container factory] at org.jboss.deployment.J2eeDeployer.startApplication(J2eeDeployer.java:464)
          [Container factory] at org.jboss.deployment.J2eeDeployer.deploy(J2eeDeployer.java:208)
          [Container factory] at java.lang.reflect.Method.invoke(Native Method)
          [Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1628)
          [Container factory] at com.sun.management.jmx.MBeanServerImpl.invoke(MBeanServerImpl.java:1523)
          [Container factory] at org.jboss.ejb.AutoDeployer.deploy(AutoDeployer.java:379)
          [Container factory] at org.jboss.ejb.AutoDeployer.run(AutoDeployer.java:217)
          [Container factory] at java.lang.Thread.run(Unknown Source)
          [J2EE Deployer Default] Starting connectioncontroller.jar failed!
          _____________________________________________________


          Do you have an idea about that ??

          Regards,
          Francesco.

          • 2. Re: Changing use of HyperSonic  with PostgreSQL for JMS Pers
            Scott Stark Master

            Give the wiki steps a try and indicate what did not work.

            • 3. Re: Changing use of HyperSonic  with PostgreSQL for JMS Pers
              gurka Newbie

              Scott - do I need to do anything in terms of creating a specific DB for this use of JMS by JBoss? Or does just pointing it to the correct DS is all it takes? Will JBoss create the schema, etc..? I read that I may have to tweak the schema somewhat by creating our own indexes and so on...anything else needed?

              thanks - I will try the Wiki steps meantime.

              • 4. Re: Changing use of HyperSonic  with PostgreSQL for JMS Pers
                gurka Newbie

                Scott - followed the steps. I now see a set of tables created by JBoss - but theses errors are showing up now:

                2004-12-24 12:06:58,347 DEBUG [org.jboss.ha.framework.server.HAPartitionImpl] destination list is non-null and empty: no need to send message
                2004-12-24 12:06:58,348 ERROR [org.jboss.ejb.plugins.jms.DLQHandler] Initialization failed DLQHandler
                javax.jms.JMSException: Error creating the dlq connection: XAConnectionFactory
                at org.jboss.ejb.plugins.jms.DLQHandler.createService(DLQHandler.java:171)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.java:237)
                at org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:164)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker.innerCreate(JMSContainerInvoker.java:542)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker.startService(JMSContainerInvoker.java:764)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker$ExceptionListenerImpl.onException(JMSContainerInvoker.java:1267)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker$1.run(JMSContainerInvoker.java:776)
                2004-12-24 12:06:58,349 INFO [org.jboss.ejb.plugins.jms.JMSContainerInvoker] Reconnected to JMS provider
                2004-12-24 12:06:58,350 WARN [org.jboss.ejb.plugins.jms.JMSContainerInvoker] JMS provider failure detected:
                javax.jms.JMSException: Error creating the dlq connection: XAConnectionFactory
                at org.jboss.ejb.plugins.jms.DLQHandler.createService(DLQHandler.java:171)
                at org.jboss.system.ServiceMBeanSupport.jbossInternalCreate(ServiceMBeanSupport.java:237)
                at org.jboss.system.ServiceMBeanSupport.create(ServiceMBeanSupport.java:164)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker.innerCreate(JMSContainerInvoker.java:542)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker.startService(JMSContainerInvoker.java:764)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker$ExceptionListenerImpl.onException(JMSContainerInvoker.java:1267)
                at org.jboss.ejb.plugins.jms.JMSContainerInvoker$1.run(JMSContainerInvoker.java:776)
                2004-12-24 12:06:58,351 INFO [org.jboss.ejb.plugins.jms.JMSContainerInvoker] Trying to reconnect to JMS provider