7 Replies Latest reply on Jan 16, 2007 1:57 PM by vvd

    Make Messaging server talk to MySQL DB

    vvd

      I followed installation instructions and copied the MySQL persistance file from example/config directory to "server/standalone-messaging/deploy/jboss-messaging".

      I noticed that "server/standalone-messaging/deploy" directory, I need to have a file similar to "hsqldb-ds.xml", where I mentioned the port #, where the mySQL is running.

      Does anyone have an example of the above file for mySQL?

      Thanks in advance

        • 1. Re: Make Messaging server talk to MySQL DB
          peterj

          An example mysql-ds.xml file can be found in the app server at ./docs/examples/jca/mysql-ds.xml.

          • 2. Re: Make Messaging server talk to MySQL DB
            vvd

             

            "PeterJ" wrote:
            An example mysql-ds.xml file can be found in the app server at ./docs/examples/jca/mysql-ds.xml.


            thanks.

            • 3. Re: Make Messaging server talk to MySQL DB
              vvd

              after copying the mysql related file in the respective directories
              ie. mysql-persistence-service.xml into <jboss-installdir>/server/standalone-messaging/deploy/jboss-messaging

              and mysql-ds.xml into <jboss-installdir>/server/standalone-messaging/deploy directory.

              Only common change I made was to change the from 'DefaultDS' to 'msgq'.

              In 'mysql-ds.xml' file I mentioned the machine and port, userid and password.

              when I start the server I see the following error outputed to screen
              13:32:20,213 INFO [Catalina] Server startup in 212 ms
              13:32:20,341 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
              13:32:20,782 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
              13:32:21,781 INFO [TomcatDeployer] deploy, ctxPath=/web-console, warUrl=.../deploy/management/console-mgr.sar/web-console.war/
              13:32:22,223 INFO [[/web-console]] J2EEFolder: Failed to init plugin, bsh/Interpreter
              13:32:22,236 INFO [[/web-console]] SystemFolder: Failed to init plugin, bsh/Interpreter
              13:32:22,656 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
              13:32:22,971 INFO [WrapperDataSourceService] Bound ConnectionManager 'jboss.jca:name=msgq,service=DataSourceBinding' to JNDI name 'java:msgq'
              13:32:23,019 WARN [JBossManagedConnectionPool] Throwable while attempting to get a new connection: null
              org.jboss.resource.JBossResourceException: Could not create connection; - nested throwable: (org.jboss.resource.JBossResourceException: Failed to register driver for: com.mysql.jdbc.Driver; - nested throwable: (java.lang.ClassNotFoundException: No ClassLoaders found for: com.mysql.jdbc.Driver))
              at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)

              • 4. Re: Make Messaging server talk to MySQL DB
                peterj

                Did yo ucopy the JDBC jatr file to server/standalone-messaging/lib?

                • 5. Re: Make Messaging server talk to MySQL DB
                  vvd

                  Thanks for the response.

                  I did find the below file in the path you have mentioned.

                  "/server/standalone-messaging/lib/jboss-common-jdbc-wrapper.jar"

                  if above is not the correct file, please let me know which file I need to copy

                  and let me know where I can find the file also.

                  Thanks,

                  • 6. Re: Make Messaging server talk to MySQL DB
                    peterj

                    That is not the JDBC jar file. You have to get it from your database vendor.

                    • 7. Re: Make Messaging server talk to MySQL DB
                      vvd

                      Thanks for all the help.

                      1. downloaded the mysql-connector-java-5.0.4-bin.jar from MySQL connector tar file and copied into 'server/standalone-messaging/lib'

                      2. Edited the mysql-ds.xml file to update the JNDI name

                      3. updated the mysql-persistence-service.xml file with above JNDI name as mentioned in the documentation .

                      4. brought the server up and it now talks to the MySQL DB.