@Override public DataSource create(Configuration hdpConfig) throws SQLException { LOG.debug("Creating BoneCP connection pool for the MetaStore"); String driverUrl = DataSourceProvider.getMetastoreJdbcDriverUrl(hdpConfig); String user = DataSourceProvider.getMetastoreJdbcUser(hdpConfig); String passwd = DataSourceProvider.getMetastoreJdbcPasswd(hdpConfig); int maxPoolSize = MetastoreConf.getIntVar(hdpConfig, MetastoreConf.ConfVars.CONNECTION_POOLING_MAX_CONNECTIONS); Properties properties = DataSourceProvider.getPrefixedProperties(hdpConfig, BONECP); long connectionTimeout = hdpConfig.getLong(CONNECTION_TIMEOUT_PROPERTY, 30000L); String partitionCount = properties.getProperty(PARTITION_COUNT_PROPERTY, "1"); BoneCPConfig config = null; try { config = new BoneCPConfig(properties); } catch (Exception e) { throw new SQLException("Cannot create BoneCP configuration: ", e); } config.setJdbcUrl(driverUrl); // if we are waiting for connection for a long time, something is really wrong // better raise an error than hang forever // see DefaultConnectionStrategy.getConnectionInternal() config.setConnectionTimeoutInMs(connectionTimeout); config.setMaxConnectionsPerPartition(maxPoolSize); config.setPartitionCount(Integer.parseInt(partitionCount)); config.setUser(user); config.setPassword(passwd); return initMetrics(new BoneCPDataSource(config)); }
config.setPassword(password); config.setMinConnectionsPerPartition(10); config.setMaxConnectionsPerPartition(20); config.setPartitionCount(1);
config.setPassword(password); config.setMinConnectionsPerPartition(10); config.setMaxConnectionsPerPartition(20); config.setPartitionCount(1);
public JDBCManager(String driver, String connectionUri, int nConnectionsPool, String userName, String password) throws SQLException, ClassNotFoundException { Class.forName(driver); BoneCPConfig config = new BoneCPConfig(); config.setJdbcUrl(connectionUri); config.setMinConnectionsPerPartition(nConnectionsPool); config.setMaxConnectionsPerPartition(nConnectionsPool); config.setUsername(userName); config.setPassword(password); config.setPartitionCount(1); config.setDefaultAutoCommit(false); connectionPool = new BoneCP(config); // setup the connection pool }
config.setMaxConnectionsPerPartition(poolMaxSize);
public JDBCManager(String driver, String connectionUri, int nConnectionsPool, String userName, String password) throws SQLException, ClassNotFoundException { Class.forName(driver); BoneCPConfig config = new BoneCPConfig(); config.setJdbcUrl(connectionUri); config.setMinConnectionsPerPartition(nConnectionsPool); config.setMaxConnectionsPerPartition(nConnectionsPool); config.setUsername(userName); config.setPassword(password); config.setPartitionCount(1); config.setDefaultAutoCommit(false); connectionPool = new BoneCP(config); // setup the connection pool }
@Override public DataSource create(Configuration hdpConfig) throws SQLException { LOG.debug("Creating BoneCP connection pool for the MetaStore"); String driverUrl = DataSourceProvider.getMetastoreJdbcDriverUrl(hdpConfig); String user = DataSourceProvider.getMetastoreJdbcUser(hdpConfig); String passwd = DataSourceProvider.getMetastoreJdbcPasswd(hdpConfig); int maxPoolSize = MetastoreConf.getIntVar(hdpConfig, MetastoreConf.ConfVars.CONNECTION_POOLING_MAX_CONNECTIONS); Properties properties = DataSourceProvider.getPrefixedProperties(hdpConfig, BONECP); long connectionTimeout = hdpConfig.getLong(CONNECTION_TIMEOUT_PROPERTY, 30000L); String partitionCount = properties.getProperty(PARTITION_COUNT_PROPERTY, "1"); BoneCPConfig config = null; try { config = new BoneCPConfig(properties); } catch (Exception e) { throw new SQLException("Cannot create BoneCP configuration: ", e); } config.setJdbcUrl(driverUrl); //if we are waiting for connection for a long time, something is really wrong //better raise an error than hang forever //see DefaultConnectionStrategy.getConnectionInternal() config.setConnectionTimeoutInMs(connectionTimeout); config.setMaxConnectionsPerPartition(maxPoolSize); config.setPartitionCount(Integer.parseInt(partitionCount)); config.setUser(user); config.setPassword(passwd); return new BoneCPDataSource(config); }
BoneCPConfig config = new BoneCPConfig(); config.setJdbcUrl(driverUrl); config.setMaxConnectionsPerPartition(10); config.setPartitionCount(1); config.setUser(user);
BoneCPConfig config = new BoneCPConfig(); config.setJdbcUrl(driverUrl); config.setMaxConnectionsPerPartition(10); config.setPartitionCount(1); config.setUser(user);
config.setPartitionCount(parseInt(getProperty("database.pool.partitions", properties))); config.setMinConnectionsPerPartition(parseInt(getProperty("database.pool.connections.min", properties))); config.setMaxConnectionsPerPartition(parseInt(getProperty("database.pool.connections.max", properties)));
private DataSource getBoneCPDatSource() { final BoneCPConfig dbConfig = new BoneCPConfig(); dbConfig.setJdbcUrl(config.getJdbcUrl()); dbConfig.setUsername(config.getUsername()); dbConfig.setPassword(config.getPassword()); dbConfig.setMinConnectionsPerPartition(config.getMinIdle()); dbConfig.setMaxConnectionsPerPartition(config.getMaxActive()); dbConfig.setConnectionTimeout(config.getConnectionTimeout().getPeriod(), config.getConnectionTimeout().getUnit()); /* dbConfig.setIdleMaxAge(config.getIdleMaxAge().getPeriod(), config.getIdleMaxAge().getUnit()); dbConfig.setMaxConnectionAge(config.getMaxConnectionAge().getPeriod(), config.getMaxConnectionAge().getUnit()); dbConfig.setIdleConnectionTestPeriod(config.getIdleConnectionTestPeriod().getPeriod(), config.getIdleConnectionTestPeriod().getUnit()); */ dbConfig.setPartitionCount(1); dbConfig.setDisableJMX(false); return new BoneCPDataSource(dbConfig); }
dbConfig.setPassword(config.getPassword()); dbConfig.setMinConnectionsPerPartition(config.getMinIdle()); dbConfig.setMaxConnectionsPerPartition(config.getMaxActive()); dbConfig.setConnectionTimeout(config.getConnectionTimeout().getPeriod(), config.getConnectionTimeout().getUnit()); dbConfig.setIdleMaxAge(config.getIdleMaxAge().getPeriod(), config.getIdleMaxAge().getUnit());
if (size >= 0) ds.setMaxConnectionsPerPartition(size);