[转载]将osworkflow example 持久化 jdbcstore

将osworkflow example 持久化 jdbcstore
环境：tomcat5.0.18+mysql4.0.14+osworkflow例子。

1、导入etcdeploymentjdbc目录下mysql.sql（DB名字我定为osworkflow）

2、我的webapps下的目录名为oswfexmysql，则我在tomcat的confCatalinalocalhost目录下新建文件oswfexmysql.xml即可

<?xml version='1.0' encoding='utf-8'?>







factory
org.apache.commons.dbcp.BasicDataSourceFactory


maxActive
100


maxIdle
30


maxWait
10000


username
sa


password



driverClassName
org.gjt.mm.mysql.Driver


url
jdbc:mysql://localhost:3306/osworkflow



3、修改WEB-INF/classes目录下osworkflow.xml为：

<!--

--&gt

value="SELECT max(id)+1 FROM OS_WFENTRY"/>




value="SELECT max(ID)+1 FROM OS_STEPIDS"/>

value="INSERT INTO OS_STEPIDS (ID) values (null)"/>
value="SELECT max(ID) FROM OS_STEPIDS"/>

4、修改osuer.xml为：

OS_USER
OS_GROUP
OS_MEMBERSHIP
USERNAME
PASSWORDHASH
GROUPNAME
USERNAME
GROUPNAME
java:comp/env/jdbc/oswf


OS_USER
OS_GROUP
OS_MEMBERSHIP
USERNAME
PASSWORDHASH
GROUPNAME
USERNAME
GROUPNAME
java:comp/env/jdbc/oswf


OS_USER
OS_GROUP
OS_MEMBERSHIP
USERNAME
PASSWORDHASH
GROUPNAME
USERNAME
GROUPNAME
java:comp/env/jdbc/oswf


<!--
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.
--&gt

5、在classes目录下加一文件propertyset.xml

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

6、确认自己的mysql驱动

7、run tomcat

8、over啦！！哈哈~~~

配置起来一路比较顺利，参考了几个大哥网上的例子。GOOD LUCK

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/374079/viewspace-131077/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/374079/viewspace-131077/