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); }
poolConfig.setValidationQuery(validationQuery); poolConfig.setTestOnBorrow(checkConnectionOnBorrow); poolConfig.setTestOnConnect(checkConnectionOnConnect);
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); }
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
pool.setUsername( prop.getProperty("UserName") ); pool.setPassword( prop.getProperty("Password") ); pool.setValidationQuery("SELECT 1");// SELECT 1(mysql) select 1 from dual(oracle)
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;
p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000);
p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000);
p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000);
.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");
.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");
private void createConnectionPool() throws SQLException { PoolProperties props = new PoolProperties(); props.setUrl(this.getUrl()); props.setUsername(this.getUsername()); props.setPassword(this.getPassword()); props.setDriverClassName(this.getDriverClassName()); props.setValidationQuery(this.getValidationQuery()); this.connectionPool = new ConnectionPool(props); }
poolProperties.setPassword(dbPassword); poolProperties.setJmxEnabled(true); poolProperties.setValidationQuery(validationQuery);
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.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(5000);
poolConfig.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); poolConfig.setCommitOnReturn(true); poolConfig.setValidationQuery(configuration.getDialect().getValidationQuery()); poolConfig.setLogValidationErrors(true); poolConfig.setTestWhileIdle(true);
poolConfig.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED); poolConfig.setCommitOnReturn(true); poolConfig.setValidationQuery(configuration.getDialect().getValidationQuery()); poolConfig.setLogValidationErrors(true); poolConfig.setTestWhileIdle(true);
p.setTestWhileIdle(false); p.setTestOnBorrow(true); p.setValidationQuery("SELECT 1"); p.setTestOnReturn(false); p.setValidationInterval(30000);
@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.setRemoveAbandonedTimeout(60); poolProperties.setTestOnBorrow(true); poolProperties.setValidationQuery("SELECT 1"); poolProperties.setValidationInterval(30000); miscPool = new DataSource(poolProperties); poolProperties.setRemoveAbandonedTimeout(60); poolProperties.setTestOnBorrow(true); poolProperties.setValidationQuery("SELECT 1"); poolProperties.setValidationInterval(30000); savePool = new DataSource(poolProperties); poolProperties.setRemoveAbandonedTimeout(60); poolProperties.setTestOnBorrow(true); poolProperties.setValidationQuery("SELECT 1"); poolProperties.setValidationInterval(30000); loadPool = new DataSource(poolProperties);