fndcz

jBPM学习（三）----将jbpm从jboss迁移到to ... | jBPM学习（一）----环境搭建

2007-08-20

jBPM学习（二）----数据库迁移

二、数据库迁移

1. 新建数据库

首先，打开SQL Server2005控制台，我们新建一个名为jbpm的空数据库。通过命令行进入D:\jbpm-starters-kit-3.1.4\jbpm-db目录，运行ant命令ant mssql.scripts，任务完成后进入D:\jbpm-starters-kit-3.1.4\jbpm-db\build\mssql\scripts目录，在该目录下生成了四个sql文件，这为我们建立数据库所需的文件。在SQL Server2005中运行mssql.create.sql文件，结束后生成一系列表，如下：

2. 添加数据库驱动文件

在工程jbpm.3/deploy/下新建目录mssql，将D:\jbpm-starters-kit-3.1.4\jbpm-db\mssql\lib下的jtds-1.2.jar文件拷贝到此文件夹下。

3. 修改配置文件

1) Hibernate.cfg.xml

在jbpm.3工程中找到hibernate的配置文件，如下图：

打开进入D:\jbpm-starters-kit-3.1.4\jbpm-db\mssql目录，此目录下文件为我们配置所需要的文件，打开hibernate.property文件，参照其中内容修改hibernate.cfg.xml文件，修改结果如下（参考）：

<property name="hibernate.dialect">org.hibernate.dialect.SQLServerDialect</property>

<property name="hibernate.connection.driver_class">net.sourceforge.jtds.jdbc.Driver</property>

<property name="hibernate.connection.url">jdbc:jtds:sqlserver://localhost:1433/jbpm</property>

<property name="hibernate.cache.provider_class">org.hibernate.cache.HashtableCacheProvider</property>

2) create.db.hibernate.properties

新建文件夹：用于存放数据库相关配置。在src\resources目下建立一个新文件夹：mssqldb。

拷贝文件：将同目录下的hsqldb的两个文件(\hsqldb\create.db.hibernate.properties和\hsqldb\identity.db.xml)拷贝到新建的文件夹里。

修改文件create.db.hibernate.properties：

hibernate.dialect= org.hibernate.dialect.SQLServerDialect

hibernate.connection.driver_class=net.sourceforge.jtds.jdbc.Driver

hibernate.connection.url= jdbc:jtds:sqlserver://localhost:1433/jbpm

hibernate.connection.username=sa

hibernate.connection.password=test

hibernate.show_sql=true

3) 项目根目录下的build.deploy.xml

找到create.db节点，将里面原先所有的hsqldb字段替换为mssqldb，即所有的路径指向我们刚才新建的文件夹下的文件。

同样找到deploy.processes节点，替换路径中的hsqldb为mssqldb。

3. 生成配置文件

将工程根目录下的build.deploy.xml拖入ant窗口，双击运行create.jbpm.configuration命令。

4. 拷贝所需jar文件

将D:\jbpm-starters-kit-3.1.4\jbpm-db\mssql\lib下的jtds-1.2.jar文件拷贝到{jboss_home}\server\jbpm\lib中去，至此，数据库的迁移完成。

启动jboss服务器，地址栏输入http://localhost:8080/jbpm进行测试。

22:49
浏览 (1797)
评论 (5)
分类: jBPM
发布在 JBPM @net 圈子
相关推荐

我也没有这个jbpm.3/deploy/目录，手动加的，我的出错了啊:>
Buildfile: D:\workspace\jbpm.3\build.deploy.xml
delete.jbpm.configuration:
build.webapp:
compile.jbpm:
compile.identity:
compile.jbpm.test:
compile.webapp:
compile.identity.test:
compile.examples:
compile:
build.webapp:
build.service.archive:
compile.jbpm:
build.jbpm:
compile.identity:
build.identity:
build.service.archive:
declare.jbpm.tasks:
compile.jbpm:
build.jbpm:
build.jbpm.src:
compile.identity:
build.identity:
build.identity.src:
compile.jbpm.test:
compile.webapp:
compile.identity.test:
compile.examples:
compile:
build.webapp:
build.service.archive:
build.converter:
[jar] Warning: skipping jar archive D:\workspace\jbpm.3\build\converter.jar because no files were included.
build:
db.clean:
[delete] Deleting directory D:\workspace\jbpm.3\build\db
[mkdir] Created dir: D:\workspace\jbpm.3\build\db
db.start:
[starthsqldb] starting 'java -cp H:jboss-5.0.0.Beta4jboss-5.0.0.Beta4/server/default/lib/hsqldb.jar org.hsqldb.Server -database D:\workspace\jbpm.3/build/db/localDB -port 1701'...
[starthsqldb] Exception in thread "Thread-0" java.lang.NullPointerException
[starthsqldb] at org.apache.tools.ant.Project.fireMessageLoggedEvent(Project.java:2143)
[starthsqldb] at org.apache.tools.ant.Project.fireMessageLogged(Project.java:2271)
[starthsqldb] at org.apache.tools.ant.Project.log(Project.java:449)
[starthsqldb] at org.apache.tools.ant.Task.log(Task.java:294)
[starthsqldb] at org.apache.tools.ant.Task.log(Task.java:281)
[starthsqldb] at org.jbpm.ant.Launcher.run(Launcher.java:51)
create.db:
[jbpmschema] 15:51:25,937 [main] DEBUG AntHelper : creating hibernate configuration from cfg 'D:\workspace\jbpm.3/src/config.files/hibernate.cfg.xml' and properties 'D:\workspace\jbpm.3/src/resources/mssqldb/create.db.hibernate.properties'

BUILD FAILED
D:\workspace\jbpm.3\build.deploy.xml:47: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory

Total time: 14 seconds

ljh0242 2008-05-27

我也没有这个jbpm.3/deploy/目录，手动加的，我的出错了啊:>
Buildfile: D:\workspace\jbpm.3\build.deploy.xml
delete.jbpm.configuration:
build.webapp:
compile.jbpm:
compile.identity:
compile.jbpm.test:
compile.webapp:
compile.identity.test:
compile.examples:
compile:
build.webapp:
build.service.archive:
compile.jbpm:
build.jbpm:
compile.identity:
build.identity:
build.service.archive:
declare.jbpm.tasks:
compile.jbpm:
build.jbpm:
build.jbpm.src:
compile.identity:
build.identity:
build.identity.src:
compile.jbpm.test:
compile.webapp:
compile.identity.test:
compile.examples:
compile:
build.webapp:
build.service.archive:
build.converter:
[jar] Warning: skipping jar archive D:\workspace\jbpm.3\build\converter.jar because no files were included.
build:
db.clean:
[delete] Deleting directory D:\workspace\jbpm.3\build\db
[mkdir] Created dir: D:\workspace\jbpm.3\build\db
db.start:
[starthsqldb] starting 'java -cp H:jboss-5.0.0.Beta4jboss-5.0.0.Beta4/server/default/lib/hsqldb.jar org.hsqldb.Server -database D:\workspace\jbpm.3/build/db/localDB -port 1701'...
[starthsqldb] Exception in thread "Thread-0" java.lang.NullPointerException
[starthsqldb] at org.apache.tools.ant.Project.fireMessageLoggedEvent(Project.java:2143)
[starthsqldb] at org.apache.tools.ant.Project.fireMessageLogged(Project.java:2271)
[starthsqldb] at org.apache.tools.ant.Project.log(Project.java:449)
[starthsqldb] at org.apache.tools.ant.Task.log(Task.java:294)
[starthsqldb] at org.apache.tools.ant.Task.log(Task.java:281)
[starthsqldb] at org.jbpm.ant.Launcher.run(Launcher.java:51)
create.db:
[jbpmschema] 15:51:25,937 [main] DEBUG AntHelper : creating hibernate configuration from cfg 'D:\workspace\jbpm.3/src/config.files/hibernate.cfg.xml' and properties 'D:\workspace\jbpm.3/src/resources/mssqldb/create.db.hibernate.properties'

BUILD FAILED
D:\workspace\jbpm.3\build.deploy.xml:47: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory

Total time: 14 seconds

ljh0242 2008-05-27

操作同上，出现如下错误：
Buildfile: D:\workspace\jbpm.3\build.deploy.xml
delete.jbpm.configuration:
build.webapp:
compile.jbpm:
compile.identity:
compile.jbpm.test:
compile.webapp:
compile.identity.test:
compile.examples:
compile:
build.webapp:
build.service.archive:
compile.jbpm:
build.jbpm:
compile.identity:
build.identity:
build.service.archive:
declare.jbpm.tasks:
compile.jbpm:
build.jbpm:
build.jbpm.src:
compile.identity:
build.identity:
build.identity.src:
compile.jbpm.test:
compile.webapp:
compile.identity.test:
compile.examples:
compile:
build.webapp:
build.service.archive:
build.converter:
[jar] Warning: skipping jar archive D:\workspace\jbpm.3\build\converter.jar because no files were included.
build:
db.clean:
[delete] Deleting directory D:\workspace\jbpm.3\build\db
[mkdir] Created dir: D:\workspace\jbpm.3\build\db
db.start:
[starthsqldb] starting 'java -cp H:jboss-4.2.2.GAjboss-4.2.2.GA/server/default/lib/hsqldb.jar org.hsqldb.Server -database D:\workspace\jbpm.3/build/db/localDB -port 1701'...
[starthsqldb] Exception in thread "Thread-0" java.lang.NullPointerException
[starthsqldb] at org.apache.tools.ant.Project.fireMessageLoggedEvent(Project.java:2143)
[starthsqldb] at org.apache.tools.ant.Project.fireMessageLogged(Project.java:2271)
[starthsqldb] at org.apache.tools.ant.Project.log(Project.java:449)
[starthsqldb] at org.apache.tools.ant.Task.log(Task.java:294)
[starthsqldb] at org.apache.tools.ant.Task.log(Task.java:281)
[starthsqldb] at org.jbpm.ant.Launcher.run(Launcher.java:51)
create.db:
[jbpmschema] 15:43:03,734 [main] DEBUG AntHelper : creating hibernate configuration from cfg 'D:\workspace\jbpm.3/src/config.files/hibernate.cfg.xml' and properties 'D:\workspace\jbpm.3/src/resources/mssqldb/create.db.hibernate.properties'

BUILD FAILED
D:\workspace\jbpm.3\build.deploy.xml:47: java.lang.NoClassDefFoundError: org/apache/commons/logging/LogFactory

Total time: 5 seconds

379548695 2007-09-12

工程下没jbpm.3/deploy/
发布的jbpm下面有这个/deploy/

379548695 2007-09-12

楼主我这个文件杂没啊
jbpm.3/deploy/
我加载的工程没这个啊急