List of usage examples for org.apache.commons.dbcp BasicDataSource setMaxActive
public synchronized void setMaxActive(int maxActive)
From source file:com.alibaba.druid.benckmark.pool.Case1.java
public void test_dbcp() throws Exception { final BasicDataSource dataSource = new BasicDataSource(); dataSource.setInitialSize(initialSize); dataSource.setMaxActive(maxActive); dataSource.setMinIdle(minPoolSize);//from w w w . ja v a 2s. co m dataSource.setMaxIdle(maxPoolSize); dataSource.setPoolPreparedStatements(true); dataSource.setDriverClassName(driverClass); dataSource.setUrl(jdbcUrl); dataSource.setPoolPreparedStatements(true); dataSource.setUsername(user); dataSource.setPassword(password); dataSource.setValidationQuery("SELECT 1"); dataSource.setTestOnBorrow(false); for (int i = 0; i < loopCount; ++i) { p0(dataSource, "dbcp", threadCount); } System.out.println(); }
From source file:fr.gouv.diplomatie.applitutoriel.integration.conf.DataSourceConf.java
@Bean public DataSource dataSource() { final BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(driverClassName); dataSource.setUrl(url);// w w w . j a v a 2s .c o m dataSource.setUsername(username); dataSource.setPassword(password); dataSource.setValidationQuery(validationQuery); dataSource.setMaxActive(maxActive); dataSource.setMaxIdle(maxIdle); dataSource.setMaxWait(maxWait); dataSource.setTestOnBorrow(testOnBorrow); dataSource.setTestWhileIdle(testWhileIdle); dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); dataSource.setNumTestsPerEvictionRun(numTestsPerEvictionRun); dataSource.setRemoveAbandoned(removeAbandoned); dataSource.setRemoveAbandonedTimeout(removeAbandonedTimeout); dataSource.setLogAbandoned(logAbandoned); return dataSource; }
From source file:net.certifi.audittablegen.GenericDMR.java
/** * Generate a DataSource from Properties * @param props// w w w . ja v a2 s. c o m * @return BasicDataSource as DataSource */ static DataSource getRunTimeDataSource(Properties props) { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName(props.getProperty("driver", "")); dataSource.setUsername(props.getProperty("username")); dataSource.setPassword(props.getProperty("password")); dataSource.setUrl(props.getProperty("url")); dataSource.setMaxActive(10); dataSource.setMaxIdle(5); dataSource.setInitialSize(5); //dataSource.setValidationQuery("SELECT 1"); return dataSource; }
From source file:$.DataSourceConf.java
@Bean
public DataSource dataSource() {
final BasicDataSource dataSource = new BasicDataSource();
dataSource.setDriverClassName(driverClassName);
dataSource.setUrl(url);/*from w w w. j a v a2s .c o m*/
dataSource.setUsername(username);
dataSource.setPassword(password);
dataSource.setValidationQuery(validationQuery);
dataSource.setMaxActive(maxActive);
dataSource.setMaxIdle(maxIdle);
dataSource.setMaxWait(maxWait);
dataSource.setTestOnBorrow(testOnBorrow);
dataSource.setTestWhileIdle(testWhileIdle);
dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
dataSource.setNumTestsPerEvictionRun(numTestsPerEvictionRun);
dataSource.setRemoveAbandoned(removeAbandoned);
dataSource.setRemoveAbandonedTimeout(removeAbandonedTimeout);
dataSource.setLogAbandoned(logAbandoned);
return dataSource;
}
From source file:com.alibaba.otter.node.etl.common.datasource.impl.DBDataSourceService.java
private DataSource createDataSource(String url, String userName, String password, String driverClassName, DataMediaType dataMediaType, String encoding) { BasicDataSource dbcpDs = new BasicDataSource(); dbcpDs.setInitialSize(initialSize);// ? dbcpDs.setMaxActive(maxActive);// ????? dbcpDs.setMaxIdle(maxIdle);// ?? dbcpDs.setMinIdle(minIdle);// ?0? dbcpDs.setMaxWait(maxWait);// ??-1? dbcpDs.setRemoveAbandoned(true);// ??removeAbandonedTimeout dbcpDs.setLogAbandoned(true);// ?? dbcpDs.setRemoveAbandonedTimeout(removeAbandonedTimeout); // ? dbcpDs.setNumTestsPerEvictionRun(numTestsPerEvictionRun);// ?? dbcpDs.setTestOnBorrow(false);// ?? dbcpDs.setTestOnReturn(false);// ?? dbcpDs.setTestWhileIdle(true);// ???? dbcpDs.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis); // ???????? dbcpDs.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis); // ??????? // ??/*from w w w . j a v a2 s . c o m*/ dbcpDs.setDriverClassName(driverClassName); dbcpDs.setUrl(url); dbcpDs.setUsername(userName); dbcpDs.setPassword(password); if (dataMediaType.isOracle()) { dbcpDs.addConnectionProperty("restrictGetTables", "true"); dbcpDs.setValidationQuery("select 1 from dual"); } else if (dataMediaType.isMysql()) { // open the batch mode for mysql since 5.1.8 dbcpDs.addConnectionProperty("useServerPrepStmts", "false"); dbcpDs.addConnectionProperty("rewriteBatchedStatements", "true"); dbcpDs.addConnectionProperty("zeroDateTimeBehavior", "convertToNull");// 0000-00-00null dbcpDs.addConnectionProperty("yearIsDateType", "false");// ??year?date? dbcpDs.addConnectionProperty("noDatetimeStringSync", "true");// ,??? if (StringUtils.isNotEmpty(encoding)) { if (StringUtils.equalsIgnoreCase(encoding, "utf8mb4")) { dbcpDs.addConnectionProperty("characterEncoding", "utf8"); dbcpDs.setConnectionInitSqls(Arrays.asList("set names utf8mb4")); } else { dbcpDs.addConnectionProperty("characterEncoding", encoding); } } dbcpDs.setValidationQuery("select 1"); } else { logger.error("ERROR ## Unknow database type"); } return dbcpDs; }
From source file:calculus.backend.JpaConfig.java
@Bean public DataSource dataSource() { loadProperties();//from w w w .j a v a2s .co m BasicDataSource driver = new BasicDataSource(); driver.setDriverClassName(this.driver); driver.setUrl(this.url); driver.setUsername(this.user); driver.setPassword(this.pass); driver.setMaxIdle(poolSize); driver.setMaxActive(poolSize); return driver; }
From source file:fr.cnes.sitools.datasource.jdbc.business.SitoolsDataSourceFactory.java
/** * Local creation of a DataSource//from w w w. ja v a 2 s. com * * @param driver * the database driver * @param connectURI * the URI to connect * @param userName * the database user name * @param password * the password * @param schemaOnConnection * the schema on connection * @return SitoolsDataSource a standard data source for SITools */ public SitoolsDataSource setupDataSource(String driver, String connectURI, String userName, String password, String schemaOnConnection) { String key = connectURI + "@" + userName; SitoolsDataSource foundDatasource = dataSources.get(key); if (foundDatasource == null) { BasicDataSource ds = new BasicDataSource(); // OSGi ds.setDriverClassLoader(getClass().getClassLoader()); ds.setDriverClassName(driver); ds.setUsername(userName); ds.setPassword(password); ds.setUrl(connectURI); ds.setMaxActive(10); ds.setInitialSize(1); // ds.setDefaultReadOnly(false); // ds.setDefaultAutoCommit(true); JDBCDataSource jdbcDS = new JDBCDataSource(); jdbcDS.setName(key); jdbcDS.setDriverClass(driver); foundDatasource = new SitoolsDataSource(jdbcDS, ds, schemaOnConnection); dataSources.put(key, foundDatasource); } return foundDatasource; }
From source file:hoot.services.HootServicesSpringConfig.java
@Bean(name = "dataSource") public DataSource dataSource() { BasicDataSource dataSource = new BasicDataSource(); dataSource.setDriverClassName("org.postgresql.Driver"); dataSource.setUrl("jdbc:postgresql://" + env.getProperty("DB_HOST") + ":" + env.getProperty("DB_PORT") + "/" + env.getProperty("DB_NAME")); dataSource.setUsername(env.getProperty("DB_USER")); dataSource.setPassword(env.getProperty("DB_PASSWORD")); dataSource.setInitialSize(25);/*from www .ja v a 2 s . c om*/ dataSource.setMaxActive(90); dataSource.setMaxIdle(30); dataSource.setDefaultAutoCommit(false); dataSource.setRemoveAbandoned(true); dataSource.setLogAbandoned(true); return dataSource; }
From source file:com.tedexis.commons.db.DBSinglePool.java
/** * Crea el pool de conexiones// w w w . j a v a 2s. c o m * * @param configurationDB * @return * @throws ClassNotFoundException */ private BasicDataSource getBasicDataSource(ConfigurationDB configurationDB) throws ClassNotFoundException { BasicDataSource ds = null; if (dataSource == null) { ds = new BasicDataSource(); Class.forName(configurationDB.driverClass); ds.setUrl(configurationDB.url); ds.setDriverClassName(configurationDB.driverClass); ds.setUsername(configurationDB.user); ds.setPassword(configurationDB.password); ds.setInitialSize(configurationDB.poolSize); ds.setMaxActive(configurationDB.poolMaxAct); ds.setMaxIdle(configurationDB.poolMaxIdle); ds.setMaxWait(configurationDB.poolWait); return ds; } return dataSource; }
From source file:fr.cnes.sitools.datasource.jdbc.business.SitoolsSQLDataSourceFactory.java
/** * Local creation of a DataSource// w w w . ja va 2s. co m * * @param driver * the database driver * @param connectURI * the URI to connect * @param userName * the database user name * @param password * the password * @param schemaOnConnection * the schema on connection * @return SitoolsDataSource a standard data source for SITools */ public SitoolsSQLDataSource setupDataSource(String driver, String connectURI, String userName, String password, String schemaOnConnection) { String key = connectURI + "@" + userName; SitoolsSQLDataSource foundDatasource = dataSources.get(key); if (foundDatasource == null) { BasicDataSource ds = new BasicDataSource(); // OSGi ds.setDriverClassLoader(getClass().getClassLoader()); ds.setDriverClassName(driver); ds.setUsername(userName); ds.setPassword(password); ds.setUrl(connectURI); ds.setMaxActive(10); ds.setInitialSize(1); // test that the connection is alive on each request. If not It will be dropped from the pool and another // connection will be created if (!"org.hsqldb.jdbcDriver".equals(driver)) { ds.setTestOnBorrow(true); ds.setValidationQuery("SELECT 1"); } // ds.setDefaultReadOnly(false); // ds.setDefaultAutoCommit(true); JDBCDataSource jdbcDS = new JDBCDataSource(); jdbcDS.setName(key); jdbcDS.setDriverClass(driver); foundDatasource = new SitoolsSQLDataSource(jdbcDS, ds, schemaOnConnection); dataSources.put(key, foundDatasource); } return foundDatasource; }