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.

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