jBPM4.4 no JBPM DB schema:no jbpm4_execution table. Run the Create.jbpm.schema target first in the Install tool.

Start delving into the work flow of something, the first nail, notes:

Error message:

jBPM4.4 no JBPM DB schema:no jbpm4_execution table. Run the Create.jbpm.schema target first in the Install tool.

Analysis:

JBPM The Create statement error when initializing the table, as follows:

CREATE TABLE Jbpm4_deployment (

dbid_ bigint not null,

Name_ Longtext,

Timestamp_ bigint,

State_ varchar (255),

Primary KEY (DBID_)

) Type=innodb

The key is that the statement to create the table in Navicat Lite executes the SQL statement also error, TYPE=INNODB not conform to the syntax, my MySQL version is 5.5,

After the "degree Niang" found, MySQL 4.0 is not recommended to use TYPE=INNODB, recommended to use Engine=innodb, and MySQL 5.5 can only use Engine=innodb

Solution:

First of all, jbpm4.4. There are two ways to create a default table, the first of which is through the ant command in a DOS window (using the jbpm-4.4/install/src/db/create/ Jbpm.mysql.create.sql SQL statements), the other is created automatically by code, running Java code, which is created by using the default configuration in the project after you have a Java project.

The key is that the files used by the two methods are different, and it's important to recognize this.

Okay, let's talk about the solution:

Scenario 1: Modify the script in Jbpm-4.4/install/src/db/create/jbpm.mysql.create.sql.

Change one of the Type=innodb to Engine=innodb

(This method works well for creating tables with ant commands, which is why I did not succeed in creating tables in Java code before using this method)

Scenario 2: Installing MySQL Server 5.1

(The second method is more thorough, the reader recommends)

This is the method of the brother on the net, tried it by himself, or

jBPM4.4 no JBPM DB schema:no jbpm4_execution table. Run the Create.jbpm.schema target first in the Install tool.