Java Code Examples for com.mchange.v2.c3p0.ComboPooledDataSource#setMinPoolSize()
The following examples show how to use
com.mchange.v2.c3p0.ComboPooledDataSource#setMinPoolSize() .
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: DbToolkit.java From LuckyFrameClient with GNU Affero General Public License v3.0 | 6 votes |
public DbToolkit(String urlBase,String usernameBase,String passwordBase){ cpds=new ComboPooledDataSource(); cpds.setUser(usernameBase); cpds.setPassword(passwordBase); cpds.setJdbcUrl(urlBase); try { cpds.setDriverClass(DRIVERCLASS); } catch (PropertyVetoException e) { // TODO Auto-generated catch block e.printStackTrace(); } cpds.setInitialPoolSize(20); cpds.setMaxIdleTime(20); cpds.setMaxPoolSize(30); cpds.setMinPoolSize(1); }
Example 2
Source File: C3P0DataSource.java From maven-framework-project with MIT License | 6 votes |
private C3P0DataSource() throws IOException, SQLException, PropertyVetoException { cpds = new ComboPooledDataSource(); cpds.setDriverClass("org.h2.Driver"); // loads the jdbc driver cpds.setJdbcUrl("jdbc:h2:./target/test;AUTO_SERVER=TRUE"); cpds.setUser("sa"); cpds.setPassword(""); // the settings below are optional -- c3p0 can work with defaults cpds.setMinPoolSize(5); cpds.setAcquireIncrement(5); cpds.setMaxPoolSize(20); cpds.setMaxStatements(180); this.setDataSource(cpds); }
Example 3
Source File: DatasourceConfig.java From libevent with Apache License 2.0 | 6 votes |
@Bean @Primary public DataSource dataSource() throws PropertyVetoException { ComboPooledDataSource rlt = new ComboPooledDataSource(); rlt.setDriverClass("com.mysql.jdbc.Driver"); rlt.setUser("root"); rlt.setPassword("password"); rlt.setJdbcUrl("jdbc:mysql://localhost:3306/libevent_sample"); rlt.setInitialPoolSize(DEFAULT_POOL_SIZE); rlt.setMaxPoolSize(DEFAULT_POOL_SIZE); rlt.setMinPoolSize(DEFAULT_POOL_SIZE); rlt.setTestConnectionOnCheckin(true); rlt.setPreferredTestQuery("select 1"); return rlt; }
Example 4
Source File: DataSourceFactory.java From copper-engine with Apache License 2.0 | 6 votes |
public static ComboPooledDataSource createDataSource(Properties props) { try { final String jdbcUrl = trim(props.getProperty(ConfigParameter.DS_JDBC_URL.getKey())); final String user = trim(props.getProperty(ConfigParameter.DS_USER.getKey())); final String password = trim(props.getProperty(ConfigParameter.DS_PASSWORD.getKey())); final String driverClass = trim(props.getProperty(ConfigParameter.DS_DRIVER_CLASS.getKey())); final int minPoolSize = Integer.valueOf(props.getProperty(ConfigParameter.DS_MIN_POOL_SIZE.getKey(), Integer.toString(Runtime.getRuntime().availableProcessors()))); final int maxPoolSize = Integer.valueOf(props.getProperty(ConfigParameter.DS_MAX_POOL_SIZE.getKey(), Integer.toString(2 * Runtime.getRuntime().availableProcessors()))); ComboPooledDataSource ds = new ComboPooledDataSource(); ds.setJdbcUrl(jdbcUrl.replace("${NOW}", Long.toString(System.currentTimeMillis()))); if (!isNullOrEmpty(user)) ds.setUser(user); if (!isNullOrEmpty(password)) ds.setPassword(password); if (!isNullOrEmpty(driverClass)) ds.setDriverClass(driverClass); ds.setMinPoolSize(minPoolSize); ds.setInitialPoolSize(minPoolSize); ds.setMaxPoolSize(maxPoolSize); return ds; } catch (Exception e) { throw new RuntimeException("Unable to create datasource", e); } }
Example 5
Source File: PoolSQLCommunication.java From BungeecordPartyAndFriends with GNU General Public License v3.0 | 6 votes |
private ComboPooledDataSource createConnection() { try { ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setDriverClass("com.mysql.jdbc.Driver"); cpds.setJdbcUrl("jdbc:mysql://" + MYSQL_DATA.HOST + ":" + MYSQL_DATA.PORT + "/" + MYSQL_DATA.DATABASE); cpds.setProperties(connectionProperties); cpds.setInitialPoolSize(POOL_DATA.INITIAL_POOL_SIZE); cpds.setMinPoolSize(POOL_DATA.MIN_POOL_SIZE); cpds.setMaxPoolSize(POOL_DATA.MAX_POOL_SIZE); cpds.setTestConnectionOnCheckin(POOL_DATA.TEST_CONNECTION_ON_CHECKIN); cpds.setIdleConnectionTestPeriod(POOL_DATA.IDLE_CONNECTION_TEST_PERIOD); return cpds; } catch (PropertyVetoException e) { e.printStackTrace(); } return null; }
Example 6
Source File: C3P0DataSourceFactoryBean.java From cloud-config with MIT License | 6 votes |
private ComboPooledDataSource createNewDataSource() throws Exception { ComboPooledDataSource c3p0DataSource = new ComboPooledDataSource(); c3p0DataSource.setDriverClass(config.getDriverClassName()); //loads the jdbc driver c3p0DataSource.setJdbcUrl(config.getJdbcUrl()); c3p0DataSource.setUser(config.getUserName()); c3p0DataSource.setPassword(config.getPassword()); // the settings below are optional -- c3p0 can work with defaults c3p0DataSource.setMinPoolSize(config.getMinPoolSize()); c3p0DataSource.setMaxPoolSize(config.getMaxPoolSize()); c3p0DataSource.setAcquireIncrement(config.getAcquireIncrement()); c3p0DataSource.setMaxStatements(config.getMaxStatements()); c3p0DataSource.setIdleConnectionTestPeriod(config.getIdleTestPeriod()); c3p0DataSource.setMaxIdleTime(config.getMaxIdleTime()); return c3p0DataSource; }
Example 7
Source File: WordressSqlBackend.java From mxisd with GNU Affero General Public License v3.0 | 5 votes |
public WordressSqlBackend(WordpressConfig cfg) { this.cfg = cfg; ds = new ComboPooledDataSource(); ds.setJdbcUrl("jdbc:" + cfg.getSql().getType() + ":" + cfg.getSql().getConnection()); ds.setMinPoolSize(1); ds.setMaxPoolSize(10); ds.setAcquireIncrement(2); }
Example 8
Source File: ConnectionPoolManager.java From ezScrum with GNU General Public License v2.0 | 5 votes |
private DataSource createDataSource(String driverClass, String url, String account, String password) { ComboPooledDataSource dataSource = new ComboPooledDataSource(); try { dataSource.setDriverClass(driverClass); dataSource.setJdbcUrl(url); dataSource.setUser(account); dataSource.setPassword(password); dataSource.setMinPoolSize(10); dataSource.setMaxPoolSize(35); dataSource.setAcquireIncrement(0); dataSource.setMaxStatements(0); /** 最大允許的閒置時間(秒) */ dataSource.setMaxIdleTime(300); /** 對閒置的連線進行Query測試設置(秒) */ dataSource.setIdleConnectionTestPeriod(1800); /** Checkin connection時不檢查連線是否有效 */ dataSource.setTestConnectionOnCheckin(false); /** Checkout connection時檢查連線的有效性*/ dataSource.setTestConnectionOnCheckout(true); /** 進行test時使用的 Query設定*/ dataSource.setPreferredTestQuery("SELECT 1;"); /** Connection的最大有效時數(秒)*/ dataSource.setMaxConnectionAge(28800); /** Connection checkout 之後的有效時數(毫秒)*/ dataSource.setCheckoutTimeout(28800000); } catch (PropertyVetoException e) { e.printStackTrace(); } mPoolMap.put(url, dataSource); return dataSource; }
Example 9
Source File: CreateC3p0Connection.java From spiracle with Apache License 2.0 | 5 votes |
private ComboPooledDataSource createConnectionPool() throws PropertyVetoException { ComboPooledDataSource ds = new ComboPooledDataSource(); ds.setDriverClass(jdbcDriver); ds.setJdbcUrl(url); ds.setUser(username); ds.setPassword(password); ds.setMinPoolSize(5); ds.setAcquireIncrement(5); ds.setMaxPoolSize(maxPoolSize); return ds; }
Example 10
Source File: DatabaseHandler.java From thundernetwork with GNU Affero General Public License v3.0 | 5 votes |
public static DataSource getDataSource () throws PropertyVetoException { ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setDriverClass("com.mysql.jdbc.Driver"); //loads the jdbc driver cpds.setJdbcUrl("jdbc:mysql://localhost/lightning?user=root"); // the settings below are optional -- c3p0 can work with defaults cpds.setMinPoolSize(2); cpds.setAcquireIncrement(5); cpds.setMaxPoolSize(8); return cpds; }
Example 11
Source File: SqlConnectionPool.java From mxisd with GNU Affero General Public License v3.0 | 5 votes |
public SqlConnectionPool(SqlConfig cfg) { Drivers.load(cfg.getType()); ds = new ComboPooledDataSource(); ds.setJdbcUrl("jdbc:" + cfg.getType() + ":" + cfg.getConnection()); ds.setMinPoolSize(1); ds.setMaxPoolSize(10); ds.setAcquireIncrement(2); ds.setAcquireRetryAttempts(10); ds.setAcquireRetryDelay(1000); }
Example 12
Source File: DAOFactory.java From uavstack with Apache License 2.0 | 5 votes |
protected DAOFactory(String facName, String driverClassName, String jdbcURL, String userName, String userPassword, int initPoolSize, int MinPoolSize, int MaxPoolSize, int maxIdleTime, int idleConnectionTestPeriod, String testQuerySQL) { this.facName = facName; ds = new ComboPooledDataSource(); // 设置JDBC的Driver类 try { ds.setDriverClass(driverClassName); } catch (PropertyVetoException e) { throw new RuntimeException(e); } // 设置JDBC的URL ds.setJdbcUrl(jdbcURL); // 设置数据库的登录用户名 ds.setUser(userName); // 设置数据库的登录用户密码 ds.setPassword(userPassword); // 设置连接池的最大连接数 ds.setMaxPoolSize(MaxPoolSize); // 设置连接池的最小连接数 ds.setMinPoolSize(MinPoolSize); // 设置初始化连接数 ds.setInitialPoolSize(initPoolSize); // 设置最大闲置时间 ds.setMaxIdleTime(maxIdleTime); // 设置测试SQL ds.setPreferredTestQuery(testQuerySQL); // 设置闲置测试周期 ds.setIdleConnectionTestPeriod(idleConnectionTestPeriod); // 增加单个连接的Statements数量 ds.setMaxStatements(0); // 连接池内单个连接所拥有的最大缓存statements数 ds.setMaxStatementsPerConnection(200); // 获取空闲连接超时时间 ds.setCheckoutTimeout(10 * 1000); }
Example 13
Source File: C3P0DataSourceAdapter.java From cloudhopper-commons with Apache License 2.0 | 4 votes |
public ManagedDataSource create(DataSourceConfiguration config) throws SQLMissingDependencyException, SQLConfigurationException { // // http://www.mchange.com/projects/c3p0/index.html#configuration_properties // // // these system properties need turned off prior to creating our first // instance of the ComboPooledDataSource, otherwise, they are ignored // turn off VMID stuff (causes long ugly names for datasources) System.setProperty("com.mchange.v2.c3p0.VMID", "NONE"); // jmx is off by default if (!config.getJmx()) { // apparently, c3p0 does this with a system-wide property // com.mchange.v2.c3p0.management.ManagementCoordinator=com.mchange.v2.c3p0.management.NullManagementCoordinator System.setProperty("com.mchange.v2.c3p0.management.ManagementCoordinator", "com.mchange.v2.c3p0.management.NullManagementCoordinator"); } else { System.setProperty("com.mchange.v2.c3p0.management.ManagementCoordinator", "com.cloudhopper.commons.sql.c3p0.C3P0CustomManagementCoordinator"); } // set the JMX domain for the C3P0 C3P0CustomManagementCoordinator.setJmxDomainOnce(config.getJmxDomain()); // create a new instance of the c3p0 datasource ComboPooledDataSource cpds = new ComboPooledDataSource(true); // set properties try { // set required properties cpds.setDriverClass(config.getDriver()); cpds.setUser(config.getUsername()); cpds.setPassword(config.getPassword()); cpds.setJdbcUrl(config.getUrl()); // set optional properties cpds.setDataSourceName(config.getName()); cpds.setMinPoolSize(config.getMinPoolSize()); cpds.setMaxPoolSize(config.getMaxPoolSize()); // we'll set the initial pool size to the minimum size cpds.setInitialPoolSize(config.getMinPoolSize()); // set the validation query cpds.setPreferredTestQuery(config.getValidationQuery()); // amount of time (in ms) to wait for getConnection() to succeed cpds.setCheckoutTimeout((int)config.getCheckoutTimeout()); // checkin validation cpds.setTestConnectionOnCheckin(config.getValidateOnCheckin()); // checkout validation cpds.setTestConnectionOnCheckout(config.getValidateOnCheckout()); // amount of time to wait to validate connections // NOTE: in seconds int seconds = (int)(config.getValidateIdleConnectionTimeout()/1000); cpds.setIdleConnectionTestPeriod(seconds); // set idleConnectionTimeout // NOTE: in seconds seconds = (int)(config.getIdleConnectionTimeout()/1000); cpds.setMaxIdleTimeExcessConnections(seconds); // set activeConnectionTimeout seconds = (int)(config.getActiveConnectionTimeout()/1000); cpds.setUnreturnedConnectionTimeout(seconds); if (config.getDebug()) { cpds.setDebugUnreturnedConnectionStackTraces(true); } else { cpds.setDebugUnreturnedConnectionStackTraces(false); } // properties I think aren't valid for c3p0 // defines how many times c3p0 will try to acquire a new Connection from the database before giving up. cpds.setAcquireRetryAttempts(10); } catch (PropertyVetoException e) { throw new SQLConfigurationException("Property was vetoed during configuration", e); } /** // configure c3p0 defaults that seem to make more sense /** * c3p0.acquireIncrement hibernate.c3p0.acquire_increment c3p0.idleConnectionTestPeriod hibernate.c3p0.idle_test_period c3p0.initialPoolSize not available -- uses minimum size c3p0.maxIdleTime hibernate.c3p0.timeout c3p0.maxPoolSize hibernate.c3p0.max_size c3p0.maxStatements hibernate.c3p0.max_statements c3p0.minPoolSize hibernate.c3p0.min_size c3p0.testConnectionsOnCheckout hibernate.c3p0.validate hibernate 2.x only! */ return new C3P0ManagedDataSource(this, config, cpds); }
Example 14
Source File: PooledConnectionC3P0.java From gemfirexd-oss with Apache License 2.0 | 4 votes |
@SuppressWarnings("unchecked") private static void setupDataSource(Isolation isolation) { ds = new ComboPooledDataSource(); Endpoint locatorEndPoint = (Endpoint) (NetworkServerHelper.getNetworkLocatorEndpoints()).get(0); String hostname = getHostNameFromEndpoint(locatorEndPoint); int port = getPortFromEndpoint(locatorEndPoint); connProp.putAll(getExtraConnProp()); //singlehop conn properties and any additional prop try { ds.setProperties(connProp); ds.setDriverClass(driver); ds.setJdbcUrl(protocol + hostname+ ":" + port); ds.setMinPoolSize(5); ds.setAcquireIncrement(5); ds.setMaxPoolSize(numOfWorkers + 100); ds.setMaxStatementsPerConnection(10); if (isolation == Isolation.NONE) { ds.setConnectionCustomizerClassName( "sql.sqlutil.MyConnectionCustomizer"); } else if (isolation == Isolation.READ_COMMITTED) { ds.setConnectionCustomizerClassName("sql.sqlutil.IsolationRCConnectionCustomizer"); } else { ds.setConnectionCustomizerClassName("sql.sqlutil.IsolationRRConnectionCustomizer"); } Log.getLogWriter().info("Pooled data source url is set as " + ds.getJdbcUrl()); 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() + " is set to " + entry.getValue() +"\n"); } Log.getLogWriter().info("Pooled data source setting the following connection prop: " + sb.toString()); } catch (Exception e) { throw new TestException("could not set data source" + TestHelper.getStackTrace(e)); } }
Example 15
Source File: PooledConnectionC3P0.java From gemfirexd-oss with Apache License 2.0 | 4 votes |
@SuppressWarnings("unchecked") private static void setupDataSource(Isolation isolation) { ds = new ComboPooledDataSource(); Endpoint locatorEndPoint = (Endpoint) (NetworkServerHelper.getNetworkLocatorEndpoints()).get(0); String hostname = getHostNameFromEndpoint(locatorEndPoint); int port = getPortFromEndpoint(locatorEndPoint); connProp.putAll(getExtraConnProp()); //singlehop conn properties and any additional prop try { ds.setProperties(connProp); ds.setDriverClass(driver); ds.setJdbcUrl(protocol + hostname+ ":" + port); ds.setMinPoolSize(5); ds.setAcquireIncrement(5); ds.setMaxPoolSize(numOfWorkers + 100); ds.setMaxStatementsPerConnection(10); if (isolation == Isolation.NONE) { ds.setConnectionCustomizerClassName( "sql.sqlutil.MyConnectionCustomizer"); } else if (isolation == Isolation.READ_COMMITTED) { ds.setConnectionCustomizerClassName("sql.sqlutil.IsolationRCConnectionCustomizer"); } else { ds.setConnectionCustomizerClassName("sql.sqlutil.IsolationRRConnectionCustomizer"); } Log.getLogWriter().info("Pooled data source url is set as " + ds.getJdbcUrl()); 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() + " is set to " + entry.getValue() +"\n"); } Log.getLogWriter().info("Pooled data source setting the following connection prop: " + sb.toString()); } catch (Exception e) { throw new TestException("could not set data source" + TestHelper.getStackTrace(e)); } }
Example 16
Source File: H2Db.java From hortonmachine with GNU General Public License v3.0 | 4 votes |
public boolean open( String dbPath ) throws Exception { this.mDbPath = dbPath; connectionData = new ConnectionData(); connectionData.connectionLabel = dbPath; connectionData.connectionUrl = new String(dbPath); connectionData.user = user; connectionData.password = password; connectionData.dbType = getType().getCode(); boolean dbExists = false; if (dbPath != null) { File dbFile = new File(dbPath + "." + EDb.H2.getExtension()); if (dbFile.exists()) { if (mPrintInfos) Logger.INSTANCE.insertInfo(null, "Database exists"); dbExists = true; } if (dbPath.toLowerCase().startsWith("tcp")) { // no way to check, assume it exists dbExists = true; // also cleanup path int first = dbPath.indexOf('/'); int second = dbPath.indexOf('/', first + 1); int third = dbPath.indexOf('/', second + 1); int lastSlash = dbPath.indexOf('/', third + 1); if (lastSlash != -1) { mDbPath = dbPath.substring(lastSlash, dbPath.length()); } } } else { dbPath = "mem:syntax"; dbExists = false; } String jdbcUrl = EDb.H2.getJdbcPrefix() + dbPath; if (makePooled) { Properties p = new Properties(System.getProperties()); p.put("com.mchange.v2.log.MLog", "com.mchange.v2.log.FallbackMLog"); p.put("com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL", "OFF"); System.setProperties(p); comboPooledDataSource = new ComboPooledDataSource(); comboPooledDataSource.setDriverClass(DRIVER_CLASS); comboPooledDataSource.setJdbcUrl(jdbcUrl); if (user != null && password != null) { comboPooledDataSource.setUser(user); comboPooledDataSource.setPassword(password); } comboPooledDataSource.setInitialPoolSize(10); comboPooledDataSource.setMinPoolSize(5); comboPooledDataSource.setAcquireIncrement(5); comboPooledDataSource.setMaxPoolSize(30); comboPooledDataSource.setMaxStatements(100); comboPooledDataSource.setMaxIdleTime(14400); // 4 hours by default // comboPooledDataSource.setCheckoutTimeout(2000); comboPooledDataSource.setAcquireRetryAttempts(1); // comboPooledDataSource.setBreakAfterAcquireFailure(false); // TODO remove after debug // comboPooledDataSource.setUnreturnedConnectionTimeout(180); } else { if (user != null && password != null) { singleJdbcConn = DriverManager.getConnection(jdbcUrl, user, password); } else { singleJdbcConn = DriverManager.getConnection(jdbcUrl); } } if (mPrintInfos) { String[] dbInfo = getDbInfo(); Logger.INSTANCE.insertDebug(null, "H2 Version: " + dbInfo[0] + "(" + dbPath + ")"); } return dbExists; }
Example 17
Source File: L2DatabaseFactory.java From L2jBrasil with GNU General Public License v3.0 | 4 votes |
public L2DatabaseFactory() throws SQLException { try { if (Config.DATABASE_MAX_CONNECTIONS < 2) { Config.DATABASE_MAX_CONNECTIONS = 2; _log.warning("at least " + Config.DATABASE_MAX_CONNECTIONS + " db connections are required."); } _source = new ComboPooledDataSource(); _source.setAutoCommitOnClose(true); _source.setInitialPoolSize(10); _source.setMinPoolSize(10); _source.setMaxPoolSize(Config.DATABASE_MAX_CONNECTIONS); _source.setAcquireRetryAttempts(0); // try to obtain connections indefinitely (0 = never quit) _source.setAcquireRetryDelay(500); // 500 miliseconds wait before try to acquire connection again _source.setCheckoutTimeout(0); // 0 = wait indefinitely for new connection // if pool is exhausted _source.setAcquireIncrement(5); // if pool is exhausted, get 5 more connections at a time // cause there is a "long" delay on acquire connection // so taking more than one connection at once will make connection pooling // more effective. // this "connection_test_table" is automatically created if not already there _source.setAutomaticTestTable("connection_test_table"); _source.setTestConnectionOnCheckin(false); // testing OnCheckin used with IdleConnectionTestPeriod is faster than testing on checkout _source.setIdleConnectionTestPeriod(3600); // test idle connection every 60 sec _source.setMaxIdleTime(0); // 0 = idle connections never expire // *THANKS* to connection testing configured above // but I prefer to disconnect all connections not used // for more than 1 hour // enables statement caching, there is a "semi-bug" in c3p0 0.9.0 but in 0.9.0.2 and later it's fixed _source.setMaxStatementsPerConnection(100); _source.setBreakAfterAcquireFailure(false); // never fail if any way possible // setting this to true will make // c3p0 "crash" and refuse to work // till restart thus making acquire // errors "FATAL" ... we don't want that // it should be possible to recover _source.setDriverClass(Config.DATABASE_DRIVER); _source.setJdbcUrl(Config.DATABASE_URL); _source.setUser(Config.DATABASE_LOGIN); _source.setPassword(Config.DATABASE_PASSWORD); /* Test the connection */ _source.getConnection().close(); if (Config.DEBUG) _log.fine("Database Connection Working"); if (Config.DATABASE_DRIVER.toLowerCase().contains("microsoft")) _providerType = ProviderType.MsSql; else _providerType = ProviderType.MySql; } catch (SQLException x) { if (Config.DEBUG) _log.fine("Database Connection FAILED"); // rethrow the exception throw x; } catch (Exception e) { if (Config.DEBUG) _log.fine("Database Connection FAILED"); throw new SQLException("could not init DB connection:"+e); } }
Example 18
Source File: TestDataCreator.java From copper-engine with Apache License 2.0 | 4 votes |
/** * @param args * @throws Exception */ public static void main(String[] args) throws Exception { final IdFactory idFactory = new JdkRandomUUIDFactory(); final ComboPooledDataSource dataSource = new ComboPooledDataSource(); dataSource.setDriverClass("oracle.jdbc.OracleDriver"); dataSource.setJdbcUrl("jdbc:oracle:thin:COPPER2/COPPER2@localhost:1521:orcl11g"); dataSource.setMinPoolSize(1); dataSource.setMaxPoolSize(1); PrintStream ps = System.out; // new PrintStream(new File("C:\\perf-test-results.log")); // test(dataSource, idFactory, createByteArray(16), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(16), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(16), createByteArray(256), ps); // // test(dataSource, idFactory, createByteArray(256), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(256), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(256), createByteArray(256), ps); // // test(dataSource, idFactory, createByteArray(1024), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(1024), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(1024), createByteArray(256), ps); // // test(dataSource, idFactory, createByteArray(2000), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(2000), createByteArray(256), ps); // test(dataSource, idFactory, createByteArray(2000), createByteArray(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(16), createString(16), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(16), createString(16), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(16), createString(16), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(256), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(256), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(256), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(1024), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(1024), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(1024), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(2048), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(2048), createString(256), ps); test(dataSource, idFactory, createByteArray(2000), createByteArray(256), createString(2048), createString(256), ps); ps.close(); }
Example 19
Source File: C3P0DataSourceProvider.java From vertx-jdbc-client with Apache License 2.0 | 4 votes |
@Override public DataSource getDataSource(JsonObject config) throws SQLException { String url = config.getString("url"); if (url == null) throw new NullPointerException("url cannot be null"); String driverClass = config.getString("driver_class"); String user = config.getString("user"); String password = config.getString("password"); Integer maxPoolSize = config.getInteger("max_pool_size"); Integer initialPoolSize = config.getInteger("initial_pool_size"); Integer minPoolSize = config.getInteger("min_pool_size"); Integer maxStatements = config.getInteger("max_statements"); Integer maxStatementsPerConnection = config.getInteger("max_statements_per_connection"); Integer maxIdleTime = config.getInteger("max_idle_time"); Integer acquireRetryAttempts = config.getInteger("acquire_retry_attempts"); Integer acquireRetryDelay = config.getInteger("acquire_retry_delay"); Boolean breakAfterAcquireFailure = config.getBoolean("break_after_acquire_failure"); // If you want to configure any other C3P0 properties you can add a file c3p0.properties to the classpath ComboPooledDataSource cpds = new ComboPooledDataSource(); cpds.setJdbcUrl(url); if (driverClass != null) { try { cpds.setDriverClass(driverClass); } catch (PropertyVetoException e) { throw new IllegalArgumentException(e); } } if (user != null) { cpds.setUser(user); } if (password != null) { cpds.setPassword(password); } if (maxPoolSize != null) { cpds.setMaxPoolSize(maxPoolSize); } if (minPoolSize != null) { cpds.setMinPoolSize(minPoolSize); } if (initialPoolSize != null) { cpds.setInitialPoolSize(initialPoolSize); } if (maxStatements != null) { cpds.setMaxStatements(maxStatements); } if (maxStatementsPerConnection != null) { cpds.setMaxStatementsPerConnection(maxStatementsPerConnection); } if (maxIdleTime != null) { cpds.setMaxIdleTime(maxIdleTime); } if(acquireRetryAttempts != null){ cpds.setAcquireRetryAttempts(acquireRetryAttempts); } if(acquireRetryDelay != null){ cpds.setAcquireRetryDelay(acquireRetryDelay); } if(breakAfterAcquireFailure != null){ cpds.setBreakAfterAcquireFailure(breakAfterAcquireFailure); } return cpds; }
Example 20
Source File: PGDb.java From hortonmachine with GNU General Public License v3.0 | 4 votes |
public boolean open( String dbPath ) throws Exception { this.mDbPath = dbPath; connectionData = new ConnectionData(); connectionData.connectionLabel = dbPath; connectionData.connectionUrl = new String(dbPath); connectionData.user = user; connectionData.password = password; connectionData.dbType = getType().getCode(); boolean dbExists = true; String jdbcUrl = EDb.POSTGRES.getJdbcPrefix() + dbPath; if (makePooled) { Properties p = new Properties(System.getProperties()); p.put("com.mchange.v2.log.MLog", "com.mchange.v2.log.FallbackMLog"); p.put("com.mchange.v2.log.FallbackMLog.DEFAULT_CUTOFF_LEVEL", "OFF"); // Off or any // other level System.setProperties(p); // testConnectionOnCheckin validates the connection when it is returned to the pool. // idleConnectionTestPeriod sets a limit to how long a connection will stay idle before testing it. // maxIdleTimeExcessConnections will bring back the connectionCount back down to minPoolSize after a spike in activity. comboPooledDataSource = new ComboPooledDataSource(); comboPooledDataSource.setDriverClass(DRIVER_CLASS); comboPooledDataSource.setJdbcUrl(jdbcUrl); if (user != null && password != null) { comboPooledDataSource.setUser(user); comboPooledDataSource.setPassword(password); } comboPooledDataSource.setMinPoolSize(5); comboPooledDataSource.setMaxPoolSize(30); comboPooledDataSource.setAcquireIncrement(1); comboPooledDataSource.setInitialPoolSize(10); comboPooledDataSource.setMaxStatements(100); comboPooledDataSource.setTestConnectionOnCheckin(true); comboPooledDataSource.setIdleConnectionTestPeriod(300); comboPooledDataSource.setMaxIdleTimeExcessConnections(240); // comboPooledDataSource.setCheckoutTimeout(2000); comboPooledDataSource.setAcquireRetryAttempts(1); // comboPooledDataSource.setBreakAfterAcquireFailure(false); // TODO remove after debug // comboPooledDataSource.setUnreturnedConnectionTimeout(180); } else { if (user != null && password != null) { singleJdbcConn = DriverManager.getConnection(jdbcUrl, user, password); } else { singleJdbcConn = DriverManager.getConnection(jdbcUrl); } } if (mPrintInfos) { String[] dbInfo = getDbInfo(); Logger.INSTANCE.insertDebug(null, "Postgresql Version: " + dbInfo[0] + "(" + dbPath + ")"); } return dbExists; }