[java] 12:23:49,484 INF | [DbHelper] --- Executing DB Commands -------------------------
[java] 12:23:49,484 INF | [DbHelper] create table JBPM4_DEPLOYMENT (
[java] DBID_ bigint not null,
[java] NAME_ longtext,
[java] TIMESTAMP_ bigint,
[java] STATE_ varchar(255),
[java] primary key (DBID_)
[java] ) type=InnoDB
[java] 12:23:49,562 WRN | [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
[java] 12:23:49,484 INF | [DbHelper] create table JBPM4_DEPLOYMENT (
[java] DBID_ bigint not null,
[java] NAME_ longtext,
[java] TIMESTAMP_ bigint,
[java] STATE_ varchar(255),
[java] primary key (DBID_)
[java] ) type=InnoDB
[java] 12:23:49,562 WRN | [JDBCExceptionReporter] SQL Error: 1064, SQLState: 42000
[java] 12:23:49,562 SEV | [JDBCExceptionReporter] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'type=InnoDB' at line 7
解决方案
MySQL 4.0开始不建议使用type=InnoDB,建议使用Engine=InnoDB,而MySQL 5.5之后默认的引擎就是innoDB,所以,去掉也行,或者只能用Engine=InnoDB
解决方案:
1.修改jbpm-4.4/install/src/db/create/jbpm.mysql.create.sql中的脚本
2.安装MySQL Server 5.5以后的高版本