JBPM6工作台使用Mysql資料庫

標籤：

前面已經安裝好jbpm了。現在進行資料庫的替換。很簡單：

1，修改 build.properties

 原：

  

# 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

改：

# 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.修改db/jbpm-persistence-JPA2.xml:

原：

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

改：

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLDialect"/>

3，修改standalone-full-wildfly-8.1.0.Final.xml
原：

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

改：

<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>    </security></datasource>

<driver name="mysql" module="com.mysql">    <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class></driver>

1，這裡要注意紅色的字型將原來的替換：

<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，注意。
  db/mysql_module.xml 要與mysql的驅動包名一直如：

<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，運行ant命令OK

官網：http://docs.jboss.org/jbpm/v6.2/userguide/jBPMInstaller.html

 

JBPM6工作台使用Mysql資料庫