tomcat5.5 的连接池配置

service.xml 文件内容：

-------------------------------------------------------------------------------------------------------------------------------------

<?xml version="1.0" encoding="UTF-8"?>

<Server>

<Listener className="org.apache.catalina.mbeans.GlobalResourcesLifecycleListener"/>

<Listener className="org.apache.catalina.storeconfig.StoreConfigLifecycleListener"/>

<Listener className="org.apache.catalina.mbeans.ServerLifecycleListener"/>

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

type="javax.sql.DataSource"

driverClassName="org.postgresql.Driver"

password="pass"

maxIdle="2"

maxWait="5000"

validationQuery="select * from cat"

username="postgres"

url="jdbc:postgresql://localhost:5432/quickstart"

maxActive="4"/>

</GlobalNamingResources>

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

</Host>

</Engine>

</Service>

</Server>