tomcat + mysql 环境下osworkflow的持久化

-★出爺;3

1、将osworkflow-2.7.0-example.war复制到tomcat_home\webapps下！启动服务后自动部署

2、在mysql中建立数据库，名称osworkflow(各人自定)

3、将mysql的jdbc引擎复制到tomcat_home\common\lib中！

4、在tomcat_homt\conf\Catalina\localhost中建立文件osworkflow-2.7.0-example.xml
      内容如下：
      <?xml version='1.0' encoding='utf-8'?>
<Context path="/osworkflow-2.7.0-example"docBase="osworkflow-2.7.0-example" debug="0" reloadable="true"crossContext="true">
   <Logger className="org.apache.catalina.logger.FileLogger"prefix="localhost_sessiontest_log." suffix=".txt" timestamp="true"/>
    <Environment name="maxExemptions" type="java.lang.Integer" value="15"/>
    <Parameter name="context.param.name" value="context.param.value" override="false"/>
    <Resource name="jdbc/oswf" auth="Container" type="javax.sql.DataSource"/>
    <ResourceParams name="jdbc/oswf">
    <parameter>
      <name>factory</name>
      <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
    <parameter>
      <name>maxActive</name>
      <value>100</value>
    </parameter>
    <parameter>
      <name>maxIdle</name>
      <value>30</value>
    </parameter>
    <parameter>
      <name>maxWait</name>
      <value>10000</value>
    </parameter>
    <parameter>
     <name>username</name>
     <value>root</value>
    </parameter>
    <parameter>
     <name>password</name>
     <value></value>
    </parameter>
    <parameter>
       <name>driverClassName</name>
       <value>org.gjt.mm.mysql.Driver</value>
    </parameter>
    <parameter>
      <name>url</name>
      <value>jdbc:mysql://localhost:3306/osworkflow</value>
    </parameter>
</ResourceParams>
</Context>

5、修改tomcat_home\webapps\osworkflow-2.7.0-example\WEB-INF\classes中的下列文件，没有的则新增
（1）、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">java:comp/env/jdbc/oswf</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">java:comp/env/jdbc/oswf</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">java:comp/env/jdbc/oswf</property>
     </provider>

     
     <!--
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.SmartsAuthenticator" /-->
</opensymphony-user>

（2）、osworkflow.xml
<osworkflow>
<!--
     <persistence class="com.opensymphony.workflow.spi.memory.MemoryWorkflowStore"/>
-->
<persistence class="com.opensymphony.workflow.spi.jdbc.MySQLWorkflowStore">
<property key="datasource" value="jdbc/oswf"/>
<property key="entry.sequence"
                       value="select max(id)+1 from OS_WFENTRY"/>
<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 max(ID)+1 from OS_STEPIDS"/>
                        
<property key="step.sequence.increment"
      value="INSERT INTO OS_STEPIDS (ID) values (null)"/>
    <property key="step.sequence.retrieve"
      value="select max(ID) from OS_STEPIDS"/>                        
      
<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>

（3）、propertyset.xml
<propertysets>
     <propertyset name="jdbc"
       class="com.opensymphony.module.propertyset.database.JDBCPropertySet">
         <arg name="datasource" value="jdbc/oswf"/>
         <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>

红色标记处都是数据库连接设置，全部一样！
蓝色部分必须写上，否则连不上，至少我是这样！呵呵~

启动tomcat以后，进入osworkflow-2.7.0-example，首先创建拥护和组，用户名为test，密码为test，创建组为foos，将用户test分配到foos组中，这样就可以用test用户登陆，并且可以开始运行example流程了！