jbpm4 mysql_JBPM4在mysql上建表

1、确认ANT安装成功

2、.建数据库，我的是jbpm

3、进入jbpm4.0在jbpm-4.0\db目录下：

l更改build.xml .找到line:9改为：原来的

l更改jdbc/mysql.properties改成你自己的连接URL、用户名、密码

4、执行cmd命令：然后在对应的目录下(即jbpm4.0\db)执行：ant create.jbpm.schema

执行过程中如果出现如下错误：

Unable to locate tools.jar. Expected to find it in C:\Program Files\Oracle\jre\1

.3.1\lib\tools.jar

Buildfile: build.xml

log.properties:

[echo] database....... mysql

[echo] jdbc.driver.... com.mysql.jdbc.Driver

[echo] jdbc.url.......jdbc:mysql://localhost:3306/jbpmdb

[echo] jdbc.username.. root

[echo] jbpm.home...... ../../jbpm-4.0

create.jbpm.schema:

BUILD FAILED

java.lang.NoClassDefFoundError: java/sql/Savepoint

at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java

:285)

at org.apache.tools.ant.taskdefs.JDBCTask.getConnection(JDBCTask.java:31

9)

at org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:429)

at org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:288)

at java.lang.reflect.Method.invoke(Native Method)

at org.apache.tools.ant.dispatch.DispatchUtils.execute(DispatchUtils.jav

a:106)

at org.apache.tools.ant.Task.perform(Task.java:348)

at org.apache.tools.ant.Target.execute(Target.java:357)

at org.apache.tools.ant.Target.performTasks(Target.java:385)

at org.apache.tools.ant.Project.executeSortedTargets(Project.java:1337)

at org.apache.tools.ant.Project.executeTarget(Project.java:1306)

at org.apache.tools.ant.helper.DefaultExecutor.executeTargets(DefaultExe

cutor.java:41)

at org.apache.tools.ant.Project.executeTargets(Project.java:1189)

at org.apache.tools.ant.Main.runBuild(Main.java:758)

at org.apache.tools.ant.Main.startAnt(Main.java:217)

at org.apache.tools.ant.launch.Launcher.run(Launcher.java:257)

at org.apache.tools.ant.launch.Launcher.main(Launcher.java:104)

Total time: 1 second

解决方法：

由于mysql版本太高，我用的mysql-connector-java-3.1.7-bin.jar改为mysql-connector-java-3.0.17-ga-bin.jar(下载地址：。哎！终于松了一口气。打开数据库，共有17个表。

注：有一个更省事的方法，根本不用使用ANT命令，在jbpm-4.0\db\schema.scripts目录下有主要数据库的建表语句，直接用工具导入就行了。