Start line:  
End line:  

Snippet Preview

Snippet HTML Code

Stack Overflow Questions
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 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.
 import  org.apache.commons.dbcp.ConnectionFactory;
 import  org.apache.commons.dbcp.PoolableConnectionFactory;
 import  org.apache.commons.dbcp.PoolingDataSource;

A wrapper DataSource which pools connections.

 public final class ConnectionPoolDataSource implements DataSource {
   private final DataSource delegate;
   public ConnectionPoolDataSource(final DataSource underlyingDataSource) {
     if (underlyingDataSource == null) {
       throw new IllegalArgumentException("underlyingDataSource is null");
     ConnectionFactory connectionFactory = new ConnectionFactory() {
       public Connection createConnection() throws SQLException {
         Connection connection = underlyingDataSource.getConnection();
         return connection;
     GenericObjectPool objectPool = new GenericObjectPool();
     objectPool.setTimeBetweenEvictionRunsMillis(60 * 1000L);
     PoolableObjectFactory factory =
             new PoolableConnectionFactory(connectionFactoryobjectPoolnull"SELECT 1"falsefalse);
      = new PoolingDataSource(objectPool);
   public Connection getConnection() throws SQLException {
     return .getConnection();
   public Connection getConnection(String usernameString passwordthrows SQLException {
     return .getConnection(usernamepassword);
   public PrintWriter getLogWriter() throws SQLException {
     return .getLogWriter();
   public void setLogWriter(PrintWriter printWriterthrows SQLException {
   public void setLoginTimeout(int timeoutthrows SQLException {
   public int getLoginTimeout() throws SQLException {
     return .getLoginTimeout();
   public <T> T unwrap(Class<T> ifacethrows SQLException {
     return .unwrap(iface);
   public boolean isWrapperFor(Class<?> ifacethrows SQLException {
     return .isWrapperFor(iface);
New to GrepCode? Check out our FAQ X