求tomcat5.5中数据库连接池的配置

Question

在service.xml中配置连接池的代码

Answer 1

为什么不去查看 Tomcat 的文档呢？文档里说得非常清楚，而且还有例子！启动 Tomcat，在浏览器的地址栏中输入：http://localhost:8080/tomcat-docs/jndi-datasource-examples-howto.html

Answer 2

<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="Test"
      type="javax.sql.DataSource"
      driverClassName="com.mysql.jdbc.Driver"
      password="root"
      maxIdle="2"
      maxWait="5000"
      username="root"
      url="jdbc:mysql://localhost:3306/jspdev"
      maxActive="4"/>
    <Resource
      name="jdbc/jspdev"
      type="javax.sql.DataSource"
      driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
      password="bn"
      maxIdle="2"
      maxWait="5000"
      username="bn"
      url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=jspdev"
      maxActive="4"/>
    <Resource
      name="jdbc/OA"
      type="javax.sql.DataSource"
      driverClassName="com.microsoft.jdbc.sqlserver.SQLServerDriver"
      password=""
      maxIdle="50"
      maxWait="50"
      username="sa"
      url="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=OA"
      maxActive="1000"/>
  </GlobalNamingResources>
  <Service
      name="Catalina">
    <Connector
        port="8080"
        redirectPort="8443"
        minSpareThreads="25"
        connectionTimeout="20000"
        uRIEncoding="gb2312"
        maxSpareThreads="75"
        maxThreads="150">
    </Connector>
    <Connector
        port="8009"
        redirectPort="8443"
        connectionTimeout="-1"
        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>