DAOBoneCPAccess.java

package com.ning.metrics.goodwill.dao;

import com.google.inject.Inject;
import com.google.inject.Singleton;
import com.jolbox.bonecp.BoneCPConfig;
import com.jolbox.bonecp.BoneCPDataSource;
import com.ning.metrics.goodwill.binder.config.GoodwillConfig;

import javax.sql.DataSource;

@Singleton
public class DAOBoneCPAccess implements DAOAccess
{
    private final DataSource dataSource;

    @Inject
    public DAOBoneCPAccess(
        GoodwillConfig config
    )
    {
        this(config.getStoreDBHost(), config.getStoreDBPort(), config.getStoreDBName(), config.getStoreDBUsername(), config.getStoreDBPassword());

    }

    public DAOBoneCPAccess(String DBHost,
                               int DBPort,
                               String DBName,
                               String DBUsername,
                               String DBPassword)
    {
        BoneCPConfig boneCPConfig = new BoneCPConfig();

        boneCPConfig.setJdbcUrl(String.format("jdbc:mysql://%s:%d/%s", DBHost, DBPort, DBName));
        boneCPConfig.setUsername(DBUsername);
        boneCPConfig.setPassword(DBPassword);
        boneCPConfig.setMinConnectionsPerPartition(1);
        boneCPConfig.setMaxConnectionsPerPartition(10);
        boneCPConfig.setPartitionCount(1);

        dataSource = new BoneCPDataSource(boneCPConfig);
    }

    @Override
    public DataSource getDataSource()
    {
        return dataSource;
    }
}