Examples with ComboPooledDataSource com.mchange.v2.c3p0.jacksonTest.ComboPooledDataSource used on opensource projects

Example 66 with ComboPooledDataSource

use of com.mchange.v2.c3p0.jacksonTest.ComboPooledDataSource in project JavaForFun by gumartinm.

the class RawJDBCLambdaExample method getDataSource.

/**
 * Just for fun, programmatic configuration.
 * @return
 * @throws PropertyVetoException
 */
private static DataSource getDataSource() throws PropertyVetoException {
    final ComboPooledDataSource pool = new ComboPooledDataSource();
    pool.setUser("root");
    pool.setPassword("");
    // We are going to use JDBC driver
    pool.setDriverClass("com.mysql.jdbc.Driver");
    pool.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/n2a?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8");
    pool.setInitialPoolSize(5);
    pool.setMaxPoolSize(35);
    pool.setMinPoolSize(10);
    pool.setAcquireIncrement(1);
    pool.setAcquireRetryAttempts(5);
    pool.setAcquireRetryDelay(1000);
    pool.setAutomaticTestTable("con_test");
    pool.setCheckoutTimeout(5000);
    return pool;
}

Example 67 with ComboPooledDataSource

use of com.mchange.v2.c3p0.jacksonTest.ComboPooledDataSource in project JavaForFun by gumartinm.

the class RawJDBCPoolExample method getDataSource.

/**
 * Just for fun, programmatic configuration.
 * @return
 * @throws PropertyVetoException
 */
private static DataSource getDataSource() throws PropertyVetoException {
    final ComboPooledDataSource pool = new ComboPooledDataSource();
    pool.setUser("root");
    pool.setPassword("");
    // We are going to use JDBC driver
    pool.setDriverClass("com.mysql.jdbc.Driver");
    pool.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/n2a?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8");
    pool.setInitialPoolSize(5);
    pool.setMaxPoolSize(35);
    pool.setMinPoolSize(10);
    pool.setAcquireIncrement(1);
    pool.setAcquireRetryAttempts(5);
    pool.setAcquireRetryDelay(1000);
    pool.setAutomaticTestTable("con_test");
    pool.setCheckoutTimeout(5000);
    return pool;
}

Example 68 with ComboPooledDataSource

use of com.mchange.v2.c3p0.jacksonTest.ComboPooledDataSource in project JavaForFun by gumartinm.

the class RawSpringJDBCWithPoolExample method main.

public static void main(final String[] args) throws PropertyVetoException {
    // Just for fun, programmatic configuration.
    final DataSource dataSource = getDataSource();
    final Map<String, Object> parameters = new HashMap<String, Object>();
    parameters.put("AD_ID", 1);
    // 3. Using Spring JdbcTemplate
    final JdbcOperations jdbcTemplate = new JdbcTemplate(dataSource);
    jdbcTemplate.execute("SELECT * FROM AD");
    // 4. Using SimpleJdbcTemplate
    final SimpleJdbcOperations simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
    final int deprecatedResult = simpleJdbcTemplate.queryForInt("SELECT * FROM AD", parameters);
    logger.info("Deprecated result: " + deprecatedResult);
    // 5. Using NamedParameterJdbcTemplate
    final NamedParameterJdbcOperations namedParameterJdbcOperations = new NamedParameterJdbcTemplate(dataSource);
    final int namedResult = namedParameterJdbcOperations.queryForInt("SELECT * FROM AD", parameters);
    logger.info("Named result: " + namedResult);
    // 6. Using Spring SimpleJdbcInsert
    final SimpleJdbcInsertOperations simpleJdbcInsert = new SimpleJdbcInsert(dataSource);
    simpleJdbcInsert.withTableName("ad");
    simpleJdbcInsert.execute(parameters);
    // 7. Using Spring SimpleJdbcCall
    final SimpleJdbcCall simpleJdbcCall = new SimpleJdbcCall(dataSource);
    // Now we close the whole pool :)
    ((ComboPooledDataSource) dataSource).close();
}

Example 69 with ComboPooledDataSource

use of com.mchange.v2.c3p0.jacksonTest.ComboPooledDataSource in project JavaForFun by gumartinm.

the class RawSpringJDBCWithPoolExample method getDataSource.

/**
 * Just for fun, programmatic configuration.
 * @return
 * @throws PropertyVetoException
 */
private static DataSource getDataSource() throws PropertyVetoException {
    final ComboPooledDataSource pool = new ComboPooledDataSource();
    pool.setUser("root");
    pool.setPassword("");
    // We are going to use the JDBC driver
    pool.setDriverClass("com.mysql.jdbc.Driver");
    pool.setJdbcUrl("jdbc:mysql://127.0.0.1:3306/n2a?autoReconnect=true&useUnicode=true&characterEncoding=UTF-8");
    pool.setInitialPoolSize(5);
    pool.setMaxPoolSize(35);
    pool.setMinPoolSize(10);
    pool.setAcquireIncrement(1);
    pool.setAcquireRetryAttempts(5);
    pool.setAcquireRetryDelay(1000);
    pool.setAutomaticTestTable("con_test");
    pool.setCheckoutTimeout(5000);
    return pool;
}

Example 70 with ComboPooledDataSource

use of com.mchange.v2.c3p0.jacksonTest.ComboPooledDataSource in project druid by alibaba.

the class TestPSCache method f_test_c3p0.

public void f_test_c3p0() throws Exception {
    ComboPooledDataSource ds = new ComboPooledDataSource();
    ds.setJdbcUrl("jdbc:mock:test");
    ds.setMaxPoolSize(10);
    ds.setMinPoolSize(0);
    ds.setMaxStatements(10);
    for (int i = 0; i < 10; ++i) {
        f(ds, 5);
        System.out.println("--------------------------------------------");
    }
}