错误信息:
jBPM4.4 no jBPM DB schema: no JBPM4_EXECUTION table. Run the create.jbpm.schema target first in the install tool.
解析:
JBPM初始化建树表格时create语句错误,如下:
create table JBPM4_DEPLOYMENT (
DBID_ bigint not null,
NAME_ longtext,
TIMESTAMP_ bigint,
STATE_ varchar(255),
primary key (DBID_)
) type=InnoDB
关键在于这个创建表格的语句在Navicat Lite中履行该条SQL语句也同样报错,type=InnoDB不合适语法,我的mysql版本是5.5的,
经"度娘"之后发明,MySQL 4.0开端不建议应用type=InnoDB,建议应用Engine=InnoDB,而MySQL 5.5只能用Engine=InnoDB
解决规划:
1.批改jbpm-4.4/install/src/db/create/jbpm.mysql.create.sql中的脚本
2.安装MySQL Server 5.1
还是换了mysql的版本,选择了后者,前者吧不大好把握,我试了试不好使,建表语句没有改变,还是后者来得兴奋.........