0 Replies Latest reply on Mar 21, 2019 6:24 AM by 2me PPA

    Datasource added in jBoss but not the driver

    2me PPA Newbie

      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:

        <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  jta="false" jndi-name="java:/mysql" pool-name="MySQLDS" enabled="true" use-ccm="false">

            <connection-url>jdbc:mysql://localhost:3306/learning</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">

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

                           </driver>

                  </datasources>