tomcat 配置全局数据库连接池

在tomcat配置全局数据库连接池，  /conf/context.xml   <context></context> 

以c3p0为例 ，增加以下内容

 <Resource name="jdbc/db1" auth="Container"  
            type="com.mchange.v2.c3p0.ComboPooledDataSource"  
        factory="org.apache.naming.factory.BeanFactory"  
        driverClass="com.mysql.jdbc.Driver"  
            jdbcUrl="jdbc:mysql://127.0.0.1/testdb"  
            user="test"  
            password="test"  
            minPoolSize="30"  
            maxPoolSize="100"  
            maxIdleTime="1800"  
            acquireIncrement="3"  
            maxStatements="10"  
            initialPoolSize="20"  
            idleConnectionTestPeriod="60"  
            acquireRetryAttempts="30"  
            acquireRetryDelay="1000"
            testConnectionOnCheckin="false"  
            breakAfterAcquireFailure="false"  
            testConnectionOnCheckout="true"  /> 

   记得把相关jar(c3p0.jar,mysql-connector-java.jar)放到tomcat的lib下面

   然后在源码中获取数据连接池

 

private DataSource(){
        
        Context ctx;
        try {
            ctx = new  InitialContext();
             Context envContext = (Context)ctx.lookup("java:/comp/env");//java:/comp/env为固定路径  
             ds=(ComboPooledDataSource) envContext.lookup("jdbc/db1");//tomcat中设置的数据源
        } catch (NamingException e) {
            // TODO Auto-generated catch block
            e.printStackTrace();
        }  
               
    }