3 Replies Latest reply on Jul 6, 2013 6:14 PM by Marco Tenti

    unable to connect with service jboss.jdbc-driver.mysql

    Marco Tenti Newbie

      I wan to to start a JBoss 7.1 Runtime Server with jboss-as-7.1.1.Final with eclipse.  i think the problem is in these file i put with this discussion standalone.xml, module.xml , persistence.xml or in the path i use for them.

      **************************************************************************************************************************************************************************************************************************************

      .....................................................................................................................................................................................................

      19:07:29,415 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

      JBAS014775:    New missing/unsatisfied dependencies:

            service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/dsTR]

       

      19:07:29,867 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

      19:07:29,869 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 22227ms - Started 134 of 212 services (2 services failed or missing dependencies, 74 services are passive or on-demand)

      ********************************************************************************************************************************************************

      The server Run "Admin console listening on http://127.0.0.1:9990" but not create my table on the mysql database "service jboss.jdbc-driver.mysql (missing)".

      The path of my standalone.xml is :jboss-as-7.1.1.Final\standalone\configuration

      The path of my module.xml is: jboss-as-7.1.1.Final\modules\com\mysqldatabase\mysql\main  ---------    in the main there are my module.xml and mysql-connector-java-5.1.25-bin.jar

                                     

      *********************standalone.xml****************************

      **********************************************************************************************************************************************************************

      ................

      <datasources>

      <!-- this is MY datasources i want to use -->

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

                     <connection-url>jdbc:mysql://127.0.0.1:3306/DB_TRANSPORT</connection-url>

                         <driver>mysql</driver>

                         <security>

                            <user-name>root</user-name>

                            <password></password>

                         </security>

                </datasource>

      <!-- thi is MY driver -->

                <drivers>

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

                         <xa-datasource-class>com.mysql.jdbc.Driver</xa-datasource-class>

                   </driver>

                </drivers>

      </datasources>

      .................................

      *********************************************************************************************************************************************+

      *********module.xml**********************************************************************************************************************

      *********persistence.xml******************************************************************************************************************

        • 1. Re: unable to connect with service jboss.jdbc-driver.mysql
          Wolf-Dieter Fink Master

          Look like you have the wrong module configuration.

          module.xml  => com.mysql.jdbc

          then you should use the same module identifier in the drivers section of the datasource (instead of com.mysqldatabase.....)

          the drive and muldule xml store in $JBOSS__HOME/modules/com/mysql/jdbc/main

           

          That should work

          • 2. Re: unable to connect with service jboss.jdbc-driver.mysql
            Marco Tenti Newbie

            ty very much for the  fast response, but the problem persist.

            *******************************************************************************************************************************************************+

            .......................................................................................................................................................................................

            20:14:35,534 INFO  [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report

            JBAS014775:    New missing/unsatisfied dependencies:

                  service jboss.jdbc-driver.mysql (missing) dependents: [service jboss.data-source.java:jboss/datasources/dsTR]

            20:14:36,347 INFO  [org.jboss.as] (Controller Boot Thread) JBAS015951: Admin console listening on http://127.0.0.1:9990

            20:14:36,350 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: JBoss AS 7.1.1.Final "Brontes" started (with errors) in 13900ms - Started 134 of 212 services (2 services failed or missing dependencies, 74 services are passive or on-demand)

            *********************************************************************************************************************************************************************+

            The path of my standalone.xml is :jboss-as-7.1.1.Final/standalone/configuration

            The path of my module.xml is: jboss-as-7.1.1.Final/modules/com/mysql/jdbc/main  ---------    in the main there are my module.xml and mysql-connector-java-5.1.25-bin.jar

            ****************************************************************************************************************************************************************************************************************************

            Other ideas?

            • 3. Re: unable to connect with service jboss.jdbc-driver.mysql
              Marco Tenti Newbie

              K i found the solution , for everyone have the same problem go to

                                                                                                                    https://zorq.net/b/2011/07/12/adding-a-mysql-datasource-to-jboss-as-7/

              is very helpful.