2 Replies Latest reply on May 23, 2013 12:02 PM by Brenden Towey

    JBOSS & MySql module, install error.

    Brenden Towey Newbie

      Hi all, I'm getting an error installing a MySql driver with JBOSS 7.  I've done some searches and I see a lot of other folks confused too, so maybe I can ask some questions and clear things up.

       

      The error is:

       

      JBAS014775:New missing/unsatisfied dependencies:
        service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:/simpletth]

       

      I'm using JBoss 7.1.1, Final:

       

      [ec2-user@domU-12-31-39-0A-A0-29 ~]$ ls jboss*

      jboss-as-7.1.1.Final.tar.gz

       

      I installed the driver as a module:

       

      [jboss@domU-12-31-39-0A-A0-29 main]$ ls

      module.xml  mysql-connector-java-5.1.22-bin.jar

      [jboss@domU-12-31-39-0A-A0-29 main]$ pwd

      /usr/share/jboss-as/modules/com/mysql/main

      [jboss@domU-12-31-39-0A-A0-29 main]$

       

      Here's the module.xml file listing:

       

      [jboss@domU-12-31-39-0A-A0-29 main]$ cat module.xml

      <?xml version="1.0" encoding="UTF-8"?>

       

      <module xmlns="urn:jboss:module:1.0" name="com.mysql">

        <resources>

            <resource-root path="mysql-connector-java-5.1.22.jar"/>

        </resources>

        <dependencies>

            <module name="javax.api"/>

        </dependencies>

      </module>

       

      Here's the datasources from standalone/configuration/standalone.xml:

       

              <datasources>
                  <datasource jta="true" jndi-name="java:/simpletth" pool-name="simpletthPool" enabled="true" use-java-context="true">
                      <connection-url>jdbc:mysql://localhost/simpletth</connection-url>
                      <driver>mysql</driver>
                      <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                      <security>
                          <user-name>tthuser</user-name>
                          <password>XXXxxx</password>
                      </security>
                      <validation>
                          <check-valid-connection-sql>select 1</check-valid-connection-sql>
                          <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter"/>
                      </validation>
                      <statement>
                          <prepared-statement-cache-size>10</prepared-statement-cache-size>
                          <share-prepared-statements>true</share-prepared-statements>
                      </statement>
                  </datasource>

       

      And the relevent driver section:

       

                  <drivers>
                      <driver name="mysql" module="com.mysql">
                          <xa-datasource-class>com.mysql.jdbc.Driver</xa-datasource-class>
                      </driver>

       

      So I'm kinda stuck, since I think I followed the directions exactly.  Does anyone have any ideas?  I'm pretty stumped.  The error message is fairly usless, it seems to indicate anything could be wrong,and that gives me a lot to try to sort through.

       

      Does anyone know what the xa-datasource-class tag does btw?  That one see pretty confusing in the docs.

        • 1. Re: JBOSS & MySql module, install error.
          Wolf-Dieter Fink Master

          You should look to problems before that JBAS0014775.

           

          If I'm right the problem is the module installation:

          [jboss@domU-12-31-39-0A-A0-29 main]$ ls

          module.xml  mysql-connector-java-5.1.22-bin.jar

          [jboss@domU-12-31-39-0A-A0-29 main]$ pwd

          /usr/share/jboss-as/modules/com/mysql/main

          [jboss@domU-12-31-39-0A-A0-29 main]$

           

          Here's the module.xml file listing:

           

          [jboss@domU-12-31-39-0A-A0-29 main]$ cat module.xml

          <?xml version="1.0" encoding="UTF-8"?>

           

          <module xmlns="urn:jboss:module:1.0" name="com.mysql">

            <resources>

                <resource-root path="mysql-connector-java-5.1.22.jar"/>

            </resources>

            <dependencies>

                <module name="javax.api"/>

            </dependencies>

          </module>

           

          The file name is mysql-connector-java-5.1.22-bin.jar from your ls but if I look to the module.xml the filename is different.

          • 2. Re: JBOSS & MySql module, install error.
            Brenden Towey Newbie

            Sorry, got busy with other stuff and couldn't get back to this right away.

             

            That's for pointing that out, I was totally missing that misspelling.  I haven't had a chance to try this yet, but I'm sure you've located a real problem, so I'll mark this question as answered.  Thanks again!

             

            I'm curious -- why do you say "look for other errors?"  I have a simple install that I'm adding features to slowly, so there's not much in the boot log, and I'm sure this is the only error message being reported.  Is there a better place to look for errors? 

             

            I'll try to post the existing error log, if needed, so folks can point out what I may have missed.