Datasource added in jBoss but not the device

[2me95]

I have jBoss7.1.1 and MySQL 5.5 , I installed MySQLConnector 5.1.47 and I followed this link database module in jboss 7.1 - theJavaGeek but as a result dataressource is added and the driver not .

I guess the problem is caused by the placement of adding subsystem because I have not subsystems to put under it so this is the part modified:

  <subsystem xmlns="urn:jboss:domain:configadmin:1.0"/>

        <subsystem xmlns="urn:jboss:domain:datasources:1.0">

            <datasources>

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

                    <connection-url>jdbc:h2:mem:test;DB_CLOSE_DELAY=-1</connection-url>

                    <driver>h2</driver>

                    <security>

                        <user-name>sa</user-name>

                        <password>sa</password>

                    </security>

                </datasource>

      <datasource  jndi-name="java:/jBossMysql" pool-name="jBossMysql" enabled="true" use-ccm="false">

      <connection-url>jdbc:mysql://localhost:3306/tutorialsDB</connection-url>

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

      <driver>mysql</driver>

      <security>

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

          <password>root</password>

      </security>

      <validation>

          <validate-on-match>false</validate-on-match>

          <background-validation>false</background-validation>

      </validation>

      <statement>

          <share-prepared-statements>false</share-prepared-statements>

      </statement>

      </datasource>

                <drivers>

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

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

                    </driver>

                </drivers>

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

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

                     </driver>

            </datasources>

        </subsystem>

        <subsystem xmlns="urn:jboss:domain:jpa:1.0">

            <jpa default-datasource="java:/jBossMysql"/>

</subsystem>

[jayshree]

Hi,

I can see you have configured the "mysql" driver outside the <drivers> tag, try adding it under <drivers> tag like below:

~~~

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

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

                     </driver>

                </drivers>         

            </datasources>

~~~