lib/jbpm-human-task-war-5.4.0.Final-EE6.war/WEB-INF/classes/META-INF/persistence.xml
1.下载MySql驱动放在安装目录/db/drivers/下。这里将名字修改为mysql-connector-java.jar。
在MySql数据库中创建task和jbpm数据库。 mysql> CREATE DATEBASE IF NOT EXISTS jbpm5;
mysql> CREATE USER 'jbmp5'@'localhost' IDENTIFIED BY 'jbpm5';
mysql> GRANT ALL PRIVILEGES ON jbpm5.* TO 'jbpm5'@'localhost';mysql> CREATE DATEBASE IF NOT EXISTS task;
mysql> CREATE USER 'task'@'localhost' IDENTIFIED BY 'task';
mysql> GRANT ALL PRIVILEGES ON task.* TO 'task'@'localhost;
2.修改db/jbpm-persistence-JPA2.xml和task-persistence-JPA2.xml,修改方式类似
Xml代码 将
或
修改为
附:
Hibernate SQL Dialects (hibernate.dialect)
RDBMS Dialect
DB2
org.hibernate.dialect.DB2Dialect
DB2 AS/400
org.hibernate.dialect.DB2400Dialect
DB2 OS390
org.hibernate.dialect.DB2390Dialect
PostgreSQL
org.hibernate.dialect.PostgreSQLDialect
MySQL
org.hibernate.dialect.MySQLDialect
org.hibernate.dialect.MySQL5Dialect
MySQL with InnoDB
org.hibernate.dialect.MySQLInnoDBDialect
MySQL with MyISAM
org.hibernate.dialect.MySQLMyISAMDialect
Oracle (any version)
org.hibernate.dialect.OracleDialect
Oracle 9i
org.hibernate.dialect.Oracle9iDialect
Oracle 10g
org.hibernate.dialect.Oracle10gDialect
Sybase
org.hibernate.dialect.SybaseDialect
Sybase Anywhere
org.hibernate.dialect.SybaseAnywhereDialect
Microsoft SQL Server
org.hibernate.dialect.SQLServerDialect
SAP DB
org.hibernate.dialect.SAPDBDialect
Informix
org.hibernate.dialect.InformixDialect
HypersonicSQL
org.hibernate.dialect.HSQLDialect
Ingres
org.hibernate.dialect.IngresDialect
Progress
org.hibernate.dialect.ProgressDialect
Mckoi SQL
org.hibernate.dialect.MckoiDialect
Interbase
org.hibernate.dialect.InterbaseDialect
Pointbase
org.hibernate.dialect.PointbaseDialect
FrontBase
org.hibernate.dialect.FrontbaseDialect
Firebird
org.hibernate.dialect.FirebirdDialect 3.修改task-service/resources/META-INF/persistence.xml
Xml代码 将
修改为
4.修改db/mysql_module.xml中jar的名称为mysql.jar,与db/drivers中的jar名称对应。
Xml代码
5.使用的是Jboss7,修改安装目录下的standalone.xml
Xml代码
将
jdbc:h2:mem:test;DB_CLOSE_DELAY=-1
h2
sa
sa
jdbc:h2:~/jbpm
h2
1
4
false
false
FailingConnectionOnly
sa
SELECT 1
false
false
org.h2.jdbcx.JdbcDataSource
修改为
jdbc:h2:mem:test;DB_CLOSE_DELAY=-1
h2
sa
sa
jdbc:mysql://localhost:3306/jbpm5
mysql
1
4
false
false
FailingConnectionOnly
jbpm5
jbpm5
SELECT 1
false
false
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource
6.修改安装目录下的build.properties,将数据库的配置从H2,改为MySql
# default is H2
#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
#other options are mysql
db.name=mysql
db.driver.module.prefix=com/mysql
db.driver.jar.name=${db.name}.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
7.修改/lib/jbpm-human-task-war-5.4.0.Final-EE6.war/WEB-INF/classes/META-INF/persistence.xml文件中的
hibernate.dialect
Xml代码
8.修改/lib/jbpm-gwt-console-server-5.4.0.Final-EE6.war/
WEB-INF/classes/META-INF/persistence.xml
文件中的
hibernate.dialect和
hibernate.hbm2ddl.auto。
Xml代码
9.修改build.xml
Xml代码
在
中加
变为
根据你的实际目录修改
在
中加
10.在CMD中到你的安装目录下,运行
Java代码
ant install.demo
或
ant install.demo.noeclipse
11.运行
Java代码
ant start.human.task创建task数据库表 ,创建完成后按Ctrl+C,再按退出创建。
12.运行
Java代码
ant start.jboss启动,会创建jbpm数据库表。
启动成功后再运行
Java代码
ant stop.jboss成功关闭后修改安装目录下\jboss-as-7.1.1.Final\standalone\deployments\jbpm-gwt-console-server.war\
WEB-INF/classes/META-INF/persistence.xml
文件中的
hibernate.hbm2ddl.auto。