tomcat和sqlserver数据库连接池配置

1.WebRoot/WEB-INF/web.xml中 添加如下： <!--ConnectionPool-->

 

      <resource-ref>

 

           <res-ref-name>jdbc/OA</res-ref-name>

 

           <res-type>javax.sql.DataSource</res-type>

 

           <res-auth>Container</res-auth>

 

      </resource-ref>

2.tomcat安装目录里 （如D:/jakarta-tomcat-5.0.30/conf）server.xml中 <Host></Host>里面 添加如下：（可放在host里最后面）  <Context path="/OA" reloadable="true" docBase="OA">  <Resource name="jdbc/OA" auth="Container" type="javax.sql.DataSource"/>  <ResourceParams name="jdbc/OA">   <parameter>    <name>factory</name>    <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>   </parameter>    <parameter>             <name>driverClassName</name>            <value>com.microsoft.sqlserver.jdbc.SQLServerDriver</value>        </parameter>   <parameter>    <name>url</name>    <value>jdbc:sqlserver://127.0.0.1:1433;DatabaseName=OA</value>   </parameter>   <parameter>    <name>username</name>    <value>sa</value>   </parameter>   <parameter>    <name>password</name>    <value>666666</value>   </parameter>   <parameter>    <name>maxActive</name>    <value>1000</value>   </parameter>   <parameter>    <name>maxIdle</name>    <value>50</value>   </parameter>   <parameter>    <name>maxWait</name>    <value>50</value>   </parameter>  </ResourceParams> </Context>

切记sqlserver2005中：com.microsoft.sqlserver.jdbc.SQLServerDriver          jdbc:sqlserver://127.0.0.1:1433;DatabaseName=OAsqlserver2000中：com.microsoft.jdbc.sqlserver.SQLServerDriver        jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=OA

3.commons-collections.jarcommons-dbcp-1.2.2.jarcommons-pool-1.5.4.jar以及sqljdbc.jar要导入