tomcatの接続プール構成コード(tomcat 5.0、tomcat 5.5 x、tomcat 6.0を含む)

Tomcat6.0     
  1.  tomcat  conf  context.xml  ,          : 
1.	<Resource name="jdbc/oracle"
2.	       auth="Container"   
3.	       type="javax.sql.DataSource"   
4.	       driverClassName="oracle.jdbc.driver.OracleDriver "   
5.	       url=" jdbc:oracle:thin:@host:port:databse"   
6.	       username=" user "   
7.	       password="password"   
8.	       maxActive="100"   
9.	       maxIdle="30"   
10.	       maxWait="10000" />   
2.        web.xml      :
1.	<resource-ref>   
2.	    <description>DB Connection</description>   
3.	    <res-ref-name>jdbc/oracle</res-ref-name>   
4.	    <res-type>javax.sql.DataSource</res-type>   
5.	    <res-auth>Container</res-auth>   
6.	  </resource-ref>   
3.              common/lib   ok 
4.         

Tomcat5.5x     

   、        
1、           ，     tomcat\conf\server.xml GlobalNamingResources   
<Resource name="jdbc/mydb" type="javax.sql.DataSource" password="mypwd" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver" maxIdle="2" maxWait="5000" validationQuery="select 1" username="sa" url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb" maxActive="4"/>
2、 tomcat\webapps\myapp\META-INF\context.xml Context   ：
<ResourceLink global="jdbc/mydb" name="jdbc/mydb" type="javax.sql.DataSource"/>
      。
   、        
1、  
2、 tomcat\conf\context.xml Context   ：
<ResourceLink global="jdbc/mydb" name="jdbc/mydb" type="javax.sql.DataSource"/>
   、        
   tomcat\webapps\myapps\META-INF\context.xml Context   ：
<Resource name="jdbc/mydb" type="javax.sql.DataSource" password="mypwd" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver" maxIdle="2" maxWait="5000" validationQuery="select 1" username="sa" url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=mydb" maxActive="4"/>
    ：
driveClassName：JDBC         ； 
maxActive：                     ； 
maxIdle：                  ； 
maxWait：      ，    ； 
password：    ； 
url： JDBC URL  ； 
user：    ； 
validationQuery：           。
       tomcat 5.5.4    。  ，sql server jdbc driver          sql server jdbc (sp3)。

tomcat5.0     
 tomcat      （Tomcat \conf\Catalina\localhost）    xml  ，    
 <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>
        <!-- Maximum number of dB connections in pool. Make sure you
             configure your mysqld max_connections large enough to handle
             all of your db connections. Set to 0 for no limit.
             -->
        <parameter>
            <name>maxActive</name>
            <value>100</value>
        </parameter>
        <!-- Maximum number of idle dB connections to retain in pool.
             Set to 0 for no limit.
             -->
        <parameter>
            <name>maxIdle</name>
            <value>30</value>
        </parameter>
        <!-- Maximum time to wait for a dB connection to become available
             in ms, in this example 10 seconds. An Exception is thrown if
             this timeout is exceeded.  Set to -1 to wait indefinitely.
             -->
        <parameter>
            <name>maxWait</name>
            <value>10000</value>
        </parameter>
        <!-- MySQL dB username and password for dB connections  -->
        <parameter>
            <name>username</name>
            <value>sa</value>
        </parameter>
        <parameter>
            <name>password</name>
            <value>test</value>
        </parameter>
        <!-- Class name for JDBC driver -->
        <parameter>
            <name>driverClassName</name>
            <value>net.sourceforge.jtds.jdbc.Driver</value>
        </parameter>
        <!-- Autocommit setting.  This setting is required to make
             Hibernate work.  Or you can remove calls to commit(). -->
        <parameter>
            <name>defaultAutoCommit</name>
            <value>true</value>
        </parameter>
        <!-- The JDBC connection url for connecting to your MySQL dB.
             The autoReconnect=true argument to the url makes sure that the
             mm.mysql JDBC Driver will automatically reconnect if mysqld closed the
             connection.  mysqld by default closes idle connections after 8 hours.
             -->
        <parameter>
            <name>url</name>
            <value>jdbc:jtds:sqlserver://url/filedb;charset=gb2312;autoReconnect=true</value>
        </parameter>
        <!-- Recover abandoned connections -->
        <parameter>
            <name>removeAbandoned</name>
            <value>true</value>
        </parameter>
        <!-- Set the number of seconds a dB connection has been idle 
             before it is considered abandoned. 
             -->
        <parameter>
            <name>removeAbandonedTimeout</name>
            <value>60</value>
        </parameter>
        <!-- Log a stack trace of the code which abandoned the dB 
             connection resources. 
             -->
        <parameter>
            <name>logAbandoned</name>
            <value>true</value>
        </parameter>
    </ResourceParams>