JBuilder2005 + Tomcat-5.0.28 数据库连接池的配置方法

1.在JBuilder2005 里启动Tomcat，在[ProjectDirectory]/Tomcat/conf 下找到server8080.xml。([ProjectDirectory]是Web工程所在的目录--jbx文件)
2.在server8080.xml中,删除下面的语句
   <!--This comment marks this file as generated, so it may be deleted and regenerated at any time. To preserve manual changes to this file, delete this comment.-->
   如果不删除该语句，JBuilder在重新启动Tomcat时会重新生成server8080.xml，这样我们对server8080.xml
的修改就会全部丢失。
3.修改server8080.xml

<?xml version="1.0" encoding="UTF-8"?>
<Server debug="0" port="8081" shutdown="SHUTDOWN">
  <Service name="Catalina">
    <Connector acceptCount="10" connectionTimeout="60000" debug="0" maxThreads="75" minSpareThreads="5" port="8080"/>
    <Engine debug="0" defaultHost="localhost" name="Catalina">
      <Host appBase="[ProjectDirectory]/Tomcat/webapps" autoDeploy="false" debug="0" deployXML="false" name="localhost" unpackWARs="false">
        <Context debug="0" docBase="[ProjectDirectory]/test" path="/test" reloadable="true" workDir="[ProjectDirectory]/Tomcat/work/test">
          <Resource name="jdbc/test" auth="Container" type="javax.sql.DataSource"/> 
          <ResourceParams name="jdbc/test">
            <parameter>
            <name>factory</name>
            <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
            </parameter>
            <!--Class name for Microsoft SQLServer-->
            <parameter>
            <name>driverClassName</name>
            <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value>
            </parameter>
            <!--JDBC connection url for connecting to MSSQL dB-->
            <parameter>
            <name>url</name>
            <value>jdbc:microsoft:sqlserver://fan:1433;databaseName=test</value>
            </parameter>
            <!--数据库访问的用户名-->
            <parameter>
            <name>username</name>
            <value>sa</value>
            </parameter>
            <!--数据库访问的密码-->
            <parameter>
            <name>password</name>
            <value>sa</value>
            </parameter>
            <!--连接池中可容纳的最大连接数-->
            <parameter>
            <name>maxActive</name>
            <value>20</value>
            </parameter>
            <!--池中可容纳的最大闲置数据连接数-->
            <parameter>
            <name>maxIdle</name>
            <value>10</value>
            </parameter>
            <!--等待数据库连接的最长时间(超时则抛出异常)-->
            <parameter>
            <name>maxWait</name>
            <value>-1</value>
            </parameter>
            <!--回收被遗弃的数据库连接至连接池-->
            <parameter>
            <name>removeAbandoned</name>
            <value>true</value>
            </parameter>
            <!--数据库连接过60秒不用将被遗弃而收回连接池-->
            <parameter>
            <name>removeAbandonedTimeout</name>
            <value>60</value>
            </parameter>
            <!--将被遗弃的连接回收记入日志-->
            <parameter>
            <name>logAbandoned</name>
            <value>true</value>
            </parameter>
          </ResourceParams>
        </Context>
      </Host>
    </Engine>
  </Service>
</Server>