Java ComboPooledDataSource.setUser方法代码示例

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
private static PooledDataSource pooled(String hostname, int port, String username, String password, String database, String driver, int maxPoolsize) {
    ComboPooledDataSource dataSource = new ComboPooledDataSource();
    dataSource.setJdbcUrl(format("jdbc:mysql://%s:%d/%s?rewriteBatchedStatements=true",
            hostname,
            port,
            database));
    dataSource.setUser(username);
    dataSource.setPassword(password);
    dataSource.setIdleConnectionTestPeriod(60 * 5);
    dataSource.setMinPoolSize(3);
    dataSource.setInitialPoolSize(3);
    dataSource.setAcquireIncrement(1);
    dataSource.setMaxPoolSize(maxPoolsize);

    try {
        Class.forName(driver);
    } catch (ClassNotFoundException e) {
        throw new RuntimeException(e);
    }
    return dataSource;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Bean
public DataSource defualtDataSource() {
    ComboPooledDataSource defualtDatasource = new ComboPooledDataSource();
    try {
        defualtDatasource.setJdbcUrl(environment.getProperty("db.url"));
        defualtDatasource.setUser(environment.getProperty("db.user"));
        defualtDatasource.setPassword(environment.getProperty("db.pass"));
        defualtDatasource.setDriverClass(environment.getProperty("db.driver"));

        defualtDatasource.setInitialPoolSize(Integer.valueOf("1"));
        defualtDatasource.setMaxPoolSize(Integer.parseInt("5"));
        defualtDatasource.setMinPoolSize(Integer.parseInt("5"));
        defualtDatasource.setMaxConnectionAge(Integer.parseInt("100"));
    } catch (PropertyVetoException e) {
        e.printStackTrace();
    }
    return defualtDatasource;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Bean
public DataSource defualtDataSource() {
    ComboPooledDataSource defualtDatasource = new ComboPooledDataSource();
    defualtDatasource.setJdbcUrl(properties.getUrl());
    defualtDatasource.setUser(properties.getUsername());
    defualtDatasource.setPassword(properties.getPassword());
    try {
        defualtDatasource.setDriverClass(properties.getDriver());
    } catch (PropertyVetoException e) {
        e.printStackTrace();
    }
    defualtDatasource.setInitialPoolSize(Integer.valueOf(defultPoolProp.getInitialPoolSize()));
    defualtDatasource.setMaxPoolSize(Integer.parseInt(defultPoolProp.getMaxPoolSize()));
    defualtDatasource.setMinPoolSize(Integer.parseInt(defultPoolProp.getMinPoolSize()));
    defualtDatasource.setMaxConnectionAge(Integer.parseInt(defultPoolProp.getPoolMaxConnectionAge()));
    return defualtDatasource;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
/**
 * Method load properties and get connection pool to database.
 * Use c3p0 library.
 */
public void connect() {
    pool = new ComboPooledDataSource();
    try {
        pool.setDriverClass(dbPROP.getProperty("driver"));
    } catch (PropertyVetoException ex) {
        ex.printStackTrace();
    }
    pool.setJdbcUrl(dbPROP.getProperty("url"));
    pool.setUser(dbPROP.getProperty("username"));
    pool.setPassword(dbPROP.getProperty("password"));
    pool.setMinPoolSize(2);
    pool.setAcquireIncrement(1);
    pool.setMaxPoolSize(5);
    pool.setMaxStatements(50);
    pool.setMaxStatementsPerConnection(10);
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
public static synchronized ComboPooledDataSource getDatasource(String connectionUrl, String user, String password) {
  if(dataSources.containsKey(connectionUrl)) {
    return dataSources.get(connectionUrl);
  }
  else {
    try {
      ComboPooledDataSource cpds = new ComboPooledDataSource();
      cpds.setDriverClass("com.mysql.jdbc.Driver"); //loads the jdbc driver
      cpds.setJdbcUrl(connectionUrl);
      cpds.setUser(user);
      cpds.setPassword(password);
      cpds.setMaxConnectionAge(18000);//5 hours
      dataSources.put(connectionUrl, cpds);
      return cpds;
    } catch (PropertyVetoException e) {
      log.error("Error while creating c3p0 ComboPooledDataSource" + e);
      throw new ConnectException(e);
    }
  }
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
private DataSource createC3P0DataSource() throws PropertyVetoException {
    ComboPooledDataSource ds = new ComboPooledDataSource();
    ds.setDriverClass(configuration.getDriverClassName());
    ds.setJdbcUrl(configuration.getJdbcUrl());
    ds.setUser(configuration.getJdbcUsername());
    ds.setPassword(configuration.getJdbcPassword());

    ds.setAcquireIncrement(3);
    ds.setMinPoolSize(configuration.getMinPoolSize());
    ds.setMaxPoolSize(configuration.getMaxPoolSize());
    ds.setIdleConnectionTestPeriod(1800);
    ds.setConnectionTesterClassName(MidPointConnectionTester.class.getName());
    ds.setConnectionCustomizerClassName(MidPointConnectionCustomizer.class.getName());

    return ds;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
public static boolean initialize(String url, String user, String password, int minPoolSize, int maxPoolSize,
		int poolIncrement) {
	try {
		cpds = new ComboPooledDataSource();
		cpds.setDriverClass("com.mysql.cj.jdbc.Driver");
		cpds.setJdbcUrl(url);
		cpds.setUser(user);
		cpds.setPassword(password);

		cpds.setInitialPoolSize(minPoolSize);
		cpds.setMinPoolSize(minPoolSize);
		cpds.setAcquireIncrement(poolIncrement);
		cpds.setMaxPoolSize(maxPoolSize);

		cpds.setNumHelperThreads(Nomad.DB_WORKERS);

		cpds.setTestConnectionOnCheckout(true);
	} catch (Exception e) {
		logger.error("Failed to initialize DB.", e);
		return false;
	}
	logger.debug("Initialized DB.");
	return true;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
/**
 * @return the h2 database data source
 */
@Bean
public DataSource h2DataSource() {
    ComboPooledDataSource dataSource = new ComboPooledDataSource();

    try {
        dataSource.setDriverClass("org.h2.Driver");
    } catch (PropertyVetoException e) {
        e.printStackTrace();
    }
    dataSource.setJdbcUrl("jdbc:h2:mem:bootstrap;mode=mysql;INIT=runscript from 'classpath:sql/bootstrap.h2.sql'\\;" +
            "runscript from 'classpath:sql/bootstrap.insert.sql'");
    dataSource.setUser("sa");
    dataSource.setPassword("");
    dataSource.setAcquireIncrement(10);
    dataSource.setIdleConnectionTestPeriod(60);
    dataSource.setMaxPoolSize(30);
    dataSource.setMinPoolSize(3);
    dataSource.setInitialPoolSize(5);
    dataSource.setMaxStatements(10);

    return dataSource;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
/**
 * @return the mysql data source
 */
@Bean
public DataSource mysqlDataSource() {
    ComboPooledDataSource dataSource = new ComboPooledDataSource();
    try {
        dataSource.setDriverClass("com.mysql.jdbc.Driver");
    } catch (PropertyVetoException e) {
        return null;
    }
    dataSource.setJdbcUrl("jdbc:mysql://localhost:3306/bootstrap");
    dataSource.setUser("bootstrap");
    dataSource.setPassword("bootstrap");
    dataSource.setAcquireIncrement(50);
    dataSource.setIdleConnectionTestPeriod(60);
    dataSource.setMaxPoolSize(50);
    dataSource.setMinPoolSize(10);
    dataSource.setInitialPoolSize(20);
    dataSource.setMaxStatements(50);

    return dataSource;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Test
public void upsertSchool() throws IOException, PropertyVetoException {
    final FetchData result = fetcher.fetch(schoolSelect,
            ImmutableMap.of("level", "senior"));
    final ScrapeData scrapeData = scraper.scrape(schoolSelect, result);

    final ComboPooledDataSource dataSource = new ComboPooledDataSource();
    try {
        dataSource.setDriverClass(env.getRequiredProperty("spring.datasource.driverClassName"));
        dataSource.setJdbcUrl(env.getRequiredProperty("spring.datasource.url"));
        dataSource.setUser(env.getRequiredProperty("spring.datasource.username"));
        dataSource.setPassword(env.getRequiredProperty("spring.datasource.password"));

        final DataSourceTransactionManager txMgr = new DataSourceTransactionManager(dataSource);
        txMgr.afterPropertiesSet();

        tableDmlGenerator.upsert("ppdbbandung2015", schoolSelect,
                scrapeData, dataSource, txMgr);
    } finally {
        dataSource.close();
    }
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Test
public void upsertFiltered() throws IOException, PropertyVetoException {
    final FetchData result = fetcher.fetch(filteredSelect,
            ImmutableMap.of("choice_id", 685));
    final ScrapeData scrapeData = scraper.scrape(filteredSelect, result);

    final ComboPooledDataSource dataSource = new ComboPooledDataSource();
    try {
        dataSource.setDriverClass(env.getRequiredProperty("spring.datasource.driverClassName"));
        dataSource.setJdbcUrl(env.getRequiredProperty("spring.datasource.url"));
        dataSource.setUser(env.getRequiredProperty("spring.datasource.username"));
        dataSource.setPassword(env.getRequiredProperty("spring.datasource.password"));

        final DataSourceTransactionManager txMgr = new DataSourceTransactionManager(dataSource);
        txMgr.afterPropertiesSet();

        tableDmlGenerator.upsert("ppdbbandung2015", filteredSelect,
                scrapeData, dataSource, txMgr);
    } finally {
        dataSource.close();
    }
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Test
public void upsertStudent() throws IOException, PropertyVetoException {
    final FetchData result = fetcher.fetch(studentGet,
            ImmutableMap.of("registration_id", "3004-1009afirmasi"));
    final ScrapeData scrapeData = scraper.scrape(studentGet, result);

    final ComboPooledDataSource dataSource = new ComboPooledDataSource();
    try {
        dataSource.setDriverClass(env.getRequiredProperty("spring.datasource.driverClassName"));
        dataSource.setJdbcUrl(env.getRequiredProperty("spring.datasource.url"));
        dataSource.setUser(env.getRequiredProperty("spring.datasource.username"));
        dataSource.setPassword(env.getRequiredProperty("spring.datasource.password"));

        final DataSourceTransactionManager txMgr = new DataSourceTransactionManager(dataSource);
        txMgr.afterPropertiesSet();

        tableDmlGenerator.upsert("ppdbbandung2015", studentGet,
                scrapeData, dataSource, txMgr);
    } finally {
        dataSource.close();
    }
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Test
    public void summarizeFixed() throws IOException, PropertyVetoException {
        final ComboPooledDataSource dataSource = new ComboPooledDataSource();
        try {
            dataSource.setDriverClass(env.getRequiredProperty("spring.datasource.driverClassName"));
            dataSource.setJdbcUrl(env.getRequiredProperty("spring.datasource.url"));
            dataSource.setUser(env.getRequiredProperty("spring.datasource.username"));
            dataSource.setPassword(env.getRequiredProperty("spring.datasource.password"));

            final DataSourceTransactionManager txMgr = new DataSourceTransactionManager(dataSource);
            txMgr.afterPropertiesSet();

            // Please delete this data point, we already have 2015-07-02T04:00+07:00 generated manually for reference
//            summarizer.summarize("ppdbbandung2015", "optionapplicantsnapshot", dataSource,
//                    txMgr, new DateTime("2015-07-02T05:00+07:00"));
            summarizer.summarize("ppdbbandung2015", "optionapplicantsnapshot", dataSource,
                    txMgr, new DateTime());
        } finally {
            dataSource.close();
        }
    }
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
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;
}
 

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入方法依赖的package包/类
@Before
public void setUp() throws Exception {
    if (rdb == null) {
        ComboPooledDataSource dataSource = new ComboPooledDataSource();
        dataSource.setDriverClass("com.mysql.jdbc.Driver");
        dataSource.setJdbcUrl("jdbc:mysql://localhost/test_rdb");
        dataSource.setUser("test_rdb");
        dataSource.setPassword("test_rdb");
        dataSource.setMinPoolSize(2);
        dataSource.setAcquireIncrement(2);
        dataSource.setMaxPoolSize(32);
        JdbcDataSourceManager dataSourceManager = new JdbcDataSourceManager(dataSource);
        rdb = new Rdb(dataSourceManager);
        rdb.registerTypeAdapter(LocalDate.class, new LocalDateTypeAdapter());
        rdb.registerTypeAdapter(LocalDateTime.class, new LocalDateTimeTypeAdapter());
        rdb.registerTypeAdapter(Timestamp.class, new TimestampTypeAdapter());
        rdb.registerTypeAdapter(java.sql.Date.class, new SqlDateTypeAdapter());
    }
    Connection conn = rdb.getDataSourceManager().getConnection();
    Statement stmt = conn.createStatement();
    stmt.execute("delete from User;");
    stmt.execute("delete from Book;");
    stmt.close();
    conn.close();
}