private void populateProviderWithExtraProps(PoolingConnectionProvider cp, Properties props) throws Exception { Properties copyProps = new Properties(); copyProps.putAll(props); // Remove all the default properties first (they don't always match to setter name, and they are already // been set!) copyProps.remove(PoolingConnectionProvider.DB_DRIVER); copyProps.remove(PoolingConnectionProvider.DB_URL); copyProps.remove(PoolingConnectionProvider.DB_USER); copyProps.remove(PoolingConnectionProvider.DB_PASSWORD); copyProps.remove(PoolingConnectionProvider.DB_MAX_CONNECTIONS); copyProps.remove(PoolingConnectionProvider.DB_VALIDATION_QUERY); copyProps.remove(PoolingConnectionProvider.POOLING_PROVIDER); if (cp instanceof C3p0PoolingConnectionProvider) { copyProps.remove(C3p0PoolingConnectionProvider.DB_MAX_CACHED_STATEMENTS_PER_CONNECTION); copyProps.remove(C3p0PoolingConnectionProvider.DB_VALIDATE_ON_CHECKOUT); copyProps.remove(C3p0PoolingConnectionProvider.DB_IDLE_VALIDATION_SECONDS); copyProps.remove(C3p0PoolingConnectionProvider.DB_DISCARD_IDLE_CONNECTIONS_SECONDS); } setBeanProps(cp.getDataSource(), copyProps); }
PoolingConnectionProvider pooling = new PoolingConnectionProvider( jdbcDriver, jdbcUrl, jdbcUser, jdbcPassword, poolSize, validate);
public PoolingConnectionProvider(String dbDriver, String dbURL, String dbUser, String dbPassword, int maxConnections, String dbValidationQuery) throws SQLException { initialize( dbDriver, dbURL, dbUser, dbPassword, maxConnections, dbValidationQuery); }
PoolingConnectionProvider cp = new PoolingConnectionProvider( dsDriver, dsURL, dsUser, dsPass, dsCnt, dsValidation);
public PoolingConnectionProvider(String dbDriver, String dbURL, String dbUser, String dbPassword, int maxConnections, String dbValidationQuery) throws SQLException { initialize( dbDriver, dbURL, dbUser, dbPassword, maxConnections, dbValidationQuery); }
PoolingConnectionProvider cp = new PoolingConnectionProvider( dsDriver, dsURL, dsUser, dsPass, dsCnt, dsValidation);
/** * Create a connection pool using the given properties. * * <p> * The properties passed should contain: * <UL> * <LI>{@link #DB_DRIVER}- The database driver class name * <LI>{@link #DB_URL}- The database URL * <LI>{@link #DB_USER}- The database user * <LI>{@link #DB_PASSWORD}- The database password * <LI>{@link #DB_MAX_CONNECTIONS}- The maximum # connections in the pool, * optional * <LI>{@link #DB_VALIDATION_QUERY}- The sql validation query, optional * </UL> * </p> * * @param config * configuration properties */ public PoolingConnectionProvider(Properties config) throws SQLException { PropertiesParser cfg = new PropertiesParser(config); initialize( cfg.getStringProperty(DB_DRIVER), cfg.getStringProperty(DB_URL), cfg.getStringProperty(DB_USER, ""), cfg.getStringProperty(DB_PASSWORD, ""), cfg.getIntProperty(DB_MAX_CONNECTIONS, DEFAULT_DB_MAX_CONNECTIONS), cfg.getStringProperty(DB_VALIDATION_QUERY)); }
private void populateProviderWithExtraProps(PoolingConnectionProvider cp, Properties props) throws Exception { Properties copyProps = new Properties(); copyProps.putAll(props); // Remove all the default properties first (they don't always match to setter name, and they are already // been set!) copyProps.remove(PoolingConnectionProvider.DB_DRIVER); copyProps.remove(PoolingConnectionProvider.DB_URL); copyProps.remove(PoolingConnectionProvider.DB_USER); copyProps.remove(PoolingConnectionProvider.DB_PASSWORD); copyProps.remove(PoolingConnectionProvider.DB_MAX_CONNECTIONS); copyProps.remove(PoolingConnectionProvider.DB_VALIDATION_QUERY); copyProps.remove(PoolingConnectionProvider.POOLING_PROVIDER); if (cp instanceof C3p0PoolingConnectionProvider) { copyProps.remove(C3p0PoolingConnectionProvider.DB_MAX_CACHED_STATEMENTS_PER_CONNECTION); copyProps.remove(C3p0PoolingConnectionProvider.DB_VALIDATE_ON_CHECKOUT); copyProps.remove(C3p0PoolingConnectionProvider.DB_IDLE_VALIDATION_SECONDS); copyProps.remove(C3p0PoolingConnectionProvider.DB_DISCARD_IDLE_CONNECTIONS_SECONDS); } setBeanProps(cp.getDataSource(), copyProps); }
/** * Create a connection pool using the given properties. * * <p> * The properties passed should contain: * <UL> * <LI>{@link #DB_DRIVER}- The database driver class name * <LI>{@link #DB_URL}- The database URL * <LI>{@link #DB_USER}- The database user * <LI>{@link #DB_PASSWORD}- The database password * <LI>{@link #DB_MAX_CONNECTIONS}- The maximum # connections in the pool, * optional * <LI>{@link #DB_VALIDATION_QUERY}- The sql validation query, optional * </UL> * </p> * * @param config * configuration properties */ public PoolingConnectionProvider(Properties config) throws SQLException { PropertiesParser cfg = new PropertiesParser(config); initialize( cfg.getStringProperty(DB_DRIVER), cfg.getStringProperty(DB_URL), cfg.getStringProperty(DB_USER, ""), cfg.getStringProperty(DB_PASSWORD, ""), cfg.getIntProperty(DB_MAX_CONNECTIONS, DEFAULT_DB_MAX_CONNECTIONS), cfg.getStringProperty(DB_VALIDATION_QUERY)); }