5 Replies Latest reply on Apr 19, 2003 3:12 PM by Dadure Arnaud

    JBoss 3.2.0 and MySQL

    sys user Master

      Hi,

      I've just installed JBoss 3.2.0 and configured to set MySQL as the default datasource.
      I have installed the mysql .jar driver, deployed the mysql-ds.xml file and configured mysql-ds.xml and standardjbosscmp-jdbc.xml files so the MySQL DDBB is the default datasource.
      When I startup the JBoss server, two errors appear (there were no error when I did it with the JBoss 3.0.0 server):

      10:38:58,651 ERROR [PersistenceManager] Starting failed
      org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: General error: Table 'negociador.JMS_MESSAGES' doesn't exist)
      at org.jboss.mq.pm.jdbc2.Persist...
      ......................................................................
      10:39:11,450 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
      Cause: Incomplete Deployment listing:
      Packages waiting for a deployer:

      Incompletely deployed packages:

      MBeans waiting for classes:

      MBeans waiting for other MBeans:
      [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
      state: CREATED
      I Depend On: jboss.mq:service=Invoker
      jboss.web:service=WebServer

      Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
      state: CREATED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager

      Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
      state: CREATED
      I Depend On: jboss.mq:service=DestinationManager
      jboss.mq:service=SecurityManager...
      ......................................................................

      It looks like it works, because a new table (JMS_TRANSACTIONS) is created.

      Any help to avoid these errors? Do I have to create a table by hand? I don't hope so.

      Thanks

        • 1. Re: JBoss 3.2.0 and MySQL
          Lyle Eckert Newbie

          I think the easiest way to deal with this is to leave the default datasource as Hypersonic SQL, and just have your application make MySQL the database to use, that is how I have it running, and I am not getting these errors, if you don't want to run it that way, perhaps the create-table being true would help. Those are my suggestions.

          Pup

          • 2. Re: JBoss 3.2.0 and MySQL
            David Jencks Master

            I think the sql supplied for the jms jdbc2 persistence manager doesn't work with mysql. Look in that mbeans config to see if you can change it to more mysql-friendly syntax. if you arent using jms, you can remove all the jms mbeans. You can also change to e.g. the file or rolling logged persistence manager.

            • 3. Re: JBoss 3.2.0 and MySQL
              Dadure Arnaud Newbie

              hi, i have the same problems, except that i just have the MBeanException at the end. Do you have resolve it ? and how ? How to remove all the JMS beans ? thx

              • 4. Re: JBoss 3.2.0 and MySQL
                Dadure Arnaud Newbie

                 

                "cubeur" wrote:
                with the help of -Wai Kim Or 01- i tried do this

                ----------------------------

                1. create mysql data base [db.name]

                2. copy mysql-connector-java-3.0.6-stable-bin.jar to [jboss.dir]/server/default/lib

                3. server/default/conf/standardjbosscmp-jdbc.xml, replace the Hyper SQL with these 2:
                <datasource>java:/MySqlDS</datasource>
                <datasource-mapping>mySQL</datasource-mapping>

                4. server/default/conf/standardjaws.xml, replace the Hyper SQL with these 2:
                <datasource>java:/MySqlDS</datasource>
                <type-mapping>mySQL</type-mapping>

                5. copy docs/examples/jca/mysql-ds.xml into /server/default/deploy

                6. update mysql-ds.xml with your MySql login/password, and use the following:
                <jndi-name>[db-jndi.name]</jndi-name>
                <connection-url>jdbc:mysql://localhost:3306/[db.name]</connection-url>

                7. restart jboss

                ----------------------------

                the jms-transactions table is created with one field and then at the end of the JBoss start...


                12:51:47,328 ERROR [URLDeploymentScanner] MBeanException: Exception in MBean operation 'checkIncompleteDeployments()'
                Cause: Incomplete Deployment listing:
                Packages waiting for a deployer:
                <none>
                Incompletely deployed packages:
                <none>
                MBeans waiting for classes:
                <none>
                MBeans waiting for other MBeans:
                [ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker
                jboss.web:service=WebServer

                Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testTopic
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager
                jboss.mq:service=SecurityManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager
                jboss.mq:service=SecurityManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager
                jboss.mq:service=SecurityManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=testQueue
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager
                jboss.mq:service=SecurityManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=A
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=B
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=C
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=D
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager

                Depends On Me: , ObjectName: jboss.mq.destination:service=Queue,name=ex
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager

                Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=JVM
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker

                Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=RMI
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker

                Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker

                Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker

                Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=OIL2
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker

                Depends On Me: , ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
                state: CONFIGURED
                I Depend On: jboss.mq:service=Invoker

                Depends On Me: , ObjectName: jboss.mq:service=Invoker
                state: CONFIGURED
                I Depend On: jboss.mq:service=TracingInterceptor

                Depends On Me: jboss.mq:service=InvocationLayer,type=HTTP
                jboss.mq:service=InvocationLayer,type=JVM
                jboss.mq:service=InvocationLayer,type=RMI
                jboss.mq:service=InvocationLayer,type=OIL
                jboss.mq:service=InvocationLayer,type=UIL
                jboss.mq:service=InvocationLayer,type=OIL2
                jboss.mq:service=InvocationLayer,type=UIL2
                , ObjectName: jboss.mq:service=TracingInterceptor
                state: CONFIGURED
                I Depend On: jboss.mq:service=SecurityManager

                Depends On Me: jboss.mq:service=Invoker
                , ObjectName: jboss.mq:service=SecurityManager
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager

                Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
                jboss.mq.destination:service=Topic,name=securedTopic
                jboss.mq.destination:service=Topic,name=testDurableTopic
                jboss.mq.destination:service=Queue,name=testQueue
                jboss.mq:service=TracingInterceptor
                jboss.mq.destination:service=Queue,name=DLQ
                , ObjectName: jboss.mq:service=DestinationManager
                state: CONFIGURED
                I Depend On: jboss.mq:service=PersistenceManager
                jboss.mq:service=StateManager

                Depends On Me: jboss.mq.destination:service=Topic,name=testTopic
                jboss.mq.destination:service=Topic,name=securedTopic
                jboss.mq.destination:service=Topic,name=testDurableTopic
                jboss.mq.destination:service=Queue,name=testQueue
                jboss.mq.destination:service=Queue,name=A
                jboss.mq.destination:service=Queue,name=B
                jboss.mq.destination:service=Queue,name=C
                jboss.mq.destination:service=Queue,name=D
                jboss.mq.destination:service=Queue,name=ex
                jboss.mq:service=SecurityManager
                jboss.mq.destination:service=Queue,name=DLQ
                , ObjectName: jboss.mq:service=PersistenceManager
                state: CONFIGURED
                I Depend On: jboss.mq:service=MessageCache
                jboss.jca:service=LocalTxCM,name=DefaultDS

                Depends On Me: jboss.mq:service=DestinationManager
                , ObjectName: jboss.mq.destination:service=Queue,name=DLQ
                state: CONFIGURED
                I Depend On: jboss.mq:service=DestinationManager
                jboss.mq:service=SecurityManager

                Depends On Me: ]
                12:51:47,343 INFO [URLDeploymentScanner] Started
                12:51:47,390 INFO [MainDeployer] Deployed package: file:/C:/jboss/server/default/conf/jboss-service.xml
                12:51:47,390 INFO [Server] JBoss (MX MicroKernel) [3.2.0 (build: CVSTag=JBoss_3_2_0 date=200304110033)] Started in 19s:594ms





                is someone have a solution ?


                • 5. Re: JBoss 3.2.0 and MySQL
                  Dadure Arnaud Newbie

                  look at the solution on another topic of this day :)