本文所讲的例子是对OSWorkflow网站例子程序的完善和补充,osworkflow自带例子主要是针对内存中运行的工作流,用户,组,工作流 实例都是在内存中的。由于实际工作中,用户及组的信息是要入库的,所以本文主要讲解:OSWorkflow数据库方面的配置。读者可以先下载 OSWorkflow的例子,再按以下方法修改相关配置。
下载地址:https://osworkflow.dev.java.net/files/documents/635/27138/osworkflow-2.8.0.zip
在下载的zip包中,有一个osworkflow-2.8.0-example.war包,可以直接在容器中解压运行。
修改如下配置文件:
1.osworkflow.xml修改成如下:该文件负责工作相关信息入库配置。
<
osworkflow
>
<!--
<persistence class="com.opensymphony.workflow.spi.memory.MemoryWorkflowStore"/>
-->
< persistence class ="com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore" >
<!-- For jdbc persistence, all are required. -->
< property key ="datasource" value ="jdbc/DefaultDS" />
<!-- 注意:本配置是基于oracle数据库,如果是其他数据库,请修改entry.sequence和step.sequence对应的value -->
< property key ="entry.sequence"
value ="SELECT seq_os_wfentry.nextval FROM dual" />
< property key ="entry.table" value ="OS_WFENTRY" />
< property key ="entry.id" value ="ID" />
< property key ="entry.name" value ="NAME" />
< property key ="entry.state" value ="STATE" />
< property key ="step.sequence"
value ="SELECT seq_os_currentsteps.nextval FROM dual" />
< property key ="history.table" value ="OS_HISTORYSTEP" />
< property key ="current.table" value ="OS_CURRENTSTEP" />
< property key ="historyPrev.table" value ="OS_HISTORYSTEP_PREV" />
< property key ="currentPrev.table" value ="OS_CURRENTSTEP_PREV" />
< property key ="step.id" value ="ID" />
< property key ="step.entryId" value ="ENTRY_ID" />
< property key ="step.stepId" value ="STEP_ID" />
< property key ="step.actionId" value ="ACTION_ID" />
< property key ="step.owner" value ="OWNER" <
<!--
<persistence class="com.opensymphony.workflow.spi.memory.MemoryWorkflowStore"/>
-->
< persistence class ="com.opensymphony.workflow.spi.jdbc.JDBCWorkflowStore" >
<!-- For jdbc persistence, all are required. -->
< property key ="datasource" value ="jdbc/DefaultDS" />
<!-- 注意:本配置是基于oracle数据库,如果是其他数据库,请修改entry.sequence和step.sequence对应的value -->
< property key ="entry.sequence"
value ="SELECT seq_os_wfentry.nextval FROM dual" />
< property key ="entry.table" value ="OS_WFENTRY" />
< property key ="entry.id" value ="ID" />
< property key ="entry.name" value ="NAME" />
< property key ="entry.state" value ="STATE" />
< property key ="step.sequence"
value ="SELECT seq_os_currentsteps.nextval FROM dual" />
< property key ="history.table" value ="OS_HISTORYSTEP" />
< property key ="current.table" value ="OS_CURRENTSTEP" />
< property key ="historyPrev.table" value ="OS_HISTORYSTEP_PREV" />
< property key ="currentPrev.table" value ="OS_CURRENTSTEP_PREV" />
< property key ="step.id" value ="ID" />
< property key ="step.entryId" value ="ENTRY_ID" />
< property key ="step.stepId" value ="STEP_ID" />
< property key ="step.actionId" value ="ACTION_ID" />
< property key ="step.owner" value ="OWNER" <