5 Replies Latest reply on Aug 23, 2013 7:30 AM by wdfink

    Fedora vs Windows 7 MySql Driver

    paularber

      I am running jobss eap 6.1, and develop on my desktop and would like to have a server where I install checkpoint relases.  The desktop runs Windows 7, Jboss eap 6.1 and has a MySql datasource configured to use MySql on a remote server, all is working well.  I installed Jboss eap 6.1 on Fedora 19 and attempted to configure the same MySql datasource but when I start Jboss I get:

       

      12:40:00,555 ERROR [org.jboss.as.controller.management-operation] (ServerService Thread Pool -- 31) JBAS014613: Operation ("add") failed - address: ([

          ("subsystem" => "datasources"),

          ("jdbc-driver" => "mysql")

      ]) - failure description: "JBAS010441: Failed to load module for driver [com.mysql]"

       

      On both systems I installed MySql jdbc driver as a module  in JBOSS/module/com/mysql/main.  I have the same module.xml and the same <driver> definitions but on Fedora I get the above error.  I have searched the net for similar issues, searched my definitions for any differences in the deployment and I have not found any solution. Has anyone come across this problem?

       

      standalone-full.xml

                     ...

                      <datasource jndi-name="java:jboss/datasources/myDS" pool-name="myDS" enabled="true" use-java-context="true">

                         <connection-url>jdbc:mysql://192.168.1.201:3306/jboss</connection-url>

                         <driver>mysql</driver>

                         <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                         <pool>

                              <min-pool-size>2</min-pool-size>

                              <max-pool-size>10</max-pool-size>

                         </pool>

                         <security>

                              <user-name>jboss</user-name>

                              <password>jboss</password>

                         </security>

                         <statement>

                              <prepared-statement-cache-size>100</prepared-statement-cache-size>

                              <share-prepared-statements/>

                         </statement>

                      </datasource>

                      <drivers>

                          <driver name="h2" module="com.h2database.h2">

                              <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>

                          </driver>

                          <driver name="mysql" module="com.mysql">

                              <driver-class>com.mysql.jdbc.Driver</driver-class>

                          </driver>

                      </drivers>

                     ...

       

      module.xml

       

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

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

                 <resources>       

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

                </resources>    

           <dependencies>       

                 <module name="javax.api"/>        

                <module name="javax.transaction.api"/>   

           </dependencies>

            </module>