tomcat连接池的配置

最新推荐文章于 2025-05-15 09:25:11 发布

最新推荐文章于 2025-05-15 09:25:11 发布 · 136 阅读

文章标签：

#Tomcat #Apache #JDBC #SQL Server #SQL

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

<Context>

<WatchedResource>WEB-INF/web.xml</WatchedResource>
   <ResourceLink name="jdbc/ProbeOnline" global="jdbc/ProbeOnline" type="javax.sql.DataSource"/>

</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;
}
}