ds.setDefaultAutoCommit( Boolean.valueOf( value ) );
/** * 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; }
/** * Create data source based on passed options. * * @param opt options that used to build data source * @return the data source */ public static DataSource getDataSource(Options opt) { BasicDataSource bds = new BasicDataSource(); bds.setDriverClassName(opt.getDriverClassName()); bds.setUrl(opt.getJdbcUrl()); bds.setUsername(opt.getUsername()); bds.setPassword(opt.getPassword()); bds.setDefaultAutoCommit(false); return bds; }
@BeforeClass public void setUp() throws Exception { testMetastoreDatabase = TestMetastoreDatabaseFactory.get(); String jdbcUrl = testMetastoreDatabase.getJdbcUrl(); ConfigBuilder configBuilder = ConfigBuilder.create(); BasicDataSource mySqlDs = new BasicDataSource(); mySqlDs.setDriverClassName(ConfigurationKeys.DEFAULT_STATE_STORE_DB_JDBC_DRIVER); mySqlDs.setDefaultAutoCommit(false); mySqlDs.setUrl(jdbcUrl); mySqlDs.setUsername(TEST_USER); mySqlDs.setPassword(TEST_PASSWORD); dbJobStateStore = new MysqlStateStore<>(mySqlDs, TEST_STATE_STORE, false, JobState.class); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_URL_KEY, jdbcUrl); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_USER_KEY, TEST_USER); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_PASSWORD_KEY, TEST_PASSWORD); ClassAliasResolver<DatasetStateStore.Factory> resolver = new ClassAliasResolver<>(DatasetStateStore.Factory.class); DatasetStateStore.Factory stateStoreFactory = resolver.resolveClass("mysql").newInstance(); dbDatasetStateStore = stateStoreFactory.createStateStore(configBuilder.build()); // clear data that may have been left behind by a prior test run dbJobStateStore.delete(TEST_JOB_NAME); dbDatasetStateStore.delete(TEST_JOB_NAME); dbJobStateStore.delete(TEST_JOB_NAME2); dbDatasetStateStore.delete(TEST_JOB_NAME2); }
@BeforeClass public void setUp() throws Exception { this.testMetastoreDatabase = TestMetastoreDatabaseFactory.get(); String jdbcUrl = this.testMetastoreDatabase.getJdbcUrl(); ConfigBuilder configBuilder = ConfigBuilder.create(); BasicDataSource mySqlDs = new BasicDataSource(); mySqlDs.setDriverClassName(ConfigurationKeys.DEFAULT_STATE_STORE_DB_JDBC_DRIVER); mySqlDs.setDefaultAutoCommit(false); mySqlDs.setUrl(jdbcUrl); mySqlDs.setUsername(TEST_USER); mySqlDs.setPassword(TEST_PASSWORD); this.dbJobStateStore = new MysqlStateStore<>(mySqlDs, TEST_STATE_STORE, false, JobState.class); configBuilder.addPrimitive("selection.timeBased.lookbackTime", "10m"); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_TYPE_KEY, "mysql"); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_TABLE_KEY, TEST_STATE_STORE); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_URL_KEY, jdbcUrl); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_USER_KEY, TEST_USER); configBuilder.addPrimitive(ConfigurationKeys.STATE_STORE_DB_PASSWORD_KEY, TEST_PASSWORD); ClassAliasResolver<DatasetStateStore.Factory> resolver = new ClassAliasResolver<>(DatasetStateStore.Factory.class); DatasetStateStore.Factory stateStoreFactory = resolver.resolveClass("mysql").newInstance(); this.config = configBuilder.build(); this.dbDatasetStateStore = stateStoreFactory.createStateStore(configBuilder.build()); // clear data that may have been left behind by a prior test run this.dbJobStateStore.delete(TEST_JOB_NAME1); this.dbDatasetStateStore.delete(TEST_JOB_NAME1); this.dbJobStateStore.delete(TEST_JOB_NAME2); this.dbDatasetStateStore.delete(TEST_JOB_NAME2); }
/** */ public NominatimUpdater(String host, int port, String database, String username, String password) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUrl(String.format("jdbc:postgresql://%s:%d/%s", host, port, database)); dataSource.setUsername(username); dataSource.setPassword(password); dataSource.setDriverClassName(JtsWrapper.class.getCanonicalName()); dataSource.setDefaultAutoCommit(false); exporter = new NominatimConnector(host, port, database, username, password); template = new JdbcTemplate(dataSource); } }
/** * @param host database host * @param port database port * @param database database name * @param username db username * @param password db username's password */ public NominatimConnector(String host, int port, String database, String username, String password) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setUrl(String.format("jdbc:postgres_jts://%s:%d/%s", host, port, database)); dataSource.setUsername(username); dataSource.setPassword(password); dataSource.setDriverClassName(JtsWrapper.class.getCanonicalName()); dataSource.setDefaultAutoCommit(false); template = new JdbcTemplate(dataSource); template.setFetchSize(100000); }
@Override public void setDefaultAutoCommit(boolean defaultAutoCommit) { delegate.setDefaultAutoCommit(defaultAutoCommit); }
/** * @param conf * @return */ public static BasicDataSource getDataSourceFromConfForScheduler(Configuration conf) { BasicDataSource basicDataSource = getDataSourceFromConf(conf); basicDataSource.setDefaultAutoCommit(true); return basicDataSource; }
@ManagedAttribute @Description("Set the default auto-commit state of connections created by this pool.") public void setDefaultAutoCommit(final boolean auto) { ds.setDefaultAutoCommit(auto); }
public static DataSource createSampleDatabaseDataSource() { final BasicDataSource _dataSource = new BasicDataSource(); _dataSource.setDriverClassName("org.hsqldb.jdbcDriver"); _dataSource.setUrl("jdbc:hsqldb:res:orderdb;readonly=true"); _dataSource.setMaxActive(-1); _dataSource.setDefaultAutoCommit(false); return _dataSource; }
private DataSource getCacheOrCreate() { String key = getCacheKey(); DataSource ds = CACHE.get(key); if (ds == null) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(getDriver()); dataSource.setUrl(url); dataSource.setUsername(username); dataSource.setPassword(password); dataSource.setDefaultAutoCommit(true); DataSource existing = CACHE.putIfAbsent(key, dataSource); if (existing != null) { ds = existing; } else { ds = dataSource; } } return ds; }
BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName(DATABASE_DRIVER_CLASS); ds.setUsername(DATABASE_USERNAME); ds.setPassword(DATABASE_PASSWORD); ds.setUrl(DATABASE_URL); ds.setInitialSize(1); ds.setMaxActive(50); ds.setDefaultAutoCommit(false);
BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName(DATABASE_DRIVER_CLASS); ds.setUsername(DATABASE_USERNAME); ds.setPassword(DATABASE_PASSWORD); ds.setUrl(DATABASE_URL); ds.setInitialSize(1); ds.setMaxActive(50); ds.setDefaultAutoCommit(false);
protected void setupDbcp() { org.apache.commons.dbcp.BasicDataSource ds = new org.apache.commons.dbcp.BasicDataSource(); ds.setUrl(jdbcUrl); ds.setUsername("brettw"); ds.setPassword(""); ds.setInitialSize(MIN_POOL_SIZE); ds.setMinIdle(MIN_POOL_SIZE); ds.setMaxIdle(maxPoolSize); ds.setMaxActive(maxPoolSize); ds.setDefaultAutoCommit(false); ds.setTestOnBorrow(true); ds.setValidationQuery("SELECT 1"); DS = ds; }
private void setupDataSource() { setDerbyPaths(); dataSource = new BasicDataSource(); dataSource.setDriverClassName(databaseConfiguration.getDriverClassName()); System.setProperty("hibernate.dialect", databaseConfiguration.getHibernateDialect()); dataSource.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_UNCOMMITTED); dataSource.setMaxActive(databaseConfiguration.getPoolMaxActive()); dataSource.setMinIdle(databaseConfiguration.getPoolMinIdle()); dataSource.setMaxIdle(databaseConfiguration.getPoolMaxIdle()); dataSource.setDefaultAutoCommit(true); dataSource.setInitialSize(databaseConfiguration.getPoolMinIdle()); //Derby blows up if the username of password is empty (even an empty string thats not null). if (databaseConfiguration.getUsername()!=null && databaseConfiguration.getUsername().length()>=1) dataSource.setUsername(databaseConfiguration.getUsername()); if (databaseConfiguration.getPassword()!=null && databaseConfiguration.getPassword().length()>=1) dataSource.setPassword(databaseConfiguration.getPassword()); dataSource.setUrl(databaseConfiguration.getJDBCUri()); }
public DataSource createDataSource() { initializeDriver(); final BasicDataSource ds = new BasicDataSource(); ds.setDefaultAutoCommit(false); ds.setUrl(_jdbcUrl); ds.setMaxActive(getSystemPropertyValue(SYSTEM_PROPERTY_CONNECTION_POOL_MAX_SIZE, -1)); ds.setMinEvictableIdleTimeMillis( getSystemPropertyValue(SYSTEM_PROPERTY_CONNECTION_POOL_MIN_EVICTABLE_IDLE_TIME_MILLIS, 500)); ds.setTimeBetweenEvictionRunsMillis( getSystemPropertyValue(SYSTEM_PROPERTY_CONNECTION_POOL_TIME_BETWEEN_EVICTION_RUNS_MILLIS, 1000)); if (_username != null && _password != null) { ds.setUsername(_username); ds.setPassword(_password); } return ds; }
import org.apache.commons.dbcp.BasicDataSource; static BasicDataSource bds = new BasicDataSource(); @BeforeClass public void setUp() throws Exception { bds.setDefaultAutoCommit(false); bds.setDriverClassName("org.h2.Driver"); bds.setInitialSize(0); bds.setMaxActive(2); bds.setMaxWait(10000); bds.setPassword(null); bds.setUrl("jdbc:h2:mem:test;DB_CLOSE_DELAY=-1"); bds.setUsername("sa"); bds.setValidationQuery("select 1 as test"); } @AfterClass public void tearDown() throws Exception { bds.close(); }
public DataSource createDataSource() { initializeDriver(); BasicDataSource ds = new BasicDataSource(); ds.setDefaultAutoCommit(false); ds.setUrl(_jdbcUrl); ds.setMaxActive(getSystemPropertyValue(SYSTEM_PROPERTY_CONNECTION_POOL_MAX_SIZE, -1)); ds.setMinEvictableIdleTimeMillis(getSystemPropertyValue( SYSTEM_PROPERTY_CONNECTION_POOL_MIN_EVICTABLE_IDLE_TIME_MILLIS, 500)); ds.setTimeBetweenEvictionRunsMillis(getSystemPropertyValue( SYSTEM_PROPERTY_CONNECTION_POOL_TIME_BETWEEN_EVICTION_RUNS_MILLIS, 1000)); if (_username != null && _password != null) { ds.setUsername(_username); ds.setPassword(_password); } return ds; }
private static DataSource setupDataSource() { BasicDataSource ds = new BasicDataSource(); ds.setDriverClassName(getDriver()); ds.setUsername(getUser()); ds.setPassword(getPassword()); ds.setUrl(getConnectionString()); ds.setDefaultAutoCommit(false); ds.setInitialSize(4); ds.setMaxActive(60); ds.setMaxIdle(10); ds.setValidationQuery("/* ping */ SELECT 1");//config to validate against mysql ds.setValidationQueryTimeout(3); ds.setTestOnBorrow(true); ds.setTestOnReturn(true); return ds; }