OsWorkflow- 2 osworkflow mysql 2: JDBCStore / * * Author: Meanson Wang * Date: 2005-01-15 * email: Meansonw@hotmail.com*/
Osworkflow supports the following persistence: MemoryStore (default), SerializableStore, JDBCStore, OfbizStore, and EJBStore [environment] WIN2000Osworkflow 2.7.0Tomat 5.0.25Mysql 4.1.7-nt mysql-connector-java-3.0.15-ga-bin. .jar
The following is to use MySQL for persistence, supporting the document is the 1.4 persistence options.html of the OSWF manual. It is recommended to use HypersonicsQL.
[Step 1:] Construction Library
Create a DB in MySQL named OSWORKFLOW to perform the mysql.sql built table in the compressed file SRC / ETC / Deployment / JDBC.
[Step 2:] Built a DataSource in Tomcat, named JDBC / OSWF
1) Configuring a DataSource JDBC / OSWF2 in the Datasource in Tomcat's admin / oswf2) $ CATALINA_HOME / CONF / CATALINA / LOCALHOST / $ AppName.xml Configuring a resource link
[Step 3:] Modify OSWORKFLOW.XML
Property key = "step.startdate" value = "start_date" />
[Step 4:] Add the PropertySet.xml file to Web-INF / CLASSES.
[Other supplements]
The above steps are mentioned in the manual, why have you added? Look, it will be clear. Since EXAMPLE is implemented with memory, it is actually that the above steps are only saved to the database, and the process defined LOAD and user data have not been saved to the database, so according to the use of Example, click here to build in the first page User Test, use this user to log in, use the process, at this time, the USER table in MSYQL is empty, and the data error of adding a relational database will appear. [OSWF's MySQL built is InnoDB, not myisam]. So, please also add the following steps: Add a record in the Os_User table, username = test, Passwordhash does not use it.
After this is set, the original method can also be successfully executed, and the flow data will remain in MySQL.
So what is the persistence of the XML definition file and User? Next step will be done. Please continue to pay attention.
