poolConfig.setRemoveAbandonedTimeout((int) removeAbandonedTimeout.toSeconds()); poolConfig.setTestWhileIdle(checkConnectionWhileIdle); poolConfig.setValidationQuery(validationQuery); poolConfig.setTestOnBorrow(checkConnectionOnBorrow);
properties.setTestWhileIdle(true); properties.setTestOnBorrow(false); properties.setTestOnReturn(false);
connectionPool.setTestWhileIdle(false);
p.setPassword(password); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
p.setPassword("password"); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
connectionPool.setTestWhileIdle(false);
p.setPassword("password"); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
p.setPassword("password"); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
} else if ("testWhileIdle".equalsIgnoreCase(elementKey)) { boolean value = Boolean.parseBoolean(element.getValue()); poolProperties.setTestWhileIdle(value); } else if ("validatorClassName".equalsIgnoreCase(elementKey)) { poolProperties.setValidatorClassName(element.getValue());
poolProperties.setTestWhileIdle(false); poolProperties.setTestOnBorrow(false); poolProperties.setTestOnReturn(false); } else { poolProperties.setTestWhileIdle(false); poolProperties.setTestOnBorrow(true); poolProperties.setTestOnReturn(false);
p.setPassword(dbPasswd); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
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.setUsername("sa"); p.setJmxEnabled(true); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
poolConfig.setValidationQuery(configuration.getDialect().getValidationQuery()); poolConfig.setLogValidationErrors(true); poolConfig.setTestWhileIdle(true); poolConfig.setTimeBetweenEvictionRunsMillis(5000);
poolConfig.setValidationQuery(configuration.getDialect().getValidationQuery()); poolConfig.setLogValidationErrors(true); poolConfig.setTestWhileIdle(true); poolConfig.setTimeBetweenEvictionRunsMillis(5000);
pp.setPassword(props.getPassword()); pp.setDefaultAutoCommit(props.getDefaultAutoCommit()); pp.setTestWhileIdle(true); pp.setTestOnBorrow(true);
p.setPassword(Settings.getInstance().config.database.password); p.setJmxEnabled(false); p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1");
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;
@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.setTestWhileIdle(testWhileIdle);