0 Replies Latest reply on Sep 10, 2014 11:55 AM by antonio.giambanco

    Configuring Wildfly8 and mysql

    antonio.giambanco

      Hi all,

      I have a problem with the configuration of wildfly and mysql in the standalone.xml.

      I read many guide on google but there isn't any answer to my question, the point is as follow:

       

      from standalone.xml


      <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;DB_CLOSE_ON_EXIT=FALSE</connection-url>

                          <driver>h2</driver>

                          <security>

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

                              <password>sa</password>

                          </security>

                      </datasource>

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

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

                         <driver>mysql</driver>

                         <pool />

                         <security>

                             <user-name>jbpm</user-name>

                             <password>jbpm</password>

                         </security>

                     </datasource>

                     <drivers>

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

                             <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>

                         </driver>

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

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

                          </driver>

                      </drivers>

      </datasources>

          .

          .

          .<!--some line below-->

          .

          .

      <default-bindings context-service="java:jboss/ee/concurrency/context/default" datasource="java:jboss/datasources/ExampleDS" jms-connection-factory="java:jboss/DefaultJMSConnectionFactory" managed-executor-service="java:jboss/ee/concurrency/executor/default" managed-scheduled-executor-service="java:jboss/ee/concurrency/scheduler/default" managed-thread-factory="java:jboss/ee/concurrency/factory/default"/>

       

       

      The default bindings line referes to the ExampleDS datasources that is a h2 DB but I would like to use my mysql DB, how can I get it configured in the right way?