Commons - DBCP - Database Connection Pools

Maven

<dependency>
  <groupId>commons-dbcp</groupId>
  <artifactId>commons-dbcp</artifactId>
  <version>1.2.1</version>
</dependency>

Sample

This code provides singleton access to an in-memory HSQL data source:

import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSource;

public final class DataSourceManager {

    private static DataSource instance;

    private DataSourceManagerTestData() { }

    public static synchronized DataSource getInstance() {
        if (instance == null) {
            instance = createDataSource();
        }
        return instance;
    }

    public static DataSource createDataSource() {
        BasicDataSource ds = new BasicDataSource();
        ds.setDriverClassName("org.hsqldb.jdbcDriver");
        ds.setUsername("sa");
        //ds.setPassword("");
        ds.setUrl("jdbc:hsqldb:mem:schema");
        return ds;
    }
}