5 Replies Latest reply on Aug 6, 2004 8:40 AM by Sathish Kumar Rathinam

    MySQL error with JMS-Server

    Berlin Brown Newbie

      I just created a MySQL datasource but it seems like one of the JBOSS system tables didnt get created:

      The table in mysql is not there, do I need to create it manually?

      I think the system got out of sync, hmm, any ideas?

      'jboss.JMS_MESSAGES'

      I am using a basic mysql-ds.xml with user name and password, I never use JMS, so I dont know why this aspect of jboss is giving me trouble. I guess I shouldnt care, but I want to resolve problems now before


      Ver 12.18 Distrib 4.0.11a-gamma, for mandrake-linux-gnu (i586

      jboss3.2.5

      Interesting message:

      Cause: org.jboss.mq.SpyJMSException: Could not resolve uncommited transaction

      9:05:03,705 INFO [JmsXA] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=TxCM,name=JmsXA to JNDI name 'java:/JmsXA'
      09:05:03,721 INFO [DefaultDS] Bound connection factory for resource adapter for ConnectionManager 'jboss.jca:service=LocalTxCM,name=DefaultDS to JNDI name 'java:/DefaultDS'
      09:05:04,112 ERROR [PersistenceManager] Starting failed jboss.mq:service=PersistenceManager
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error, message from server: "Table 'jboss.JMS_MESSAGES' doesn't exist")
      at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:337)
      at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1360)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:271)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:221)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
      at $Proxy17.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:367)
      at org.jboss.system.ServiceController.start(ServiceController.java:389)
      at org.jboss.system.ServiceController.start(ServiceController.java:389)
      at java.lang.reflect.Method.invoke(Native Method)
      at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:251)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:836)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:645)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java

        • 1. Re: MySQL error with JMS-Server
          Berlin Brown Newbie

          Nevermind, I needed to configure the JBossMQ to create the tables for MySQL

          • 2. Re: MySQL error with JMS-Server
            Berlin Brown Newbie

            One more problem, nothing with the JMS, but with an (MySQL)CMP bean I get an error NoSuchMethodError, but I cant see what method is being called, it is a simple bean with one field, and the code works both in Hypersonic JBOSS setup and in the MySQL setup, but with the Mysql setup I get the exception on deplolyment. Everything works fine, I just hate strange exceptions in my log file:

            I am using the the jbosscmp.. file and nothing looks strange there. I dont have any ideas on this one?

            :39:48,809 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=org/retro/gis/system/HelloWorldCMPHome,service=EJB
            RuntimeErrorException: java.lang.NoSuchMethodError
            Cause: java.lang.NoSuchMethodError
            at org.jboss.mx.server.ReflectedDispatcher.handleInvocationExceptions(ReflectedDispatcher.java:99)
            at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:64)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:61)
            at org.jboss.mx.server.Invocation.dispatch(Invocation.java:53)
            at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
            at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:185)
            at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
            at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:837)
            at $Proxy17.start(Unknown Source)
            at org.jboss.system.ServiceController.start(ServiceController.java:367)
            at java.lang.reflect.Method.invoke(Native Method)
            at org.jboss.mx.server.ReflectedDispatcher.dispatch(Reflected
            ....
            ...
            .
            ..

            • 3. Re: MySQL error with JMS-Server
              Sathish Kumar Rathinam Newbie

              Iam getting the same error too, except that Iam connecting to Oracle8. I have a simple CMP entity bean and a session bean. But JBoss gives the same error as previous one while deploying (starting the server).

              20:49:30,284 WARN [ServiceController] Problem starting service jboss.j2ee:jndiName=ejb
              /com/test/ejb/entity/TestCMPLocalHome,service=EJB
              RuntimeErrorException: java.lang.NoSuchMethodError
              Cause: java.lang.NoSuchMethodError
              at org.jboss.mx.server.ReflectedDispatcher.handleInvocationExceptions(Reflected
              Dispatcher.java:99)
              at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:64
              )

              Any findings will be helpful

              Sathish

              • 4. Re: MySQL error with JMS-Server
                Berlin Brown Newbie

                It might be jboss is trying to use a method not in the JDBC driver, DataSource? or something, that is my guess.

                • 5. Re: MySQL error with JMS-Server
                  Sathish Kumar Rathinam Newbie

                  I managed to get rid of the error (java.lang.NoSuchMethodError...) in my simple application by moving to jdk1.4.2. It was strange that I was consistently able to reproduce the same error when I used jdk1.3.1 and deploy my application in jboss3.2.5. I had both jdks (1.3.1 and 1.4.2) installed in my machine. But initially I had JAVA_HOME and PATH pointing to jdk.13.1 when I was hitting that error. I had accidentally changed JAVA_HOME and PATH to jdk1.4.2 and the error disappeared. I did not have much time to explore more on this. My JBoss version is 3.2.5 and I had used a simple CMP bean, session bean and a servlet. Thought if this can be useful to others