final PoolProperties poolConfig = new PoolProperties(); poolConfig.setAbandonWhenPercentageFull(abandonWhenPercentageFull); poolConfig.setAlternateUsernameAllowed(alternateUsernamesAllowed); poolConfig.setCommitOnReturn(commitOnReturn); poolConfig.setRollbackOnReturn(rollbackOnReturn); poolConfig.setDbProperties(properties); poolConfig.setDefaultAutoCommit(autoCommitByDefault); poolConfig.setDefaultCatalog(defaultCatalog); poolConfig.setDefaultReadOnly(readOnlyByDefault); poolConfig.setDefaultTransactionIsolation(defaultTransactionIsolation.get()); poolConfig.setDriverClassName(driverClass); poolConfig.setFairQueue(useFairQueue); poolConfig.setIgnoreExceptionOnPreLoad(ignoreExceptionOnPreLoad); poolConfig.setInitialSize(initialSize); poolConfig.setInitSQL(initializationQuery); poolConfig.setLogAbandoned(logAbandonedConnections); poolConfig.setLogValidationErrors(logValidationErrors); poolConfig.setMaxActive(maxSize); poolConfig.setMaxIdle(maxSize); poolConfig.setMinIdle(minSize); poolConfig.setMaxAge(getMaxConnectionAge().get().toMilliseconds()); poolConfig.setMaxWait((int) maxWaitForConnection.toMilliseconds()); poolConfig.setMinEvictableIdleTimeMillis((int) minIdleTime.toMilliseconds()); poolConfig.setName(name); poolConfig.setUrl(url); poolConfig.setUsername(user); poolConfig.setPassword(user != null && password == null ? "" : password);
@Override protected javax.sql.DataSource createDataSource(String jdbcUrl, String driver, String user, String pass, Setting poolSetting) { final PoolProperties poolProps = new PoolProperties(); poolProps.setUrl(jdbcUrl); poolProps.setDriverClassName(driver); poolProps.setUsername(user); poolProps.setPassword(pass); return new DataSource(poolProps); } }
private static DataSource getTomcatDataSource() { PoolProperties poolProperties = new PoolProperties(); poolProperties.setUrl(URL + ";TEST=TOMCAT"); // append a dummy URL element to ensure different DB per test poolProperties.setValidationQuery("SELECT 1"); poolProperties.setInitialSize(3); poolProperties.setMaxActive(10); return new org.apache.tomcat.jdbc.pool.DataSource(poolProperties); }
PoolProperties p = new PoolProperties(); p.setUrl(jdbcUrl); p.setDriverClassName(driverClass); p.setUsername(user); p.setPassword(pwd); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000); p.setValidationQueryTimeout(100); p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(5); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60); p.setMinEvictableIdleTimeMillis(30000); p.setMinIdle(5); p.setLogAbandoned(true); p.setRemoveAbandoned(true); p.setJdbcInterceptors( "org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"+ "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"); org.apache.tomcat.jdbc.pool.DataSource ds = new org.apache.tomcat.jdbc.pool.DataSource(); ds.setPoolProperties(p); return ds;
PoolProperties poolProperties = new PoolProperties(); poolProperties.setDefaultAutoCommit(defaultAutoCommit); poolProperties.setDefaultReadOnly(defaultReadOnly); poolProperties.setDefaultTransactionIsolation(getTransactionIsolationLevelInt()); poolProperties.setDefaultCatalog(defaultCatalog); poolProperties.setDriverClassName(driverClassName); poolProperties.setMaxActive(maxActive); poolProperties.setMaxIdle(maxIdle); poolProperties.setMinIdle(minIdle); poolProperties.setInitialSize(initialSize); poolProperties.setMaxWait(maxWait); poolProperties.setTestOnBorrow(testOnBorrow); poolProperties.setTestOnReturn(testOnReturn); poolProperties.setTestOnConnect(testOnConnect); poolProperties.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
public static DataSource getPoolDataSource(String driver, String url, String username, String password, List<Element> connectionPropertyElements) { DataSource dataSource = new DataSource(); PoolProperties poolProperties = new PoolProperties(); poolProperties.setDriverClassName(driver); poolProperties.setUrl(url); poolProperties.setUsername(username); poolProperties.setPassword(password); poolProperties.setMaxIdle(maxIdle); poolProperties.setMinIdle(minIdle); poolProperties.setInitialSize(initialSize); poolProperties.setMaxActive(maxActive); poolProperties.setMaxWait(maxWait); poolProperties.setTestOnBorrow(testOnBorrow); poolProperties.setValidationQuery(validationQuery); poolProperties.setValidationInterval(validationInterval); poolProperties.setDefaultAutoCommit(defaultAutoCommit); if ("maxIdle".equalsIgnoreCase(elementKey)) { int value = Integer.parseInt(element.getValue()); poolProperties.setMaxIdle(value); } else if ("minIdle".equalsIgnoreCase(elementKey)) { int value = Integer.parseInt(element.getValue()); poolProperties.setMinIdle(value); } else if ("initialSize".equalsIgnoreCase(elementKey)) { int value = Integer.parseInt(element.getValue()); poolProperties.setInitialSize(value); } else if ("maxActive".equalsIgnoreCase(elementKey)) { int value = Integer.parseInt(element.getValue()); poolProperties.setMaxActive(value); } else if ("maxWait".equalsIgnoreCase(elementKey)) {
@Inject private TomcatConnectionPool(OntopSystemSQLSettings settings) { PoolProperties poolProperties = new PoolProperties(); poolProperties.setUrl(settings.getJdbcUrl()); settings.getJdbcDriver() .ifPresent(poolProperties::setDriverClassName); poolProperties.setUsername(settings.getJdbcUser()); poolProperties.setPassword(settings.getJdbcPassword()); poolProperties.setJmxEnabled(true); poolProperties.setTestOnBorrow(keepAlive); if (keepAlive) { .orElse(""); if (driver.contains("oracle")) poolProperties.setValidationQuery("select 1 from dual"); else if (driver.contains("db2")) poolProperties.setValidationQuery("select 1 from sysibm.sysdummy1"); else poolProperties.setValidationQuery("select 1"); poolProperties.setTestOnReturn(false); poolProperties.setMaxActive(maxPoolSize); poolProperties.setMaxIdle(maxPoolSize); poolProperties.setInitialSize(startPoolSize); poolProperties.setMaxWait(timeout); poolProperties.setRemoveAbandonedTimeout(abandonedTimeout); poolProperties.setMinEvictableIdleTimeMillis(timeout); poolProperties.setLogAbandoned(false); poolProperties.setRemoveAbandoned(removeAbandoned);
org.apache.tomcat.jdbc.pool.PoolProperties config = new org.apache.tomcat.jdbc.pool.PoolProperties(); String dbURL = storeMgr.getConnectionURL(); config.setUrl(dbURL); config.setDriverClassName(dbDriver != null ? dbDriver : ""); // Tomcat JDBC Connection Pool doesn't like null driver class name config.setUsername(dbUser); config.setPassword(dbPassword); Properties dbProps = getPropertiesForDriver(storeMgr); config.setDbProperties(dbProps); config.setAbandonWhenPercentageFull(value); config.setInitialSize(size); config.setInitSQL(value); config.setJdbcInterceptors(value); config.setLogAbandoned(Boolean.parseBoolean(value)); config.setMaxActive(size); config.setMaxAge(value); config.setMaxIdle(size); config.setMaxWait(value); config.setMinEvictableIdleTimeMillis(value);
@Override public DataSource build(DataSourceConfig config, boolean withDefaultValue) { PoolProperties properties = new PoolProperties(); properties.setUrl(config.getJdbcUrl()); properties.setUsername(config.getUsername()); properties.setPassword(config.getPassword()); properties.setDriverClassName(JdbcDriverClassHelper.getDriverClassNameByJdbcUrl(config.getJdbcUrl())); properties.setInitialSize(getIntProperty(config, "initialPoolSize", 5)); properties.setMaxActive(getIntProperty(config, "maxPoolSize", 30)); properties.setMinIdle(getIntProperty(config, "minPoolSize", 5)); properties.setMaxIdle(getIntProperty(config, "maxPoolSize", 20)); properties.setMaxWait(getIntProperty(config, "checkoutTimeout", 1000)); properties.setValidationQuery(getStringProperty(config, "preferredTestQuery", "SELECT 1")); properties.setMinEvictableIdleTimeMillis(getIntProperty(config, "minEvictableIdleTimeMillis", 300000));// 5min properties.setTimeBetweenEvictionRunsMillis(getIntProperty(config, "timeBetweenEvictionRunsMillis", 30000)); // 30s properties.setNumTestsPerEvictionRun(getIntProperty(config, "numTestsPerEvictionRun", 6)); properties.setValidationQueryTimeout(getIntProperty(config, "validationQueryTimeout", 0)); properties.setValidationInterval(getIntProperty(config, "validationInterval", 30000));// 30s properties.setRemoveAbandonedTimeout(getIntProperty(config, "removeAbandonedTimeout", 300)); if (StringUtils.isNotBlank(getStringProperty(config, "connectionInitSql", null))) { properties.setInitSQL(getStringProperty(config, "connectionInitSql", null)); properties.setTestWhileIdle(true); properties.setTestOnBorrow(false); properties.setTestOnReturn(false); properties.setRemoveAbandoned(true); } else { try {
private void initConnectionPool() { poolConfig = new PoolProperties(); poolConfig.setName("kiwi-" + (++KIWI_ID)); poolConfig.setUrl(configuration.getJdbcUrl()); poolConfig.setDriverClassName(configuration.getDialect().getDriverClass()); poolConfig.setUsername(configuration.getDbUser()); poolConfig.setPassword(configuration.getDbPassword()); poolConfig.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); poolConfig.setCommitOnReturn(true); poolConfig.setValidationQuery(configuration.getDialect().getValidationQuery()); poolConfig.setLogValidationErrors(true); poolConfig.setTestWhileIdle(true); poolConfig.setTimeBetweenEvictionRunsMillis(5000); poolConfig.setJdbcInterceptors( "org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;" + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer;" + ); } else { poolConfig.setJdbcInterceptors( "org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;" + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer" poolConfig.setSuspectTimeout(30); poolConfig.setLogAbandoned(true);
PoolProperties poolProperties = new PoolProperties(); String url = prop.getProperty(PoolProps.URL.key); poolProperties.setUrl(url); String driverClassName = prop.getProperty(PoolProps.DRIVER_NAME.key); poolProperties.setDriverClassName(driverClassName); poolProperties.setUsername(username); poolProperties.setPassword(password); poolProperties.setInitialSize(Integer.parseInt(initSize)); poolProperties.setMaxActive(Integer.parseInt(maxActive)); poolProperties.setMaxIdle(Integer.parseInt(maxIdle)); poolProperties.setMaxIdle(Integer.parseInt(minIdle)); poolProperties.setMaxWait(Integer.parseInt(waitTime)); poolProperties.setRemoveAbandoned(Boolean.parseBoolean(removeAbandoned)); poolProperties.setRemoveAbandonedTimeout(Integer.parseInt(removeAbandonedTimeout)); poolProperties.setTimeBetweenEvictionRunsMillis(Integer.parseInt(evictionRunMillis)); poolProperties.setMinEvictableIdleTimeMillis( Integer.parseInt(minEvictableIdleTimeMillis));
PoolProperties poolProperties = new PoolProperties(); poolProperties.setDriverClassName("com.mysql.jdbc.Driver"); poolProperties.setUrl(connectionString); poolProperties.setUsername(Config.getInstance().getMySQLUserName()); poolProperties.setPassword(Config.getInstance().getMySQLUserPassword()); poolProperties.setMaxIdle(Config.getInstance().getMySQLMaxPoolSize(PoolIdentifier.MISC)); poolProperties.setMaxActive(Config.getInstance().getMySQLMaxConnections(PoolIdentifier.MISC)); poolProperties.setInitialSize(0); poolProperties.setMaxWait(-1); poolProperties.setRemoveAbandoned(true); poolProperties.setRemoveAbandonedTimeout(60); poolProperties.setTestOnBorrow(true); poolProperties.setValidationQuery("SELECT 1"); poolProperties.setValidationInterval(30000); miscPool = new DataSource(poolProperties); poolProperties = new PoolProperties(); poolProperties.setDriverClassName("com.mysql.jdbc.Driver"); poolProperties.setUrl(connectionString); poolProperties.setUsername(Config.getInstance().getMySQLUserName()); poolProperties.setPassword(Config.getInstance().getMySQLUserPassword()); poolProperties.setInitialSize(0); poolProperties.setMaxIdle(Config.getInstance().getMySQLMaxPoolSize(PoolIdentifier.SAVE)); poolProperties.setMaxActive(Config.getInstance().getMySQLMaxConnections(PoolIdentifier.SAVE)); poolProperties.setMaxWait(-1); poolProperties.setRemoveAbandoned(true); poolProperties.setRemoveAbandonedTimeout(60); poolProperties.setTestOnBorrow(true); poolProperties.setValidationQuery("SELECT 1"); poolProperties.setValidationInterval(30000);
protected void setupTomcat() PoolProperties props = new PoolProperties(); props.setUrl(jdbcUrl); props.setDriverClassName("com.zaxxer.hikari.benchmark.stubs.StubDriver"); props.setUsername("brettw"); props.setPassword(""); props.setInitialSize(MIN_POOL_SIZE); props.setMinIdle(MIN_POOL_SIZE); props.setMaxIdle(maxPoolSize); props.setMaxActive(maxPoolSize); props.setMaxWait(8000); props.setDefaultAutoCommit(false); props.setRollbackOnReturn(true); props.setUseDisposableConnectionFacade(true); props.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState"); //;org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"); props.setTestOnBorrow(true); props.setValidationInterval(1000); props.setValidator(new Validator() { @Override public boolean validate(Connection connection, int validateAction)
protected static javax.sql.DataSource createDatasource(Properties properties) { PoolProperties p = new PoolProperties(); p.setUrl(properties.getProperty("databaseUrl")); p.setDriverClassName(properties.getProperty("databaseDriver")); p.setUsername(properties.getProperty("databaseUser")); p.setPassword(properties.getProperty("databasePassword")); p.setJmxEnabled(false); p.setMaxActive(100); p.setInitialSize(10); DataSource datasource = new DataSource(); datasource.setPoolProperties(p); return datasource; }
org.apache.tomcat.jdbc.pool.PoolProperties pp = new org.apache.tomcat.jdbc.pool.PoolProperties(); pp.setDriverClassName(props.getDriverClassName()); pp.setUrl(props.getJdbcUrl()); pp.setUsername(props.getUsername()); pp.setPassword(props.getPassword()); pp.setDefaultAutoCommit(props.getDefaultAutoCommit()); pp.setTestWhileIdle(true); pp.setTestOnBorrow(true); pp.setDefaultTransactionIsolation(props.getDefaultTransactionIsolation().getValue()); pp.setDbProperties(ExProperties.create(props.getExtPropertiesMap())); ds.setPoolProperties(pp); log.info("Create tomcat datasource for jdbc url : {} , used {}ms",pp.getUrl(),sw.getElapsedMilliseconds());
ds_c3p0.setMaxPoolSize(20); PoolProperties pool = new PoolProperties(); pool.setUrl( prop.getProperty("URL") ); pool.setDriverClassName( prop.getProperty("DriverClass") ); pool.setUsername( prop.getProperty("UserName") ); pool.setPassword( prop.getProperty("Password") ); pool.setValidationQuery("SELECT 1");// SELECT 1(mysql) select 1 from dual(oracle) pool.setInitialSize(5); pool.setMaxActive(3); ds_JDBC.setPoolProperties( pool ); } catch (IOException e) { e.printStackTrace();
private static DataSource getTomcatDataSourceWithDriverClassName() { PoolProperties poolProperties = new PoolProperties(); poolProperties.setUrl(URL + ";TEST=TOMCAT_WITH_CLASSNAME"); // append a dummy URL element to ensure different DB per test poolProperties.setValidationQuery("SELECT 1"); poolProperties.setMinIdle(3); poolProperties.setMaxActive(10); poolProperties.setDriverClassName(ContainerDatabaseDriver.class.getName()); return new org.apache.tomcat.jdbc.pool.DataSource(poolProperties); }
public DataSourceProxy() { this(new PoolProperties()); }
= new org.apache.tomcat.jdbc.pool.PoolProperties(); if (fieldName.equals("user")) { String fieldValue = datasourceMap.get(fieldName); poolProperties.setUsername(fieldValue); LOG.log(Level.INFO, "forced:" + fieldName); } else if (fieldName.equals("password")) { String fieldValue = datasourceMap.get(fieldName); poolProperties.setPassword(fieldValue); LOG.log(Level.INFO, "forced:" + fieldName); } else if (fieldName.equals("url")) { String fieldValue = datasourceMap.get(fieldName); poolProperties.setUrl(fieldValue); poolProperties.setDriverClassName(dsName); poolProperties.setDataSource(null); LOG.log(Level.INFO, "forced:" + fieldName); if (poolProperties.getDataSource() != null) { LOG.log(Level.INFO, "Native Data Source Enabled"); poolProperties.setDataSource(nativeDS); poolProperties.setJmxEnabled(true); return poolProperties;
@Parameterized.Parameters(name = "{index}: {1}") public static Iterable<Object[]> data() throws Exception { final PoolProperties poolProperties = new PoolProperties(); poolProperties.setDriverClassName(DRIVER_CLASS_NAME); poolProperties.setUrl(URL); final org.apache.tomcat.jdbc.pool.DataSource tomcatDataSource = new org.apache.tomcat.jdbc.pool.DataSource(poolProperties);