Java PoolProperties.setTestOnConnect方法代码示例

import org.apache.tomcat.jdbc.pool.PoolProperties; //导入方法依赖的package包/类
public void setAllPoolProperties() throws Exception {
	poolProperties = new PoolProperties();

	//todo: probably more ifs to provide more information of which wasn't defined.
	if (url == null || driverClassName == null || userName == null || password == null) {
		throw new Exception("A mandatory item wasn't defined correctly");
	} else {
		//Mandatory items.
		poolProperties.setUrl(url);
		poolProperties.setDriverClassName(driverClassName);
		poolProperties.setUsername(userName);
		poolProperties.setPassword(password);

		//Not Mandatory Items.
		if (abandonWhenPercentageFull != null)
			poolProperties.setAbandonWhenPercentageFull(abandonWhenPercentageFull);
		if (accessToUnderlyingConnectionAllowed != null)
			poolProperties.setAccessToUnderlyingConnectionAllowed(accessToUnderlyingConnectionAllowed);
		if (alternateUsernameAllowed != null) poolProperties.setAlternateUsernameAllowed(alternateUsernameAllowed);
		if (commitOnReturn != null) poolProperties.setCommitOnReturn(commitOnReturn);
		if (connectionProperties != null) poolProperties.setConnectionProperties(connectionProperties);
		if (dataSource != null) poolProperties.setDataSource(dataSource); //todo: probably a problem.
		if (dataSourceJNDI != null) poolProperties.setDataSourceJNDI(dataSourceJNDI);
		if (dbProperties != null) poolProperties.setDbProperties(dbProperties);
		if (defaultAutoCommit != null) poolProperties.setDefaultAutoCommit(defaultAutoCommit);
		if (defaultCatalog != null) poolProperties.setDefaultCatalog(defaultCatalog);
		if (defaultReadOnly != null) poolProperties.setDefaultReadOnly(defaultReadOnly);
		if (defaultTranslationIsolation != null)
			poolProperties.setDefaultTransactionIsolation(defaultTranslationIsolation);
		if (fairQueue != null) poolProperties.setFairQueue(fairQueue);
		if (ignoreExceptionOnPreLoad != null) poolProperties.setIgnoreExceptionOnPreLoad(ignoreExceptionOnPreLoad);
		if (initialSize != null) poolProperties.setInitialSize(initialSize);
		if (initSQL != null) poolProperties.setInitSQL(initSQL);
		if (jdbcInterceptors != null) poolProperties.setJdbcInterceptors(jdbcInterceptors);
		if (jmxEnabled != null) poolProperties.setJmxEnabled(jmxEnabled);
		if (logAbandoned != null) poolProperties.setLogAbandoned(logAbandoned);
		if (logValidationErrors != null) poolProperties.setLogValidationErrors(logValidationErrors);
		if (maxActive != null) poolProperties.setMaxActive(maxActive);
		if (maxAge != null) poolProperties.setMaxAge(maxAge);
		if (maxIdle != null) poolProperties.setMaxIdle(maxIdle);
		if (maxWait != null) poolProperties.setMaxWait(maxWait);
		if (minEvictableIdleTimeMillis != null)
			poolProperties.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
		if (minIdle != null) poolProperties.setMinIdle(minIdle);
		if (name != null) poolProperties.setName(name);
		if (numTestsPerEvictionRun != null) poolProperties.setNumTestsPerEvictionRun(numTestsPerEvictionRun);
		if (propagateInterruptState != null) poolProperties.setPropagateInterruptState(propagateInterruptState);
		if (removeAbandoned != null) poolProperties.setRemoveAbandoned(removeAbandoned);
		if (removeAbandonedTimeout != null) poolProperties.setRemoveAbandonedTimeout(removeAbandonedTimeout);
		if (rollbackOnReturn != null) poolProperties.setRollbackOnReturn(rollbackOnReturn);
		if (suspectTimeout != null) poolProperties.setSuspectTimeout(suspectTimeout);
		if (testOnBorrow != null) poolProperties.setTestOnBorrow(testOnBorrow);
		if (testOnConnect != null) poolProperties.setTestOnConnect(testOnConnect);
		if (testOnReturn != null) poolProperties.setTestOnReturn(testOnReturn);
		if (testWhileIdle != null) poolProperties.setTestWhileIdle(testWhileIdle);
		if (timeBetweenEvictionsRunMillis != null)
			poolProperties.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionsRunMillis);
		if (useDisposableConnectionFacade != null)
			poolProperties.setUseDisposableConnectionFacade(useDisposableConnectionFacade);
		if (useEquals != null) poolProperties.setUseEquals(useEquals);
		if (useLock != null) poolProperties.setUseLock(useLock);
		if (validationInterval != null) poolProperties.setValidationInterval(validationInterval);
		if (validationQuery != null) poolProperties.setValidationQuery(validationQuery);
		if (validationQueryTimeout != null) poolProperties.setValidationQueryTimeout(validationQueryTimeout);
		if (validator != null) poolProperties.setValidator(validator);
		if (validatorClassName != null) poolProperties.setValidatorClassName(validatorClassName);

		//Set the DataSource Provider's Properties.
		dataSourceProvider = new DataSource();
		dataSourceProvider.setPoolProperties(poolProperties);
	}
}
 

import org.apache.tomcat.jdbc.pool.PoolProperties; //导入方法依赖的package包/类
public ArtifactoryTomcatDataSource(StorageProperties s) {
    // see org.apache.tomcat.jdbc.pool.DataSourceFactory.parsePoolProperties()
    PoolProperties p = new PoolProperties();
    p.setUrl(s.getConnectionUrl());
    p.setDriverClassName(s.getDriverClass());
    p.setUsername(s.getUsername());
    p.setPassword(s.getPassword());

    p.setDefaultAutoCommit(false);
    p.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

    p.setInitialSize(s.getIntProperty("initialSize", 1));
    p.setMaxAge(s.getIntProperty("maxAge", 0));
    p.setMaxActive(s.getMaxActiveConnections());
    p.setMaxWait(s.getIntProperty("maxWait", (int) TimeUnit.SECONDS.toMillis(120)));
    p.setMaxIdle(s.getMaxIdleConnections());
    p.setMinIdle(s.getIntProperty("minIdle", 1));
    p.setMinEvictableIdleTimeMillis(
            s.getIntProperty("minEvictableIdleTimeMillis", 300000));
    p.setTimeBetweenEvictionRunsMillis(
            s.getIntProperty("timeBetweenEvictionRunsMillis", 30000));
    p.setInitSQL(s.getProperty("initSQL", null));

    // validation query for all kind of tests (connect, borrow etc.)
    p.setValidationQuery(s.getProperty("validationQuery", getDefaultValidationQuery(s)));
    p.setValidationQueryTimeout(s.getIntProperty("validationQueryTimeout", 30));
    p.setValidationInterval(s.getLongProperty("validationInterval", 30000));
    p.setTestOnBorrow(s.getBooleanProperty("testOnBorrow", true));
    p.setTestWhileIdle(s.getBooleanProperty("testWhileIdle", false));
    p.setTestOnReturn(s.getBooleanProperty("testOnReturn", false));
    p.setTestOnConnect(s.getBooleanProperty("testOnConnect", false));

    p.setRemoveAbandoned(s.getBooleanProperty("removeAbandoned", false));
    p.setRemoveAbandonedTimeout(s.getIntProperty("removeAbandonedTimeout", 600));
    p.setSuspectTimeout(s.getIntProperty("suspectTimeout", 600));
    p.setLogAbandoned(s.getBooleanProperty("logAbandoned", false));
    p.setLogValidationErrors(s.getBooleanProperty("logValidationErrors", false));

    p.setJmxEnabled(s.getBooleanProperty("jmxEnabled", true));

    // only applicable if auto commit is false. has high performance penalty and only protects bugs in the code
    p.setRollbackOnReturn(s.getBooleanProperty("rollbackOnReturn", false));
    p.setCommitOnReturn(s.getBooleanProperty("commitOnReturn", false));

    p.setIgnoreExceptionOnPreLoad(s.getBooleanProperty("ignoreExceptionOnPreLoad", false));

    //p.setJdbcInterceptors(s.getProperty("jdbcInterceptors", "ConnectionState;StatementFinalizer"));
    p.setJdbcInterceptors(s.getProperty("jdbcInterceptors", null));

    p.setDefaultCatalog(s.getProperty("defaultCatalog", null));

    setPoolProperties(p);
}
 

import org.apache.tomcat.jdbc.pool.PoolProperties; //导入方法依赖的package包/类
public static DataSource createUniqueIdDataSource(StorageProperties s) {
    // see org.apache.tomcat.jdbc.pool.DataSourceFactory.parsePoolProperties()
    PoolProperties p = new PoolProperties();
    p.setUrl(s.getConnectionUrl());
    p.setDriverClassName(s.getDriverClass());
    p.setUsername(s.getUsername());
    p.setPassword(s.getPassword());

    // auto commit is true for the unique id generator
    p.setDefaultAutoCommit(true);
    p.setDefaultTransactionIsolation(Connection.TRANSACTION_READ_COMMITTED);

    // only one connection is required for the id generator
    p.setInitialSize(1);
    p.setMinIdle(1);
    p.setMaxIdle(1);
    p.setMaxActive(1);
    p.setMaxAge(s.getIntProperty("maxAge", 0));
    p.setMaxWait(s.getIntProperty("maxWait", (int) TimeUnit.SECONDS.toMillis(120)));
    p.setMinEvictableIdleTimeMillis(
            s.getIntProperty("minEvictableIdleTimeMillis", 300000));
    p.setTimeBetweenEvictionRunsMillis(
            s.getIntProperty("timeBetweenEvictionRunsMillis", 30000));
    p.setInitSQL(s.getProperty("initSQL", null));

    // validation query for all kind of tests (connect, borrow etc.)
    p.setValidationQuery(s.getProperty("validationQuery", getDefaultValidationQuery(s)));
    p.setValidationQueryTimeout(s.getIntProperty("validationQueryTimeout", 30));
    p.setValidationInterval(s.getLongProperty("validationInterval", 30000));
    p.setTestOnBorrow(s.getBooleanProperty("testOnBorrow", true));
    p.setTestWhileIdle(s.getBooleanProperty("testWhileIdle", false));
    p.setTestOnReturn(s.getBooleanProperty("testOnReturn", false));
    p.setTestOnConnect(s.getBooleanProperty("testOnConnect", false));

    p.setRemoveAbandoned(s.getBooleanProperty("removeAbandoned", false));
    p.setRemoveAbandonedTimeout(s.getIntProperty("removeAbandonedTimeout", 600));
    p.setSuspectTimeout(s.getIntProperty("suspectTimeout", 600));
    p.setLogAbandoned(s.getBooleanProperty("logAbandoned", false));
    p.setLogValidationErrors(s.getBooleanProperty("logValidationErrors", false));

    p.setJmxEnabled(false);

    p.setIgnoreExceptionOnPreLoad(s.getBooleanProperty("ignoreExceptionOnPreLoad", false));

    //p.setJdbcInterceptors(s.getProperty("jdbcInterceptors", "ConnectionState;StatementFinalizer"));
    p.setJdbcInterceptors(s.getProperty("jdbcInterceptors", null));

    p.setDefaultCatalog(s.getProperty("defaultCatalog", null));

    return new DataSource(p);
}