JBPM6 Workbench using MySQL Database

The JBPM has been installed in the front. Now replace the database. Very simple:

1, modify Build.properties

Original:

# default is H2 h2.version=1.3.168 db.name=h2 Db.driver.jar.name=${db.name}.jar db.driver.download.url=http:// repo1.maven.org/maven2/com/h2database/h2/${h2.version}/h2-${h2.version}.jar#mysql#db.name=mysql# Db.driver.module.prefix=com/mysql#db.driver.jar.name=mysql-connector-java-5.1.18.jar#db.driver.download.url= https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/ 5.1.18/mysql-connector-java-5.1.18.jar

Change:

# default is h2# h2.version=1.3.168# db.name=h2# db.driver.jar.name=${db.name}.jar# db.driver.download.url=http:// Repo1.maven.org/maven2/com/h2database/h2/${h2.version}/h2-${h2.version}.jar#mysqldb.name= Mysqldb.driver.module.prefix=com/mysqldb.driver.jar.name=mysql-connector-java-5.1.18.jardb.driver.download.url =https://repository.jboss.org/nexus/service/local/repositories/central/content/mysql/mysql-connector-java/ 5.1.18/mysql-connector-java-5.1.18.jar

2. Modification db/jbpm-persistence-JPA2.xml :

Original:

<property name= "Hibernate.dialect" value= "Org.hibernate.dialect.H2Dialect"/>

Change:

<property name= "Hibernate.dialect" value= "Org.hibernate.dialect.  MySQLdialect "/>

3, modify Standalone-full-wildfly-8.1.0.final.xml
Original:

<datasource jta= "true" Jndi-name= "Java:jboss/datasources/jbpmds" pool-name= "H2ds" enabled= "true" Use-java-context= "true" use-ccm= "true" >    <connection-url>jdbc:h2:tcp://localhost/~/jbpm-db; mvcc=true</connection-url>    <driver>h2</driver>    <security>       <user-name >sa</user-name>    </security></datasource><drivers>    <driver name= "H2" module = "Com.h2database.h2" >        <xa-datasource-class>org.h2.jdbcx.jdbcdatasource</xa-datasource-class >    </driver></drivers>

Change:

 <datasource Jta= "true" Jndi-name= "Java:jboss/datasources/jbpmds" pool-name= "  Mysqlds  "enabled=" true "use-java-context=" true "use-ccm=" true "> <connection-url>   jdbc:mysql://localhost:3306/jbpm  </connection-url> <driver>  MySQL  </driver> <security> <user-name>  JBPM  </user-name> <password>  jbpm  </password> </s Ecurity></datasource>      

 <driver name= "  MySQL " module= "  Com.mysql  > <xa-datasource-class>  Com.mysql.jdbc.jdbc2.optional.MysqlXADataSource  </xa-datasource-class></driver> 
 
    1, note that the red font replaces the original: 
 
 <default-bindings context-service= "java:jboss/ee/concurrency /context/default "datasource=" Java:jboss/datasources/jbpmds  " 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"/> 
, 2, note. 
 Db/mysql_module.xml The driver package name to be associated with MySQL has been as follows: 

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

5. Run the ant command ok

Official website: http://docs.jboss.org/jbpm/v6.2/userguide/jBPMInstaller.html

JBPM6 Workbench using MySQL Database