Java Code Examples for org.apache.tomcat.jdbc.pool.PoolProperties#setConnectionProperties()
The following examples show how to use
org.apache.tomcat.jdbc.pool.PoolProperties#setConnectionProperties() .
You can vote up the ones you like or vote down the ones you don't like,
and go to the original project or source file by following the links above each example. You may check out the related API usage on the sidebar.
Example 1
Source File: PoolPropertiesHelper.java From das with Apache License 2.0 | 5 votes |
public PoolProperties copy(PoolProperties from) { PoolProperties properties = new PoolProperties(); properties.setUrl(from.getUrl()); properties.setUsername(from.getUsername()); properties.setPassword(from.getPassword()); properties.setDriverClassName(from.getDriverClassName()); properties.setTestWhileIdle(from.isTestWhileIdle()); properties.setTestOnBorrow(from.isTestOnBorrow()); properties.setTestOnReturn(from.isTestOnReturn()); properties.setValidationQuery(from.getValidationQuery()); properties.setValidationQueryTimeout(from.getValidationQueryTimeout()); properties.setValidationInterval(from.getValidationInterval()); properties.setTimeBetweenEvictionRunsMillis(from.getTimeBetweenEvictionRunsMillis()); properties.setMinEvictableIdleTimeMillis(from.getMinEvictableIdleTimeMillis()); properties.setMaxAge(from.getMaxAge()); properties.setMaxActive(from.getMaxActive()); properties.setMinIdle(from.getMinIdle()); properties.setMaxWait(from.getMaxWait()); properties.setInitialSize(from.getInitialSize()); properties.setRemoveAbandonedTimeout(from.getRemoveAbandonedTimeout()); properties.setRemoveAbandoned(from.isRemoveAbandoned()); properties.setLogAbandoned(from.isLogAbandoned()); properties.setConnectionProperties(from.getConnectionProperties()); properties.setValidatorClassName(from.getValidatorClassName()); properties.setInitSQL(from.getInitSQL()); properties.setJmxEnabled(from.isJmxEnabled()); properties.setJdbcInterceptors(from.getJdbcInterceptors()); return properties; }
Example 2
Source File: PooledConnectionTomcat.java From gemfirexd-oss with Apache License 2.0 | 5 votes |
@SuppressWarnings("unchecked") private static PoolProperties getPoolProperties() { Endpoint locatorEndPoint = (Endpoint) (NetworkServerHelper.getNetworkLocatorEndpoints()).get(0); String hostname = getHostNameFromEndpoint(locatorEndPoint); int port = getPortFromEndpoint(locatorEndPoint); connProp.putAll(getExtraConnProp()); PoolProperties p = new PoolProperties(); StringBuilder sb = new StringBuilder(); for (Iterator iter = connProp.entrySet().iterator(); iter.hasNext(); ) { Map.Entry<String, String> entry = (Map.Entry<String, String>) iter.next(); sb.append(entry.getKey() + "=" + entry.getValue() +";"); } int lastIndex = sb.lastIndexOf(";"); if (lastIndex != -1) sb.deleteCharAt(lastIndex); p.setConnectionProperties(sb.toString()); Log.getLogWriter().info("Tomcat data source setting the following connection prop: " + sb.toString()); p.setUrl(protocol + hostname+ ":" + port); p.setDriverClassName(driver); return p; }
Example 3
Source File: DatabasePoolConfigParser.java From dal with Apache License 2.0 | 5 votes |
public DatabasePoolConfig getDatabasePoolConfig(String name) { DataSourceConfigure configure = DataSourceConfigureLocatorManager.getInstance().getDataSourceConfigure(name); PoolProperties poolProperties = new PoolProperties(); poolProperties.setTestWhileIdle(configure.getBooleanProperty(TESTWHILEIDLE, DEFAULT_TESTWHILEIDLE)); poolProperties.setTestOnBorrow(configure.getBooleanProperty(TESTONBORROW, DEFAULT_TESTONBORROW)); poolProperties.setTestOnReturn(configure.getBooleanProperty(TESTONRETURN, DEFAULT_TESTONRETURN)); poolProperties.setValidationQuery(configure.getProperty(VALIDATIONQUERY, DEFAULT_VALIDATIONQUERY)); poolProperties.setValidationQueryTimeout( configure.getIntProperty(VALIDATIONQUERYTIMEOUT, DEFAULT_VALIDATIONQUERYTIMEOUT)); poolProperties.setValidationInterval(configure.getLongProperty(VALIDATIONINTERVAL, DEFAULT_VALIDATIONINTERVAL)); poolProperties.setTimeBetweenEvictionRunsMillis( configure.getIntProperty(TIMEBETWEENEVICTIONRUNSMILLIS, DEFAULT_TIMEBETWEENEVICTIONRUNSMILLIS)); poolProperties.setMinEvictableIdleTimeMillis(DEFAULT_MINEVICTABLEIDLETIMEMILLIS); poolProperties.setMaxAge(configure.getIntProperty(MAX_AGE, DEFAULT_MAXAGE)); poolProperties.setMaxActive(configure.getIntProperty(MAXACTIVE, DEFAULT_MAXACTIVE)); poolProperties.setMinIdle(configure.getIntProperty(MINIDLE, DEFAULT_MINIDLE)); poolProperties.setMaxWait(configure.getIntProperty(MAXWAIT, DEFAULT_MAXWAIT)); poolProperties.setInitialSize(configure.getIntProperty(INITIALSIZE, DEFAULT_INITIALSIZE)); poolProperties.setRemoveAbandonedTimeout( configure.getIntProperty(REMOVEABANDONEDTIMEOUT, DEFAULT_REMOVEABANDONEDTIMEOUT)); poolProperties.setRemoveAbandoned(configure.getBooleanProperty(REMOVEABANDONED, DEFAULT_REMOVEABANDONED)); poolProperties.setLogAbandoned(configure.getBooleanProperty(LOGABANDONED, DEFAULT_LOGABANDONED)); poolProperties .setConnectionProperties(configure.getProperty(CONNECTIONPROPERTIES, DEFAULT_CONNECTIONPROPERTIES)); poolProperties.setValidatorClassName(configure.getProperty(VALIDATORCLASSNAME, DEFAULT_VALIDATORCLASSNAME)); poolProperties.setJmxEnabled(DEFAULT_JMXENABLED); poolProperties.setJdbcInterceptors(configure.getProperty(JDBC_INTERCEPTORS, DEFAULT_JDBCINTERCEPTORS)); return new DatabasePoolConfig(poolProperties); }
Example 4
Source File: PooledConnectionTomcat.java From gemfirexd-oss with Apache License 2.0 | 5 votes |
@SuppressWarnings("unchecked") private static PoolProperties getPoolProperties() { Endpoint locatorEndPoint = (Endpoint) (NetworkServerHelper.getNetworkLocatorEndpoints()).get(0); String hostname = getHostNameFromEndpoint(locatorEndPoint); int port = getPortFromEndpoint(locatorEndPoint); connProp.putAll(getExtraConnProp()); PoolProperties p = new PoolProperties(); StringBuilder sb = new StringBuilder(); for (Iterator iter = connProp.entrySet().iterator(); iter.hasNext(); ) { Map.Entry<String, String> entry = (Map.Entry<String, String>) iter.next(); sb.append(entry.getKey() + "=" + entry.getValue() +";"); } int lastIndex = sb.lastIndexOf(";"); if (lastIndex != -1) sb.deleteCharAt(lastIndex); p.setConnectionProperties(sb.toString()); Log.getLogWriter().info("Tomcat data source setting the following connection prop: " + sb.toString()); p.setUrl(protocol + hostname+ ":" + port); p.setDriverClassName(driver); return p; }
Example 5
Source File: PoolPropertiesHelper.java From das with Apache License 2.0 | 4 votes |
public PoolProperties convert(DataSourceConfigure config) { PoolProperties properties = new PoolProperties(); /** * It is assumed that user name/password/url/driver class name are provided in pool config If not, it should be * provided by the config provider */ properties.setUrl(config.getConnectionUrl()); properties.setUsername(config.getUserName()); properties.setPassword(config.getPassword()); properties.setDriverClassName(config.getDriverClass()); properties.setTestWhileIdle(config.getBooleanProperty(TESTWHILEIDLE, DEFAULT_TESTWHILEIDLE)); properties.setTestOnBorrow(config.getBooleanProperty(TESTONBORROW, DEFAULT_TESTONBORROW)); properties.setTestOnReturn(config.getBooleanProperty(TESTONRETURN, DEFAULT_TESTONRETURN)); properties.setValidationQuery(config.getProperty(VALIDATIONQUERY, DEFAULT_VALIDATIONQUERY)); properties.setValidationQueryTimeout( config.getIntProperty(VALIDATIONQUERYTIMEOUT, DEFAULT_VALIDATIONQUERYTIMEOUT)); properties.setValidationInterval(config.getLongProperty(VALIDATIONINTERVAL, DEFAULT_VALIDATIONINTERVAL)); properties.setTimeBetweenEvictionRunsMillis( config.getIntProperty(TIMEBETWEENEVICTIONRUNSMILLIS, DEFAULT_TIMEBETWEENEVICTIONRUNSMILLIS)); properties.setMinEvictableIdleTimeMillis( config.getIntProperty(MINEVICTABLEIDLETIMEMILLIS, DEFAULT_MINEVICTABLEIDLETIMEMILLIS)); properties.setMaxAge(config.getIntProperty(MAX_AGE, DEFAULT_MAXAGE)); properties.setMaxActive(config.getIntProperty(MAXACTIVE, DEFAULT_MAXACTIVE)); properties.setMinIdle(config.getIntProperty(MINIDLE, DEFAULT_MINIDLE)); properties.setMaxWait(config.getIntProperty(MAXWAIT, DEFAULT_MAXWAIT)); properties.setInitialSize(config.getIntProperty(INITIALSIZE, DEFAULT_INITIALSIZE)); properties.setRemoveAbandonedTimeout( config.getIntProperty(REMOVEABANDONEDTIMEOUT, DEFAULT_REMOVEABANDONEDTIMEOUT)); properties.setRemoveAbandoned(config.getBooleanProperty(REMOVEABANDONED, DEFAULT_REMOVEABANDONED)); properties.setLogAbandoned(config.getBooleanProperty(LOGABANDONED, DEFAULT_LOGABANDONED)); properties.setConnectionProperties(config.getProperty(CONNECTIONPROPERTIES, DEFAULT_CONNECTIONPROPERTIES)); properties.setValidatorClassName(config.getProperty(VALIDATORCLASSNAME, DEFAULT_VALIDATORCLASSNAME)); String initSQL = config.getProperty(INIT_SQL); if (initSQL != null && !initSQL.isEmpty()) { properties.setInitSQL(initSQL); } String initSQL2 = config.getProperty(INIT_SQL2); if (initSQL2 != null && !initSQL2.isEmpty()) { properties.setInitSQL(initSQL2); } // This are current hard coded as default value properties.setJmxEnabled(DEFAULT_JMXENABLED); properties.setJdbcInterceptors(config.getProperty(JDBC_INTERCEPTORS, DEFAULT_JDBCINTERCEPTORS)); return properties; }
Example 6
Source File: PoolPropertiesHelper.java From dal with Apache License 2.0 | 4 votes |
public PoolProperties convert(DataSourceConfigure config) { PoolProperties properties = new PoolProperties(); /** * It is assumed that user name/password/url/driver class name are provided in pool config If not, it should be * provided by the config provider */ properties.setUrl(config.getConnectionUrl()); properties.setUsername(config.getUserName()); properties.setPassword(config.getPassword()); properties.setDriverClassName(config.getDriverClass()); properties.setTestWhileIdle(config.getBooleanProperty(TESTWHILEIDLE, DEFAULT_TESTWHILEIDLE)); properties.setTestOnBorrow(config.getBooleanProperty(TESTONBORROW, DEFAULT_TESTONBORROW)); properties.setTestOnReturn(config.getBooleanProperty(TESTONRETURN, DEFAULT_TESTONRETURN)); properties.setValidationQuery(config.getProperty(VALIDATIONQUERY, DEFAULT_VALIDATIONQUERY)); properties.setValidationQueryTimeout( config.getIntProperty(VALIDATIONQUERYTIMEOUT, DEFAULT_VALIDATIONQUERYTIMEOUT)); properties.setValidationInterval(config.getLongProperty(VALIDATIONINTERVAL, DEFAULT_VALIDATIONINTERVAL)); properties.setTimeBetweenEvictionRunsMillis( config.getIntProperty(TIMEBETWEENEVICTIONRUNSMILLIS, DEFAULT_TIMEBETWEENEVICTIONRUNSMILLIS)); properties.setMinEvictableIdleTimeMillis( config.getIntProperty(MINEVICTABLEIDLETIMEMILLIS, DEFAULT_MINEVICTABLEIDLETIMEMILLIS)); properties.setMaxAge(config.getIntProperty(MAX_AGE, DEFAULT_MAXAGE)); properties.setMaxActive(config.getIntProperty(MAXACTIVE, DEFAULT_MAXACTIVE)); properties.setMinIdle(config.getIntProperty(MINIDLE, DEFAULT_MINIDLE)); properties.setMaxWait(config.getIntProperty(MAXWAIT, DEFAULT_MAXWAIT)); properties.setInitialSize(config.getIntProperty(INITIALSIZE, DEFAULT_INITIALSIZE)); properties.setRemoveAbandonedTimeout( config.getIntProperty(REMOVEABANDONEDTIMEOUT, DEFAULT_REMOVEABANDONEDTIMEOUT)); properties.setRemoveAbandoned(config.getBooleanProperty(REMOVEABANDONED, DEFAULT_REMOVEABANDONED)); properties.setLogAbandoned(config.getBooleanProperty(LOGABANDONED, DEFAULT_LOGABANDONED)); properties.setConnectionProperties(config.getProperty(CONNECTIONPROPERTIES, DEFAULT_CONNECTIONPROPERTIES)); properties.setValidatorClassName(config.getProperty(VALIDATORCLASSNAME, DEFAULT_VALIDATORCLASSNAME)); String initSQL = config.getProperty(INIT_SQL); if (initSQL != null && !initSQL.isEmpty()) properties.setInitSQL(initSQL); String initSQL2 = config.getProperty(INIT_SQL2); if (initSQL2 != null && !initSQL2.isEmpty()) properties.setInitSQL(initSQL2); // This are current hard coded as default value properties.setJmxEnabled(DEFAULT_JMXENABLED); properties.setJdbcInterceptors(config.getProperty(JDBC_INTERCEPTORS, DEFAULT_JDBCINTERCEPTORS)); return properties; }