1.首先配置tomcat连接池server.xml里面(不详细说了google上面很多例子)

<Context path="/datatest" docBase="E:/dataSource/webapps" debug="1" reloadable="true">
  <Resource name="jdbc/name" auth="Container" type="javax.sql.DataSource"/>                     
    <ResourceParams name="jdbc/name"> 
    <parameter>
     <name>maxActive</name>
     <!-- Maximum number of DB connections in pool.Set to 0 for no limit. -->
     <value>20</value>
    </parameter>
    <parameter>
     <name>maxIdle</name>
     <!-- Maximum number of idle DB connections to retain in pool.Set to 0 for no limit. -->
     <value>10</value>
    </parameter>
    <parameter>
     <name>maxWait</name>
     <!-- Maximum time to wait for a DB connection to become available in ms.An exception is thrown if this timeout is exceeded.Set to -1 to wait indefinitely. -->
     <value>10000</value>
    </parameter>   
    <parameter>
     <name>removeAbandoned</name>
     <!-- Abandoned DB connections are removed and recycled -->
     <value>true</value>
    </parameter>
    <parameter>
     <name>removeAbandonedTimeout</name>
     <!-- Use the removeAbandonedTimeout parameter to set the number of seconds a DB connection has been idle before it is considered abandoned.  -->
     <value>60</value>
    </parameter>
    <parameter>
     <name>logAbandoned</name>
     <!-- Log a stack trace of the code which abandoned -->
     <value>false</value>
    </parameter>
    <parameter>
     <name>factory</name>
     <!--DBCP Basic Datasource Factory -->
     <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
    </parameter>
        <parameter>                     
          <name>username</name>                     
          <value>biz</value>                     
        </parameter>                     
        <parameter>                     
          <name>password</name>                     
          <value>biz</value>                     
        </parameter>                     
        <parameter>                     
          <name>driverClassName</name>                     
          <value>oracle.jdbc.driver.OracleDriver</value>                     
        </parameter>                     
        <parameter>                     
          <name>url</name>                     
          <value>jdbc:oracle:thin:@192.168.0.2:1521:orcl</value>                     
        </parameter>                     
       </ResourceParams>
        </Context> 

[1] [2] [3] 下一页