.toMillis(10L)); ds.setTestWhileIdle(true); ds.setValidationQuery("SELECT 1 FROM dual");
dbcpDataSource.setMaxIdle(getIntProperty(config, "maxPoolSize", 20)); dbcpDataSource.setMaxWait(getIntProperty(config, "checkoutTimeout", 1000)); dbcpDataSource.setValidationQuery(getStringProperty(config, "preferredTestQuery", "SELECT 1")); dbcpDataSource.setMinEvictableIdleTimeMillis(getIntProperty(config, "minEvictableIdleTimeMillis", 1800000));// 30min dbcpDataSource.setTimeBetweenEvictionRunsMillis(getIntProperty(config, "timeBetweenEvictionRunsMillis", 30000)); // 30s
ds.setValidationQuery( value );
BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUsername("username"); dataSource.setPassword("password"); dataSource.setUrl("jdbc:mysql://<host>:<port>/<database>"); dataSource.setMaxActive(10); dataSource.setMaxIdle(5); dataSource.setInitialSize(5); dataSource.setValidationQuery("SELECT 1");
/** * creates a new {@link BasicDataSource} * @param config the properties used for datasource instantiation * @return */ public static BasicDataSource newDataSource(Config config) { BasicDataSource basicDataSource = new BasicDataSource(); PasswordManager passwordManager = PasswordManager.getInstance(ConfigUtils.configToProperties(config)); basicDataSource.setDriverClassName(ConfigUtils.getString(config, ConfigurationKeys.STATE_STORE_DB_JDBC_DRIVER_KEY, ConfigurationKeys.DEFAULT_STATE_STORE_DB_JDBC_DRIVER)); // MySQL server can timeout a connection so need to validate connections before use basicDataSource.setValidationQuery("select 1"); basicDataSource.setTestOnBorrow(true); basicDataSource.setDefaultAutoCommit(false); basicDataSource.setTimeBetweenEvictionRunsMillis(60000); basicDataSource.setUrl(config.getString(ConfigurationKeys.STATE_STORE_DB_URL_KEY)); basicDataSource.setUsername(passwordManager.readPassword( config.getString(ConfigurationKeys.STATE_STORE_DB_USER_KEY))); basicDataSource.setPassword(passwordManager.readPassword( config.getString(ConfigurationKeys.STATE_STORE_DB_PASSWORD_KEY))); basicDataSource.setMinEvictableIdleTimeMillis( ConfigUtils.getLong(config, ConfigurationKeys.STATE_STORE_DB_CONN_MIN_EVICTABLE_IDLE_TIME_KEY, ConfigurationKeys.DEFAULT_STATE_STORE_DB_CONN_MIN_EVICTABLE_IDLE_TIME)); return basicDataSource; }
private JdbcPushDownConnectionManager(KylinConfig config) throws ClassNotFoundException { dataSource = new BasicDataSource(); Class.forName(config.getJdbcDriverClass()); dataSource.setDriverClassName(config.getJdbcDriverClass()); dataSource.setUrl(config.getJdbcUrl()); dataSource.setUsername(config.getJdbcUsername()); dataSource.setPassword(config.getJdbcPassword()); dataSource.setMaxActive(config.getPoolMaxTotal()); dataSource.setMaxIdle(config.getPoolMaxIdle()); dataSource.setMinIdle(config.getPoolMinIdle()); // Default settings dataSource.setTestOnBorrow(true); dataSource.setValidationQuery("select 1"); dataSource.setRemoveAbandoned(true); dataSource.setRemoveAbandonedTimeout(300); }
/** * Default constructor method. * @param config Basic configuration of JDBC source, such as driver name, URL, username, password. * @throws Exception If datasource cannot be connected. */ protected AbstractJdbcAdaptor(AdaptorConfig config) throws ClassNotFoundException { this.config = config; this.dataSourceDef = DataSourceDefProvider.getInstance().getById(config.datasourceId); dataSource = new BasicDataSource(); Class.forName(config.driver); dataSource.setDriverClassName(config.driver); dataSource.setUrl(config.url); dataSource.setUsername(config.username); dataSource.setPassword(config.password); dataSource.setMaxActive(config.poolMaxTotal); dataSource.setMaxIdle(config.poolMaxIdle); dataSource.setMinIdle(config.poolMinIdle); // Default settings dataSource.setTestOnBorrow(true); dataSource.setValidationQuery(getSourceValidationSql()); dataSource.setRemoveAbandoned(true); dataSource.setRemoveAbandonedTimeout(300); DataSourceDefProvider provider = DataSourceDefProvider.getInstance(); DataSourceDef jdbcDs = provider.getById(getDataSourceId()); configurer = new DefaultConfiguer(this, jdbcDs); }
dataSource.setValidationQuery(validationQuery); dataSource.setTestOnBorrow(true);
dataSource.setValidationQuery(validationQuery); dataSource.setTestOnBorrow(true);
/** * Configures an Apache Commons data source with the specified properties. */ private void configureDataSource(@Nonnull final org.apache.commons.dbcp.BasicDataSource dataSource, @Nonnull final com.thinkbiganalytics.db.DataSourceProperties props) { dataSource.setDriverClassLoader(props.getDriverClassLoader()); dataSource.setValidationQuery(props.getValidationQuery()); dataSource.setTestOnBorrow(true); if (props.getProperties() != null) { for (final Map.Entry<Object, Object> entry : props.getProperties().entrySet()) { dataSource.addConnectionProperty((String) entry.getKey(), (String) entry.getValue()); } } }
BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName("oracle.jdbc.driver.OracleDriver"); ds.setUsername("scott"); ds.setPassword("tiger"); ds.setValidationQuery("SELECT 1"); // this is database specific ds.setTestWhileIdle(true); // test the connections every so often ds.setUrl(connectURI); ... while (!shutdown) { Connection conn = dataSource.getConnection(); Statement stmt = conn.createStatement(); ... stmt.close(); // this returns the connection back to the pool instead of really closing // the connection conn.close(); }
@Override public void setValidationQuery(String validationQuery) { delegate.setValidationQuery(validationQuery); }
dataSource.setValidationQuery(validationQuery);
@ManagedAttribute @Description("Set the SQL validation query.") public void setValidationQuery(final String query) { ds.setValidationQuery(query); }
/** * Configures an Apache Commons data source with the specified properties. */ private void configureDataSource(@Nonnull final org.apache.commons.dbcp.BasicDataSource dataSource, @Nonnull final com.thinkbiganalytics.db.DataSourceProperties props) { dataSource.setDriverClassLoader(props.getDriverClassLoader()); dataSource.setValidationQuery(props.getValidationQuery()); dataSource.setTestOnBorrow(true); if (props.getProperties() != null) { for (final Map.Entry<Object, Object> entry : props.getProperties().entrySet()) { dataSource.addConnectionProperty((String) entry.getKey(), (String) entry.getValue()); } } }
if (validate != null && validate && getValidationQuery() != null) { dataSource.setTestOnBorrow(true); dataSource.setValidationQuery(getValidationQuery());
@Bean DataSource dataSource() { BasicDataSource dataSourceConfig = new BasicDataSource(); dataSourceConfig.setDriverClassName("org.postgresql.Driver"); dataSourceConfig.setUrl("jdbc:postgresql://127.0.0.1:5432/databasename"); dataSourceConfig.setUsername("username"); dataSourceConfig.setValidationQuery("SELECT 1"); dataSourceConfig.setPassword("password"); return dataSourceConfig; }
private DataSource getDatasource() { DbConnectorConfig connectorConfig = config.get(); BasicDataSource dataSource = new BasicDataSource(); dataSource.setUsername(connectorConfig.getUser()); dataSource.setPassword(connectorConfig.getPassword()); String uri = connectorConfig.getConnectURI(); isPostgreSQL = uri.startsWith("jdbc:postgresql"); dataSource.setUrl(uri); if (connectorConfig.isUseValidationQuery()) { dataSource.setValidationQuery(connectorConfig.getValidationQuery()); dataSource.setTestOnBorrow(true); } return dataSource; }
private DataSource buildDataSource(DatabaseConfiguration config) { BasicDataSource basicDataSource = new BasicDataSource(); basicDataSource.setUrl(config.getDbUrl().trim()); basicDataSource.setDriverClassName(config.getDriverName().trim()); basicDataSource.setUsername(config.getUserName().trim()); basicDataSource.setPassword(config.getPassword().trim()); basicDataSource.setMaxActive(config.getMaxActive()); basicDataSource.setMaxIdle(config.getMaxIdle()); basicDataSource.setMaxWait(config.getMaxWait()); basicDataSource.setMinIdle(config.getMinIdle()); basicDataSource.setValidationQuery(config.getValidationQuery()); return basicDataSource; }
BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("com.mysql.jdbc.Driver"); dataSource.setUsername("username"); dataSource.setPassword("password"); dataSource.setUrl("jdbc:mysql://<host>:<port>/<database>"); dataSource.setMaxActive(50); dataSource.setMaxIdle(5); dataSource.setInitialSize(5); dataSource.setValidationQuery("SELECT 1");