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

[tenti88]

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******************************************************************************************************************

[wdfink]

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

[tenti88]

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?

[tenti88]

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.