ConnectionPool Test

gistfile1.java

public class JUnitTest
{
    private PGPoolingDataSource dataSource;
    
    @Before
    public void setup() {
        dataSource = new PGPoolingDataSource();
        dataSource.setServerName("localhost:5432/foo");
        dataSource.setUser("postgres");
        dataSource.setPassword("postgres");
        dataSource.setDataSourceName("myConnectionPool");
        dataSource.setInitialConnections(1);
        dataSource.setMaxConnections(100);
    }
    
    @Test
    public void getConnectionFromPool() throws SQLException {
        dataSource.getConnection();
        dataSource.close();
        dataSource.getConnection();
    }
}