tomcat5.0.28 连接池配置如下:
<?xml version= '1.0 ' encoding= 'utf-8 '?>
<Server>
<Listener className= "org.apache.catalina.mbeans.ServerLifecycleListener "/>
<Listener className= "org.apache.catalina.mbeans.GlobalResourcesLifecycleListener "/>
<GlobalNamingResources>
<Environment name= "simpleValue " type= "java.lang.Integer " value= "30 "/>
<Resource auth= "Container " description= "User database that can be updated and saved " name= "UserDatabase " type= "org.apache.catalina.UserDatabase "/>
<Resource name= "jdbc/wyl " type= "javax.sql.DataSource "/>
<ResourceParams name= "UserDatabase ">
<parameter>
<name> factory </name>
<value> org.apache.catalina.users.MemoryUserDatabaseFactory </value>
</parameter>
<parameter>
<name> pathname </name>
<value> conf/tomcat-users.xml </value>
</parameter>
</ResourceParams>
<ResourceParams name= "jdbc/wyl ">
<parameter>
<name> validationQuery </name>
<value> select * from orgmodel_userinfo </value>
</parameter>
<parameter>
<name> url </name>
<value> jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=wyl </value>
</parameter>
<parameter>
<name> password </name>
<value> </value>
</parameter>
<parameter>
<name> maxActive </name>
<value> 4 </value>
</parameter>
<parameter>
<name> maxWait </name>
<value> 5000 </value>
</parameter>