配置成功的连接池TOMCAT + Mysql

<!--$TOMCAT_HOME/conf/server.xml is as follow:-->
<?xml version="1.0" encoding="UTF-8"?>
<Srever>
<Listener className="org.apache.catalina.core.AprLifecycleListener"/>
<Listener className="org.apache.catalina.mbeans.GlobalResourceLifecycleListener">
<Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleLister">
<GlobalNamingResources>
<Environment
name="simpleValue"
type="java.lang.integer"
value="30"/>
<Resource
auth="Container"
description="User database that can be updated and saved"
name="UserDatabase"
type="org.apache.catalina.UserDatabase"
pathname="conf/tomcat-users.xml"
factory="org.apache.catalina.users.MemoryUserDatabaseFactory"/>
<Resource
name="jdbc/Agency"
type="javax.sql.DataSource"
driverClassName="com.mysql.jdbc.Driver"
url="jdbc:mysql://192.168.215.128:3306/Agency"
username="mysql"
password=""
maxActive="400"
maxIdle="20"
maxWait="5000"
validationQuery="SELECT 1"/>
</GlobalNamingResource>
<Service
name="Catalina">
<Connector
port="8080"
redirectPort="8443"
minSpareThreads="25"
connectionTimeout="20000"
maxThreads="150"
maxSpareThreads="75"
maxHttpHeaderSize="8192">
</Connector>
<Connector
port="8009"
redirectPort="8443"
protocol="AJP/1.3">
</Connector>
<Engine
defaultHost="localhost"
name="Catalina">
<Realm className="org.apache.catalina.realm.UserDatabaseRealm"/>
<Host
appBase="webapps"
name="localhost">
<Context
crossContext="true"
path="/ROOT"
reloadable="true">
<Resource
auth="Container"
name="jdbc/Agency"
type="javax.sql.DataSource"/>
</Context>
</Host>
</Engine>
</Service>
</Server>

/webapps/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">

<display-name>Welcome to Tomcat</display-name>
<description>
Welcome to Tomcat
</description>
<resouce-ref>
<description>DB Connection</description>
<res-ref-name>jdbc/Agency</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resouce-ref>

<!--JSPC servlet mappings start -->
<servlet>
<servlet-name>org.apache.jsp.index_jsp</servlet-name>
<servlet-class>org.apache.jsp.index_jsp</servlet-class>
</servlet>

<servlet-mapping>
<servlet-name>org.apache.jsp.index_jsp</servlet-name>
<url-pattern>/index.jsp</url-pattern>
</servlet-mapping>
<!--JSPC servlet mappings end-->
</web-app>