DBCP example found at https://github.com/ColbyLeclerc/blog-connection-pools/blob/master/src/main/java/database/DBCPDatabase.java

Connector.java

//See https://github.com/ColbyLeclerc/blog-connection-pools/blob/master/src/main/java/database/DBCPDatabase.java
package database;
import org.apache.commons.dbcp2.BasicDataSource;
import java.sql.SQLException;

public class DBCPDatabase {

    private static BasicDataSource dataSource;

    //Insert log4j statement

    public static BasicDataSource getDataSource() {

        if (dataSource == null) {

            BasicDataSource ds = new BasicDataSource();

            ds.setUrl("jdbc:sqlserver://localhost;databaseName=testdba");
            ds.setUsername("testdb");
            ds.setPassword("W91gLUJWfRS3sg37");

            ds.setDriverClassName("com.microsoft.sqlserver.jdbc.SQLServerDriver");

            ds.setInitialSize(3);
            ds.setMaxTotal(25);
            ds.setMinIdle(0);
            ds.setMaxIdle(8);
            ds.setMaxOpenPreparedStatements(100);

            dataSource = ds;
        }

        return dataSource;
    }

    public static void shutdown() {
        if (dataSource != null){
            try {
                dataSource.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    }

}