OSWorkflow数据库配置

OSWorkflow数据库配置

 

本文所讲的例子是对OSWorkflow网站例子程序的完善和补充，网站中讲到的例子主要是针对内存中运行的工作流，用户，组，工作流实例都是在内存中的。由于实际工作中，用户及组的信息是要入库的，所以本文主要讲解：OSWorkflow数据库方面的配置。读者可以先下载OSWorkflow的例子，再按以下方法修改相关配置。

下载地址：https://osworkflow.dev.java.net/files/documents/635/4647/osworkflow-2.7.0.zip

在下载的zip包中，有一个osworkflow-2.7.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"/>

              <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"/>

              <property key="step.caller" value="CALLER"/>

              <property key="step.startDate" value="START_DATE"/>

              <property key="step.finishDate" value="FINISH_DATE"/>

              <property key="step.dueDate" value="DUE_DATE"/>

              <property key="step.status" value="STATUS"/>

              <property key="step.previousId" value="PREVIOUS_ID"/>

       </persistence>

      

    <factory class="com.opensymphony.workflow.loader.XMLWorkflowFactory">

        <property key="resource" value="workflows.xml" />

    </factory>

</osworkflow>

 

2.         osuser.xml修改成如下：该文件负责用户及组的入库配置。

<opensymphony-user>

      <provider class="com.opensymphony.user.provider.jdbc.JDBCAccessProvider">

      <property name="user.table">os_user</property>

      <property name="group.table">os_group</property>

      <property name="membership.table">os_membership</property>

      <property name="user.name" >username</property>

      <property name="user.password">passwordhash</property>

      <property name="group.name">groupname</property>

      <property name="membership.userName" >username</property>

      <property name="membership.groupName">groupname</property>

      <property name="datasource">jdbc/DefaultDS</property>

<!--      <property name="datasource">java:comp/env/jdbc/DefaultDS</property>-->

     </provider>

        <provider class="com.opensymphony.user.provider.jdbc.JDBCCredentialsProvider">

      <property name="user.table">os_user</property>

      <property name="group.table">os_group</property>

      <property name="membership.table">os_membership</property>

      <property name="user.name" >username</property>

      <property name="user.password">passwordhash</property>

      <property name="group.name">groupname</property>

      <property name="membership.userName" >username</property>

      <property name="membership.groupName">groupname</property>

      <property name="datasource">jdbc/DefaultDS</property>

<!--      <property name="datasource">java:comp/env/jdbc/DefaultDS</property>-->

     </provider>

        <provider class="com.opensymphony.user.provider.jdbc.JDBCProfileProvider">

      <property name="user.table">os_user</property>

      <property name="group.table">os_group</property>

      <property name="membership.table">os_membership</property>

      <property name="user.name" >username</property>

      <property name="user.password">passwordhash</property>

      <property name="group.name">groupname</property>

      <property name="membership.userName" >username</property>

      <property name="membership.groupName">groupname</property>

      <property name="datasource">jdbc/DefaultDS</property>

<!--      <property name="datasource">java:comp/env/jdbc/DefaultDS</property>-->

     </provider>

    <!--

    <provider class="com.opensymphony.user.provider.memory.MemoryAccessProvider" />

    <provider class="com.opensymphony.user.provider.memory.MemoryCredentialsProvider" />

    <provider class="com.opensymphony.user.provider.memory.MemoryProfileProvider" />

    -->

    <!--

              Authenticators can take properties just like providers.

 

              This smart authenticator should work for 'most' cases - it dynamically looks up

              the most appropriate authenticator for the current server.

       -->

       <authenticator class="com.opensymphony.user.authenticator.SmartAuthenticator" />

</opensymphony-user>

 

3.         加入propertyset.xml文件，该文件是工作流中所有属性入库的配置文件，有点像Hibernate的hbm映射文件：

<propertysets>

    <propertyset name="jdbc"

      class="com.opensymphony.module.propertyset.database.JDBCPropertySet">

        <arg name="datasource" value="jdbc/DefaultDS"/>

        <arg name="table.name" value="OS_PROPERTYENTRY"/>

        <arg name="col.globalKey" value="GLOBAL_KEY"/>

        <arg name="col.itemKey" value="ITEM_KEY"/>

        <arg name="col.itemType" value="ITEM_TYPE"/>

        <arg name="col.string" value="STRING_VALUE"/>

        <arg name="col.date" value="DATE_VALUE"/>

        <arg name="col.data" value="DATA_VALUE"/>

        <arg name="col.float" value="FLOAT_VALUE"/>

        <arg name="col.number" value="NUMBER_VALUE"/>

    </propertyset>

</propertysets>

 

4.         DataSource的配置

²        在Weblogic中，使用控制台可以方便的配置数据源，指定其JNDI为jdbc/DefaultDS就可以了。

²        在Tomcat中，配置如下：

<Context path="/osworkflow_example" docBase="osworkflow-2.7.0-example"

         debug= "99" reloadable="true" crossContext="true"

 

verbosity="DEBUG">

<!-- debug level is set to paranoid, to know what is happening,

     turn it off once you do not need it -->

 

<Logger className="org.apache.catalina.logger.FileLogger"

        prefix="OSWorkflow." suffix=".log" timestamp="true"/>

<!--

    put log4j.jar into:

    TOMCAT_ROOT/webapp/osworkflow-2.7.0-example/WEB-INF/lib

    if you want to use it for logging

-->

 

<Resource name="jdbc/DefaultDS" auth="Container"

                 type="javax.sql.DataSource"/>

<!-- name="jdbc/DefaultDS" is used in other components of the

     Example App, do not change it here! -->

 

<ResourceParams name="jdbc/DefaultDS">

  <parameter>

    <name>factory</name>

    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>

  </parameter>

  <parameter>

    <name>driverClassName</name>

    <value>oracle.jdbc.driver.OracleDriver</value>

  </parameter>

  <parameter>

    <name>url</name>

    <value>jdbc:oracle:thin:@localhost:1521:MAX</value>

  </parameter>

  <parameter>

    <name>username</name>

    <value>MAX</value>

  </parameter>

  <parameter>

    <name>password</name>

    <value>MAX</value>

  </parameter>

  <parameter>

    <name>maxActive</name>

    <value>20</value>

  </parameter>

  <parameter>

    <name>maxIdle</name>

    <value>10</value>

  </parameter>

  <parameter>

    <name>maxWait</name>

    <value>-1</value>

  </parameter>

</ResourceParams>

</Context>

注意：要是使用的Tomcat服务器，以上配置文件osuser.xml、propertyset.xml中的datasource的值应该改成java:comp/env/jdbc/DefaultDS。这样才能保证在Tomcat下的正常入库。这是因为osuser及propertyset模块找查datasource时代码不够完善造成的。大家可以参考一下osuser中找查datasource的代码。

 

龚文兵(maxgong2003@hotmail.com)