Java PoolProperties.setInitSQL方法代碼示例

import org.apache.tomcat.jdbc.pool.PoolProperties; //導入方法依賴的package包/類
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(DEFAULT_JDBCINTERCEPTORS);

    return properties;
}
 

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);
}