JBuilder + Tomcat 数据库连接池的配置方法

1.找到server8080.xml
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="Tomcat-Standalone">
    <Connector acceptCount="10"
          className="org.apache.coyote.tomcat4.CoyoteConnector"
          connectionTimeout="60000"
          debug="0"
          maxProcessors="75"
          minProcessors="5"
          port="8080"
          maxPostSize="0"
        URIEncoding="GBK" />
    <Engine debug="0" defaultHost="localhost" name="Standalone">
      <Host appBase="[ProjectDirectory]/Tomcat/webapps" debug="0" name="localhost" unpackWARs="true">
       <Context path="/sp" docBase="[ProjectDirectory]/sp" debug="5" reloadable="true" crossContext="true" workDir="[ProjectDirectory]/Tomcat/work/sp">          
          <Resource name="jdbc/OracleDB" auth="Container" type="javax.sql.DataSource"/>
          <ResourceParams name="jdbc/OracleDB">
            <parameter>
            <name>factory</name>                     
            <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>              
            </parameter>
            <parameter>           
            <name>driverClassName</name>                     
            <value>oracle.jdbc.driver.OracleDriver</value>              
            </parameter>
            <parameter>           
            <name>url</name>
              <value>jdbc:oracle:thin:@localhost:1521:sms</value>
            </parameter>
            <parameter>                     
            <name>username</name>                    
            <value>scott</value>             
            </parameter>
            <parameter>                    
            <name>password</name>                       
            <value>tiger</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>              
          </ResourceParams>         
        </Context>
      </Host>
    </Engine>
  </Service>
</Server>
其中[ProjectDirectory]是Web工程所在的目录(jbx文件)