被osworkflow的數據庫配置(MySQL)困住了
今天研究了一下osworkflow,想運行一下他的例子程序看看效果。結果在配置與數據庫連接方面出了問題,郁悶至極。
我用的是MySQL數據庫,按照
http://www.opensymphony.com/osworkflow/1.3%20Running%20the%20Example%20App.Html一步一步的配置。
我的配置文件具體如下:
1:在tomcat的conf目錄下修改server.XML,增加以下內容
debug= "99" reloadable="true" crossContext="true" verbosity="DEBUG">
turn it off once you do not need it
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
auth="Container"
type="Javax.sql.DataSource"/>
factory
org.apache.commons.dbcp.BasicDataSourceFactory
factory
org.apache.catalina.users.MemoryUserDatabaseFactory
configure your MySQLd max_connections large enough to handle
all of your db connections. Set to 0 for no limit.
maxActive
100
Set to 0 for no limit.
maxIdle
30
in ms, in this example 10 seconds. An Exception is thrown if
this timeout
is exceeded. Set to -1 to wait indefinitely.
maxWait
10000
username
root
passWord
driverClassName
org.gjt.mm.MySQL.Driver
The autoReconnect=true argument to the url makes sure that the
mm.mysql JDBC Driver will automatically reconnect if MySQLd closed the
connection. MySQLd by default closes idle connections after 8 hours.
url
jdbc:MySQL://localhost:3306/osworkflow?autoReconnect=true
&l
您正在看的MySQL教程是:被osworkflow的數據庫配置(MySQL)困住了。t;/ResourceParams>
2:配置osworkflow.XML(在WEB-INF\classes目錄下),內容如下:
value="select count(*) + 1 from os_wfentry"/>
<:property key="step.sequence" value="select sum(c1) + 1 from (select 1 as
tb, count(*) as c1 from os_currentstep union select 2 as tb,歡迎光臨
3:增加propertyset.XML(在WEB-INF\classes目錄下),內容如下:
>
4:修改web.XML,內容如下:
OSWorkflow Example App
您正在看的MySQL教程是:被osworkflow的數據庫配置(MySQL)困住了。
default.JSP
OSWorkflow Example App
jdbc/DefaultDS
Javax.sql.DataSource
Container
5:將jboss-J2EE.jar拷貝到tomcat_home\common\endorsed目錄下
6:將驅動程序拷貝到tomcat_home\common\lib目錄下
7:啟動tomcat但是報以下錯誤
嚴重: Parse error in application web.XML
Java.lang.NullPointerException