tomcat连接池的配置

qmya00

　　tomcat链接池的配置方法有很多，其中有全局数据库连接池、局部数据库连接池
　　我的程序中运用了全局数据库连接池。其中有三个重要的地方
　　1.在$CATALINA_HOME/conf/下的sever.xml中，具体配置内容如下
　　<?xml version="1.0" encoding="UTF-8"?>
<Server>
  <Listener className="org.apache.catalina.core.AprLifecycleListener"/>
  <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/ProbeOnline"
      auth="Container"
      type="javax.sql.DataSource"
      password="67392029"
      driverClassName="oracle.jdbc.driver.OracleDriver"
      maxIdle="2"
      maxWait="5000"
      username="developer"
      url="jdbc:oracle:thin:@172.25.25.138:1521:oraclejpkc"
      maxActive="10"/>
  </GlobalNamingResources>
  <Service
      name="Catalina">
    <Connector
        port="8888"
        redirectPort="8443"
        minSpareThreads="25"
        connectionTimeout="20000"
        maxSpareThreads="75"
        maxThreads="150">
    </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   appBase="D:\workspace\ProbeOnline\WebRoot"   name="localhost">
       <Context path="" docBase="" debug="0" reloadable="true"/>
      </Host>
    </Engine>
  </Service>
</Server>
　　其中第二个resourse尖括号中的内容是关键
　　2.在$CATALINA_HOME/conf/下的context.xml中，具体配置内容如下
　　<?xml version="1.0" encoding="UTF-8"?>
<!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to You under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at
　　http://www.apache.org/licenses/LICENSE-2.0
　　Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
-->
<!-- The contents of this file will be loaded for each web application -->
<Context>
　　<!-- Default set of monitored resources -->
    <WatchedResource>WEB-INF/web.xml</WatchedResource>
   <ResourceLink name="jdbc/ProbeOnline" global="jdbc/ProbeOnline" type="javax.sql.DataSource"/>
    <!-- Uncomment this to disable session persistence across Tomcat restarts -->
    <!--
    <Manager pathname="" />
    -->
　　</Context>
　　3.在程序代码中，获得连接的代码
　　package database.basic;
　　import java.sql.Connection;
import java.sql.SQLException;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.sql.DataSource;
import org.apache.log4j.Logger;
　　import common.Constant;
　　public class PooledDBConnectionFactory 
{ 
 private final static Logger log =Logger.getLogger(PooledDBConnectionFactory.class);
 
 private static DataSource ds = null;
 private static Context ic = null;
　　//建立数据库连接，打开一个Connection
 public static Connection getDBConnection()
 {
  Connection connection = null;
  try
  {
   ic = new InitialContext();
   ds = (DataSource) ic.lookup("java:comp/env/jdbc/ProbeOnline");
   connection = ds.getConnection();
  }
  catch (NamingException e)
  {
   log.error(e);
  }
  catch (SQLException e)
  {
   log.error(e);
  }
  return connection;
 }
}