0 Replies Latest reply on Nov 1, 2012 1:28 AM by swastik padhy

    Not able to start JBPM5.3, ant start.demo.db

    swastik padhy Newbie

      Hi,

       

         I am changing the database to MySQL. I have made the changes in db/persistence.xml,task-service/resources/META-INF/persistence.xml,db/jBPM-ds.xml,standalone.xml files,

       

      I have created 2 users (jbpm5, task) and 2 schema(jbpm5,task) in mysql.

      The istallion is successful.

       

      ant install.demo.db

       

      but when I tried to run the <b> ant install.demo.db </b>, it show Build Failed. giving the following error, Please help

       

      c:\jbpm\jbpm-installer>ant start.demo.db
      Buildfile: c:\jbpm\jbpm-installer\build.xml
      
      
      check.jboss.version:
      
      
      download.db.driver.check:
           [echo] Checking if db driver jar has been downloaded ...
      
      
      download.mysql.driver:
           [echo] Getting mysql driver jar ...
            [get] Getting: https://repository.jboss.org/nexus/service/local/repositori
      es/central/content/mysql/mysql-connector-java/5.1.18/mysql-connector-java-5.1.18
      .jar
            [get] To: c:\jbpm\jbpm-installer\db\driver\mysql-connector-java.jar
      
      
      install.db.files:
          [mkdir] Created dir: c:\jbpm\jbpm-installer\jboss-as-7.0.2.Final\modules\com
      \mysql\main
           [copy] Copying 1 file to c:\jbpm\jbpm-installer\jboss-as-7.0.2.Final\module
      s\com\mysql\main
           [copy] Copying 1 file to c:\jbpm\jbpm-installer\jboss-as-7.0.2.Final\module
      s\com\mysql\main
      
      
      start.jboss:
      
      
      check.jboss.version:
      
      
      start.jboss5:
      
      
      check.jboss.version:
      
      
      start.jboss7:
      
      
      BUILD FAILED
      c:\jbpm\jbpm-installer\build.xml:725: The following error occurred while executi
      ng this line:
      c:\jbpm\jbpm-installer\build.xml:749: JBoss AS7 did not start within 5 minutes
      
      
      Total time: 5 minutes 45 seconds
      
      
      c:\jbpm\jbpm-installer>
      
      
      
      
      

       

      • db/persistence.xml
      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
      

       

      • task-service/resources/META-INF/persistence.xml

       

      <property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>
      <property name="hibernate.connection.driver_class" value="com.mysql.jdbc.Driver"/>
      <property name="hibernate.connection.url" value="jdbc:mysql://localhost:3306/task"/>
      <property name="hibernate.connection.username" value="task"/>
      <property name="hibernate.connection.password" value="task"/>
      
      
      • db/jBPM-ds.xml

       

      <datasources>
      <local-tx-datasource>
      <jndi-name>jboss/datasources/jbpmDS</jndi-name>
      <connection-url>jdbc:mysql://localhost:3306/jbpm5</connection-url>
      <driver-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</driver-class>
      <user-name>jbpm5</user-name>
      <password>jbpm5</password>
      </local-tx-datasource>
      </datasources>
      
      
      • standalone.xml files

       

      <subsystem xmlns="urn:jboss:domain:datasources:1.0">
      <datasources>
      <datasource jndi-name="java:jboss/datasources/jbpmDS" pool-name="H2DS"
      enabled="true" use-java-context="true">
      <connection-url>jdbc:mysql://localhost:3306/jbpm5</connection-url>
      <driver>mysql</driver>
      <pool></pool>
      <security>
      <user-name>jbpm5</user-name>
      <password>jbpm5</password>
      </security>
      </datasource>
      <drivers>
      <driver name="mysql" module="com.mysql">
      <xa-datasourceclass>
      com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
      </driver>
      </drivers>
      </datasources>
      </subsystem>
      
      

       

      Thanks,

      Swastik