Osworklow official website example

Transferred from: Liu Chao's blog
Several projects have been plagued by process control and have decided to learn workflow knowledge, I learned from the Internet that osworkflow is a lightweight and extremely flexible workflow engine (for details, visit: http://www.opensymphony.com/osworkflow), so take it to learn.
After an afternoon, I finally ran the built-in example. My testing environment: WINXP tomcat4.1.30 oracle8.05 jdk1.4.2.
First, download https://osworkflow.dev.java.net/files/documents/635/4647/osworkflow-2.7.0.zip. Unzip, copy the osworkflow-2.7.0-example.war to Tomcat's webapp, start Tomcat, access http: // localhost/osworkflow-2.7.0-example, everything is very easy.
Osworkflow provides multiple persistence mechanisms Memorystore (default), serializablestore, jdbcstore, ofbizstore, and so on. Because the downloaded example is used to facilitate beginners to run the program as soon as possible, memorystore is used. The actual system does not keep all data in the memory. Change to jdbcstore.

1. Modify Tomcat's Sever. xml and add:

<Context Path = "/Osworkflow-2.7.0-example"Docbase ="Osworkflow-2.7.0-example"
DEBUG = "5" reloadable = "true" crosscontext = "true">

<Logger classname = "org. Apache. Catalina. Logger. filelogger"
Prefix = "localhost_osworkflow_log." suffix = ". txt"
Timestamp = "true"/>

Resource Name = "JDBC/mydb" auth = "Container"
Type = "javax. SQL. datasource"/>

<Resourceparams name = "JDBC/mydb">
<Parameter>
<Name> factory </Name>
<Value> org. Apache. commons. DBCP. basicperformancefactory </value>
</Parameter>
<Parameter>
<Name> driverclassname </Name>
<Value> oracle. JDBC. Driver. oracledriver </value>
</Parameter>
<Parameter>
<Name> URL </Name>
<Value> JDBC: oracle: thin: @ 127.0.0.1: 1521: orcl </value>
</Parameter>
<Parameter>
<Name> username </Name>
<Value> oswf </value>
</Parameter>
<Parameter>
<Name> password </Name>
<Value> oswf </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>

2. Modify WEB-INF/classes/osworkflow. XML (the red part is modified based on your database)

<Osworkflow>
<Persistence class = "com. opensymphony. workflow. SPI. JDBC. jdbcworkflowstore">
<! -- For JDBC persistence, all are required. -->
<Property key = "datasource" value = "JDBC/mydb"/>
<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 = "previus_id"/>
</Persistence>

<Factory class = "com. opensymphony. workflow. loader. xmlworkflowfactory">
<Property key = "resource" value = "workflows. xml"/>
</Factory>
</Osworkflow>

3. Create propertyset. XML in WEB-INF/classes

<Propertysets>
<Propertyset name = "JDBC"
Class = "com. opensymphony. Module. propertyset. database. jdbcpropertyset">
<Arg name = "datasource" value = "JDBC/mydb"/>
<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. Modify osuser. xml under WEB-INF/classes

<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/mydb </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/mydb </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/mydb </property>
</Provider>

<! --
Authenticators can take properties just like providers.

This smart authenticator shocould 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>

5. Run src/etc/deployment/jdbc/oracle. SQL in the SQL-plus package.

6. start Tomcat

7. OK.