Tomcat数据源配置

参考http://tomcat.apache.org/tomcat-6.0-doc/jndi-datasource-examples-howto.html 中MySQL configuration的配置。其中jdbc/*中的*可以使任意的，只要与前后一致就行了。

简要介绍：在%TOMCAT_HOME%/conf中的server.xml中的<Host></Host>标签中添加

Tomcat 5.5

<Context path="/sqlserver" docBase="sqlserver"                  //虚拟目录
        debug="5" reloadable="true" crossContext="true">

    <!-- maxActive: 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.
         -->

    <!-- maxIdle: Maximum number of idle dB connections to retain in pool.
         Set to -1 for no limit.  See also the DBCP documentation on this
         and the minEvictableIdleTimeMillis configuration parameter.
         -->

    <!-- maxWait: 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.
         -->

    <!-- username and password: MySQL dB username and password for dB connections  -->

    <!-- driverClassName: Class name for the old mm.mysql JDBC driver is
         org.gjt.mm.mysql.Driver - we recommend using Connector/J though.
         Class name for the official MySQL Connector/J driver is com.mysql.jdbc.Driver.
         -->
   
    <!-- url: 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.
         -->

  <Resource name="jdbc/a" auth="Container" type="javax.sql.DataSource"
               maxActive="100" maxIdle="30" maxWait="10000"
               username="sa" password="123456" driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
               url="jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=university"/>

</Context>

或者

Tomcat 4

<Context path="/sqlserver" docBase="/sqlserver" debug="0" reloadable="true" crossContext="true">  
<Resource name="jdbc/sqlserver" auth="Container" type="javax.sql.DataSource"/>  
     <ResourceParams name="jdbc/sqlserver">
         <parameter> 
               <name>factory</name> 
                   <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> 
          </parameter>    
                 <parameter> 
     <name>driverClassName</name> 
     <value>com.microsoft.jdbc.sqlserver.SQLServerDriver</value> 
          </parameter>    
      <parameter>
                  <name>url</name> 
                  <value>jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=university</value>   
        </parameter> 
          <parameter>       
                        <name>username</name> 
                        <value>sa</value>    
                 </parameter> 
     <parameter>      
                 <name>password</name>      
           <value>123456</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>

的内容。

然后在所建项目中的WEB-INF中新建一个web.xml文件，内容如下：

<?xml version="1.0" encoding="ISO-8859-1"?>
<web-app xmlns="http://java.sun.com/xml/ns/j2ee"
    xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd"
    version="2.4">
  <description>MySQL Test App</description>
  <resource-ref>
      <description>DB Connection</description>
      <res-ref-name>jdbc/a</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
  </resource-ref>
</web-app>

OK！大功告成！！！

注意：Tomcat 5.5 和Tomcat 4的配置区别！！！