struts连接池配置

struts连接池配置

关键字:       

struts连接池配置，只写了两个例子，实际开发中最好不用struts带的连接池，不利于系统程序换移植！ SQLServer2000数据库连接池配置如下： < data-sources >      < data-source  key ="org.apache.struts.action.DATA_SOURCE"  type ="org.apache.commons.dbcp.BasicDataSource" >        < set-property  property ="driverClassName"  value ="com.microsoft.jdbc.sqlserver.SQLServerDriver"   />        < set-property  property ="url"  value ="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=jdsdb"   />        < set-property  property ="username"  value ="sa"   />        < set-property  property ="password"  value =""   />        < set-property  property ="maxActive"  value ="200"   />        < set-property  property ="maxIdel"  value ="30"   />        < set-property  property ="maxWait"  value ="10000"   />        < set-property  property ="autoReconnect"  value ="true"   />        < set-property  property ="max-connections"  value ="10"   />        < set-property  property ="min-connections"  value ="2"   />        < set-property  property ="inactivity-timeout"  value ="30"   />        < set-property  property ="wait-timeout"  value ="30"   />        < set-property  property ="eroDateTimeBehavior"  value ="convertToNull"   />      data-source>   data-sources>    MySQL数据库连接池配置如下： < data-sources >      < data-source  key ="org.apache.struts.action.DATA_SOURCE"  type ="org.apache.commons.dbcp.BasicDataSource" >        < set-property  property ="driverClassName"  value ="com.mysql.jdbc.Driver"   />        < set-property  property ="url"  value ="jdbc:mysql://127.0.0.1:3306/JDSDB?useUnicode=true&amp;characterEncoding=gb2312"   />        < set-property  property ="username"  value ="root"   />        < set-property  property ="password"  value =""   />        < set-property  property ="maxActive"  value ="200"   />        < set-property  property ="maxIdel"  value ="30"   />        < set-property  property ="maxWait"  value ="10000"   />        < set-property  property ="autoReconnect"  value ="true"   />        < set-property  property ="max-connections"  value ="10"   />        < set-property  property ="min-connections"  value ="2"   />        < set-property  property ="inactivity-timeout"  value ="30"   />        < set-property  property ="wait-timeout"  value ="30"   />        < set-property  property ="eroDateTimeBehavior"  value ="convertToNull"   />      data-source>   data-sources>