程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> MYSQL數據庫 >> 關於MYSQL數據庫 >> 被osworkflow的數據庫配置(mysql)困住了

被osworkflow的數據庫配置(mysql)困住了

編輯:關於MYSQL數據庫
被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

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved