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); }
poolConfig.setFairQueue(useFairQueue); poolConfig.setIgnoreExceptionOnPreLoad(ignoreExceptionOnPreLoad); poolConfig.setInitialSize(initialSize); poolConfig.setInitSQL(initializationQuery); poolConfig.setLogAbandoned(logAbandonedConnections);
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; }
properties.setInitialSize(getIntProperty(config, "initialPoolSize", 5)); properties.setMaxActive(getIntProperty(config, "maxPoolSize", 30)); properties.setMinIdle(getIntProperty(config, "minPoolSize", 5));
poolProperties.setInitialSize(Integer.parseInt(initSize));
pool.setValidationQuery("SELECT 1");// SELECT 1(mysql) select 1 from dual(oracle) pool.setInitialSize(5); pool.setMaxActive(3); ds_JDBC.setPoolProperties( pool );
p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60);
p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60);
p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60);
p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60);
poolProperties.setMaxActive(maxPoolSize); poolProperties.setMaxIdle(maxPoolSize); poolProperties.setInitialSize(startPoolSize); poolProperties.setMaxWait(timeout); poolProperties.setRemoveAbandonedTimeout(abandonedTimeout);
poolProperties.setMaxActive(maxPoolSize); poolProperties.setMaxIdle(maxPoolSize); poolProperties.setInitialSize(startPoolSize); poolProperties.setMaxWait(timeout); poolProperties.setRemoveAbandonedTimeout(abandonedTimeout);
poolProperties.setTimeBetweenEvictionRunsMillis(30000); poolProperties.setMaxActive(maxConnections); poolProperties.setInitialSize(10 > maxConnections ? maxConnections : 10); poolProperties.setMaxWait(10000); poolProperties.setRemoveAbandonedTimeout(60);
public void initPool (){ if (mysql_pool == null) { PoolProperties p = new PoolProperties(); p.setUrl("jdbc:mysql://"+ System.getenv("OPENSHIFT_MYSQL_DB_HOST")+ ":" +System.getenv("OPENSHIFT_MYSQL_DB_PORT")+"/development"); p.setDriverClassName("com.mysql.jdbc.Driver"); p.setUsername("myusername"); p.setPassword("andmyownsecretpassword"); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000); p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60); p.setMinEvictableIdleTimeMillis(30000); p.setMinIdle(10); p.setLogAbandoned(true); p.setRemoveAbandoned(true); p.setJdbcInterceptors("org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;" + "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"); mysql_pool = new DataSource(); mysql_pool.setPoolProperties(p); }
p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(dbPool); p.setInitialSize(5); p.setMaxWait(30000); p.setRemoveAbandonedTimeout(60);
props.setUsername("brettw"); props.setPassword(""); props.setInitialSize(MIN_POOL_SIZE); props.setMinIdle(MIN_POOL_SIZE); props.setMaxIdle(maxPoolSize);
p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60);
@Bean public DataSource dataSource(){ PoolProperties p = new PoolProperties(); p.setUrl("jdbc:mysql://localhost:3306/mysql"); p.setDriverClassName("com.mysql.jdbc.Driver"); p.setUsername("root"); p.setPassword("password"); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000); p.setTimeBetweenEvictionRunsMillis(30000); p.setMaxActive(100); p.setInitialSize(10); p.setMaxWait(10000); p.setRemoveAbandonedTimeout(60); p.setMinEvictableIdleTimeMillis(30000); p.setMinIdle(10); p.setLogAbandoned(true); p.setRemoveAbandoned(true); p.setJdbcInterceptors( "org.apache.tomcat.jdbc.pool.interceptor.ConnectionState;"+ "org.apache.tomcat.jdbc.pool.interceptor.StatementFinalizer"); DataSource datasource = new DataSource(); datasource.setPoolProperties(p); return datasource ; }
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.setMaxIdle(Config.getInstance().getMySQLMaxPoolSize(PoolIdentifier.MISC)); poolProperties.setMaxActive(Config.getInstance().getMySQLMaxConnections(PoolIdentifier.MISC)); poolProperties.setInitialSize(0); poolProperties.setMaxWait(-1); poolProperties.setRemoveAbandoned(true); 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.setUsername(Config.getInstance().getMySQLUserName()); poolProperties.setPassword(Config.getInstance().getMySQLUserPassword()); poolProperties.setInitialSize(0); poolProperties.setMaxIdle(Config.getInstance().getMySQLMaxPoolSize(PoolIdentifier.LOAD)); poolProperties.setMaxActive(Config.getInstance().getMySQLMaxConnections(PoolIdentifier.LOAD));