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

Source: Internet
Author: User
Tags mysql version jbpm

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.