jBPM学习（一）----环境搭建

初次接触jbpm，  下面是一些自己总结的东西，希望对大家有用，部分内容参考了网上的资料。

一、 搭建环境

1.         下载解压

我们从JBOSS的官方网站上下载jboss-4.0.3SP1.zip和jbpm-starters-kit-3.1.4.zip两个文件，将两个文件分别进行解压缩。解压后我们得到jboss-4.0.3SP1和jbpm-starters-kit-3.1.4两个文件夹。这里我分别将这两个文件夹存放在D盘根目录下（可根据个儿情况而定）。

2.         建立eclipse工程

展开jbpm-starters-kit-3.1.4目录我们可以看到如下结构：

l         jbpm jBPM 的软件包

l         jbpm-bpel 只含有一个网页

l         jbpm-db 各种数据库 hibernate 配置文件示例，有些还包含了相应的 jdbc 驱动程序。

l         jbpm-designer 辅助开发 jBPM 的 Eclipse 插件，具体在 jbpm-gpd-feature 子目录中。

l         bpm-server 　一个已经配置好了的基于 JBoss 的 jBPM 示例

 

我们将jbpm目录改名为jbpm.3，这样做是为了减少配置文件的改写。并将jbpm.3文件夹拷贝一份到你的eclipse工作目录中，在eclipse中新建一个java project并命名为jbpm.3，点击完成后会将jbpm.3中文件自动导入工程。展开工程，结构如下图：

3.         修改配置文件

在eclipse中打开jbpm.3/build.properties文件，根据个人情况修改相关属性并保存，下面是我的配置文件，仅供参考：

# jbpm.version only used for creating javadocs and the distribution package

jbpm.version = 3.1.4

 

# ant.home is only used in the ant.install.libs target for copying the junit and clover libs

ant.home = C:/Program Files/Apache Software Foundation/apache-ant-1.7.0

 

# jbpm.home is only to allow build scripts to open the browser with the html test results

这里是我们在第二步中所建立的文件夹，此文件夹提供我们开发 jbpm 所需要的环境

jbpm.home = D:/jbpm-starters-kit-3.1.4/jbpm.3

 

# jboss config proper only used for deployment

同样这是我们刚才解压后的 jboss 根目录

jboss.home = D:/jboss-4.0.3SP1

jboss.version = 4.0.x

jboss.source.configuration = default

 

4.         部署jbpm到jboss

在eclipse中打开ant视图，将工程根目录下的build.deploy.xml拖入其中，如下图：

双击create.jbpm.configuration[default]，在jboss中自动部署jbpm，观察console信息，成功后我们展开{jboss_home}/server目录会发现多了一个名为jbpm的目录，此目录即为我们自动部署完成后生成的目录。

5.         在eclipse中配置jboss服务器

点击eclipse工具栏window->perferences，找到JBoss 4.x配置项，如下图：

在server name项中填入jbpm，即为我们在{jboss_home}/server中所生成的目录名。配置完成后点击OK键，至此配置完成。

6.         测试

配置完成后，通过eclipse启动jboss服务器，注意观察控制台信息。启动成功后打开IE在地址栏中输入http://localhost:8080/jbpm ，若观察到如下结果，恭喜你，说明jbpm基本环节搭建成功。

注：我们也可以通过命令行，进入 {jboss_home}/bin 运行 run.bat –c jbpm 命令启动 jboss 服务器。

评论

10 楼 aa00aa00 2011-02-28  

正想学习JPBM工作流,看了您的文章,受益菲浅,谢谢了!!

9 楼 zoutuo 2009-06-19  

gyc567 写道

我按照这样的步骤后，发生这样的异常：

Caused by: java.sql.SQLException: Table not found in statement
[select top ? timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]

请问怎么解决啊？

你那个没有表吧！

8 楼 radysjx 2008-11-14  

按照上述，在run -c jbpm出现以下错误：
20:13:42,582 DEBUG [SchedulerThread] checking for timers
20:13:42,592 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
20:13:42,602 ERROR [JDBCExceptionReporter] Table not found in statement [select
top ? timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_
is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
20:13:42,612 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarExceptio
n: could not execute query using iterate
20:13:42,612 DEBUG [JbpmContext] closing JbpmContext
20:13:42,632 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
20:13:42,632 ERROR [JDBCExceptionReporter] Table not found in statement [select
message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATIO
N_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
20:13:42,642 DEBUG [CommandExecutorThread] command 'null' threw exception. rolli
ng back transaction
org.hibernate.exception.SQLGrammarException: could not execute query using itera
te
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
        at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl
.java:308)
        at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
        at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
        at org.jbpm.db.MessagingSession.getMessageIterator(MessagingSession.java
:119)
        at org.jbpm.db.MessagingSession.nextMessage(MessagingSession.java:71)
        at org.jbpm.msg.db.DbMessageService.receiveNoWait(DbMessageService.java:
75)
        at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExec
utorThread.java:129)
        at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.
java:83)
Caused by: java.sql.SQLException: Table not found in statement [select message0_
.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and
message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:312)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:172)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:439)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:366)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:105)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
        ... 8 more
20:13:42,782 DEBUG [JbpmContext] closing JbpmContext
20:13:42,782 DEBUG [Services] closing service 'persistence': org.jbpm.persistenc
e.db.DbPersistenceService@9ed5d6
20:13:42,792 DEBUG [DbPersistenceService] rolling back hibernate transaction
20:13:42,792 DEBUG [DbPersistenceService] closing hibernate session
20:13:42,792 DEBUG [Services] closing service 'message': org.jbpm.msg.db.DbMessa
geService@1e91485
20:13:42,802 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarExc
eption: could not execute query using iterate
20:13:42,812 DEBUG [Services] closing service 'persistence': org.jbpm.persistenc
e.db.DbPersistenceService@1423820
20:13:42,822 DEBUG [DbPersistenceService] committing hibernate transaction
20:13:42,822 DEBUG [DbPersistenceService] closing hibernate session
20:13:42,822 INFO  [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
        at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:99)
        at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:107)
        at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:71)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
using iterate
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
        at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl
.java:308)
        at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
        at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
        at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:93)
        ... 2 more
Caused by: java.sql.SQLException: Table not found in statement [select top ? tim
er0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null)
and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:312)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:172)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:439)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:366)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:105)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
        ... 6 more
20:13:47,819 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[message, scheduler, logging, persistence, authentication]'
20:13:50,703 DEBUG [JbpmContext] creating JbpmContext
20:13:50,703 DEBUG [DbPersistenceServiceFactory] creating persistence service
20:13:50,703 DEBUG [DbPersistenceService] creating hibernate session
20:13:50,713 DEBUG [DbPersistenceService] beginning hibernate transaction
20:13:50,713 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
20:13:50,723 ERROR [JDBCExceptionReporter] Table not found in statement [select
message0_.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATIO
N_=? and message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
20:13:50,733 DEBUG [CommandExecutorThread] command 'null' threw exception. rolli
ng back transaction
org.hibernate.exception.SQLGrammarException: could not execute query using itera
te
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
        at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl
.java:308)
        at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
        at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
        at org.jbpm.db.MessagingSession.getMessageIterator(MessagingSession.java
:119)
        at org.jbpm.db.MessagingSession.nextMessage(MessagingSession.java:71)
        at org.jbpm.msg.db.DbMessageService.receiveNoWait(DbMessageService.java:
75)
        at org.jbpm.msg.command.CommandExecutorThread.executeCommand(CommandExec
utorThread.java:129)
        at org.jbpm.msg.command.CommandExecutorThread.run(CommandExecutorThread.
java:83)
Caused by: java.sql.SQLException: Table not found in statement [select message0_
.ID_ as col_0_0_ from JBPM_MESSAGE message0_ where message0_.DESTINATION_=? and
message0_.ISSUSPENDED_<>1 and (message0_.EXCEPTION_ is null)]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:312)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:172)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:439)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:366)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:105)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
        ... 8 more
20:13:50,883 DEBUG [JbpmContext] closing JbpmContext
20:13:50,883 DEBUG [Services] closing service 'persistence': org.jbpm.persistenc
e.db.DbPersistenceService@18b5a73
20:13:50,893 DEBUG [DbPersistenceService] rolling back hibernate transaction
20:13:50,904 DEBUG [DbPersistenceService] closing hibernate session
20:13:50,904 DEBUG [Services] closing service 'message': org.jbpm.msg.db.DbMessa
geService@1df59bd
20:13:50,914 ERROR [CommandExecutorThread] org.hibernate.exception.SQLGrammarExc
eption: could not execute query using iterate
20:13:50,914 DEBUG [JbpmContextInfo] creating jbpm context with service factorie
s '[message, scheduler, logging, persistence, authentication]'
20:13:50,924 DEBUG [JbpmContext] creating JbpmContext
20:13:50,934 DEBUG [DbPersistenceServiceFactory] creating persistence service
20:13:50,934 DEBUG [DbPersistenceService] creating hibernate session
20:13:50,934 DEBUG [DbPersistenceService] beginning hibernate transaction
20:13:50,944 DEBUG [SchedulerThread] checking for timers
20:13:50,944 WARN  [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
20:13:50,954 ERROR [JDBCExceptionReporter] Table not found in statement [select
top ? timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_
is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
20:13:50,964 ERROR [SchedulerSession] org.hibernate.exception.SQLGrammarExceptio
n: could not execute query using iterate
20:13:50,974 DEBUG [JbpmContext] closing JbpmContext
20:13:50,974 DEBUG [Services] closing service 'persistence': org.jbpm.persistenc
e.db.DbPersistenceService@1abfbdc
20:13:50,994 DEBUG [DbPersistenceService] committing hibernate transaction
20:13:50,994 DEBUG [DbPersistenceService] closing hibernate session
20:13:51,004 INFO  [SchedulerThread] runtime exception while executing timers
org.jbpm.JbpmException: couldn't find timers from the database
        at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:99)
        at org.jbpm.scheduler.impl.SchedulerThread.executeTimers(SchedulerThread
.java:107)
        at org.jbpm.scheduler.impl.SchedulerThread.run(SchedulerThread.java:71)
Caused by: org.hibernate.exception.SQLGrammarException: could not execute query
using iterate
        at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
        at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:406)
        at org.hibernate.hql.ast.QueryTranslatorImpl.iterate(QueryTranslatorImpl
.java:308)
        at org.hibernate.impl.SessionImpl.iterate(SessionImpl.java:1111)
        at org.hibernate.impl.QueryImpl.iterate(QueryImpl.java:41)
        at org.jbpm.db.SchedulerSession.findTimersByDueDate(SchedulerSession.jav
a:93)
        ... 2 more
Caused by: java.sql.SQLException: Table not found in statement [select top ? tim
er0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null)
and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]
        at org.hsqldb.jdbc.Util.throwError(Unknown Source)
        at org.hsqldb.jdbc.jdbcPreparedStatement.<init>(Unknown Source)
        at org.hsqldb.jdbc.jdbcConnection.prepareStatement(Unknown Source)
        at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.prepareS
tatement(BaseWrapperManagedConnection.java:312)
        at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(Wr
appedConnection.java:172)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:439)
        at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatch
er.java:366)
        at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatc
her.java:105)
        at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
        at org.hibernate.loader.hql.QueryLoader.iterate(QueryLoader.java:384)
        ... 6 more

7 楼 cmoaciopm 2008-05-26  

多谢博主啦，就是看了你的这篇文章搭建起来的。不过第4步我没有做，就部署成功了。

6 楼 dapeng1525 2008-03-17  

顶！！！！谢谢楼主的讲解，让我受益颇丰，现在正在学习JBPM，遇到了N多问题，今天在这里看到楼主的讲解解决了我很多问题，希望楼主再接再厉！！！

5 楼 gyc567 2007-09-23  

我按照这样的步骤后，发生这样的异常：

Caused by: java.sql.SQLException: Table not found in statement
[select top ? timer0_.ID_ as col_0_0_ from JBPM_TIMER timer0_ where (timer0_.EXCEPTION_ is null) and timer0_.ISSUSPENDED_<>1 order by timer0_.DUEDATE_ asc]

请问怎么解决啊？

4 楼 379548695 2007-09-12  

very good!

3 楼 fndcz 2007-08-28  

多谢支持

2 楼 libin2722 2007-08-27  

不错，顶一下

1 楼 blackstreet 2007-08-21  

15:32:02,281 ERROR [MainDeployer] Could not create deployment: file:/D:/jboss-4.0.3SP1/server/jbpm/deploy/attrpm-service.xml
org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss:service=AttributePersistenceService,
这是我启动JBOSS的时的异常不知道为什么,还有几个异常都和D:\jboss-4.0.3SP1\server\jbpm\deploy\目录下的几个XML文件有关,报出的错误消息和上面的样不多,但是我进http://localhost:8080/jbpm也行,不知道为什么,
另外我发现报错的几个xml文件是
jbpm-starters-kit-3.1.4\jbpm-server\server\jbpm\deploy\目录下没有,但在D:\jboss-4.0.3SP1\server\jbpm\deploy有