1 Reply Latest reply on Jun 8, 2017 2:48 AM by Abhijit Humbe

    bpm-installer uses an H2 database for persisting runtime data by changing this data to MYSQL

    Pallavi Akhouri Newbie

      Hi Team ,

       

      I have installed jbpm-6.3.0.Final-installer-full and started working with this . After that i want to convert H2 data base confiration to MYSQL data base .

       

      i am getting below error :

       

       

      ("data-source" => "MySQLDS")

      ]) - failure description: {

          "JBAS014771: Services with missing/unavailable dependencies" => [

      "jboss.data-source.java:jboss/datasources/jbpmDS is missing [jboss.jdbc-driver.mysql]",

      "jboss.driver-demander.java:jboss/datasources/jbpmDS is missing [jboss.jdbc-driver.mysql]"

          ],

          "JBAS014879: One or more services were unable to start due to one or more indirect dependencies not being available." => {

              "Services that were unable to start:" => [

      "jboss.data-source.reference-factory.MySQLDS",

      "jboss.naming.context.java.jboss.datasources.jbpmDS"

              ],

              "Services that may be the cause:" => ["jboss.jdbc-driver.mysql"]

          }

      }

       

      Done configuration in standalone.xml file

       

        <datasources>

                        <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></pool>

                      <security>

                <user-name>root</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>

                  </drivers>

                  </datasources>

       

      Also changed module.xml

       

      <module xmlns="urn:jboss:module:1.0" name="com.mysql">

         <resources>

           <resource-root path="mysql-connector-java-5.1.18.jar"/>

         </resources>

       

       

         <dependencies>

            <module name="javax.api"/>

            <module name="javax.transaction.api"/>

          </dependencies>

      </module>

       

      Request you to help me out to configure MYSQL .

      Thanks in Advance .

       

      Regards,

       

      Pallavi .