当前位置: 首页>>代码示例>>Java>>正文


Java ComboPooledDataSource类代码示例

本文整理汇总了Java中com.mchange.v2.c3p0.ComboPooledDataSource的典型用法代码示例。如果您正苦于以下问题:Java ComboPooledDataSource类的具体用法?Java ComboPooledDataSource怎么用?Java ComboPooledDataSource使用的例子?那么, 这里精选的类代码示例或许可以为您提供帮助。


ComboPooledDataSource类属于com.mchange.v2.c3p0包,在下文中一共展示了ComboPooledDataSource类的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。

示例1: pooled

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;
}
 
开发者ID:tim-group,项目名称:tg-eventstore,代码行数:22,代码来源:StacksConfiguredDataSource.java

示例2: getConfig

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
/**
 * DESC: 获取XLS的配置
 * @return
 */
private Config getConfig(){
    Config config = new Config();
    config.setConfigFile("classpath:bean2xls.xml");

    List<String> handlers = new ArrayList<>();
    handlers.add("site.oaksharks.xlsutils.typecovent.DateHandler");
    config.setHandleList(handlers);
    config.setStyleFactoryClass("site.oaksharks.xlsutils.style.DefaultStyleFactory");
    config.load();
    // 生成文件的临时目录
    config.setTempDir("D:\\xlstmp");
    DataSource dataSource=new ComboPooledDataSource("xlsutils");
    config.setDataSource(dataSource);
    return config ;
}
 
开发者ID:oaksharks,项目名称:XLSUtils,代码行数:20,代码来源:GenerateTest.java

示例3: get

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
@Override
public DataSource get() throws PropertyVetoException {
    if (cpds != null) {
        return cpds;
    }

    this.cpds = new com.mchange.v2.c3p0.ComboPooledDataSource();

    cpds.setDriverClass("com.mysql.cj.jdbc.Driver");
    cpds.setJdbcUrl("jdbc:mysql://localhost:3306/db_example");
    cpds.setUser("tully");
    cpds.setPassword("tully");

    cpds.setInitialPoolSize(3);
    cpds.setMinPoolSize(1);
    cpds.setAcquireIncrement(1);
    cpds.setMaxPoolSize(5);

    return cpds;
}
 
开发者ID:vitaly-chibrikov,项目名称:otus_java_2017_06,代码行数:21,代码来源:C3P0DataSourceFactory.java

示例4: defualtDataSource

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;
}
 
开发者ID:mojtaba-sharif,项目名称:boot-rest-mysql,代码行数:19,代码来源:DefualtDataBaseConfig.java

示例5: 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;
}
 
开发者ID:mojtaba-sharif,项目名称:multi-tenancy,代码行数:18,代码来源:DefualtDataBaseConfig.java

示例6: get

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
@Override
public DataSource get() throws PropertyVetoException {
    if (cpds != null) {
        return cpds;
    }

    this.cpds = new com.mchange.v2.c3p0.ComboPooledDataSource();

    cpds.setDriverClass("org.h2.Driver");
    cpds.setJdbcUrl("jdbc:h2:~/test");
    cpds.setUser("sa");
    cpds.setPassword("");

    cpds.setInitialPoolSize(1);
    cpds.setMinPoolSize(1);
    cpds.setAcquireIncrement(1);
    cpds.setMaxPoolSize(1);

    return cpds;
}
 
开发者ID:vitaly-chibrikov,项目名称:otus_java_2017_10,代码行数:21,代码来源:C3P0DataSourceFactory.java

示例7: connect

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);
}
 
开发者ID:CkimiHoK,项目名称:JavaWork,代码行数:21,代码来源:DataBaseController.java

示例8: getDatasource

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);
    }
  }
}
 
开发者ID:qubole,项目名称:streamx,代码行数:21,代码来源:ConnectionPool.java

示例9: createC3P0DataSource

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;
}
 
开发者ID:Pardus-Engerek,项目名称:engerek,代码行数:17,代码来源:DataSourceFactory.java

示例10: getDataSource

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
private DataSource getDataSource(String datasourceName, PersistenceOptions config) {
  try {

    DataSource ds = new ComboPooledDataSource();
    ((ComboPooledDataSource) ds).setDataSourceName(datasourceName);
    ((ComboPooledDataSource) ds).setDriverClass(config.getDriverClass());
    ((ComboPooledDataSource) ds).setJdbcUrl(config.getUrl());
    ((ComboPooledDataSource) ds).setUser(config.getUsername());
    ((ComboPooledDataSource) ds).setPassword(config.getPassword());
    ((ComboPooledDataSource) ds).setInitialPoolSize(config.getInitialPool());
    ((ComboPooledDataSource) ds).setMinPoolSize(config.getMinPool());
    ((ComboPooledDataSource) ds).setMaxPoolSize(config.getMaxPool());
    ((ComboPooledDataSource) ds).setMaxIdleTime(config.getMaxIdleTime());
    ((ComboPooledDataSource) ds).setMaxStatementsPerConnection(config.getMaxStatementsPerConnection());
    return ds;
  } catch (Exception e) {

    throw new RuntimeException(e);
  }
}
 
开发者ID:jspare-projects,项目名称:jspare-container,代码行数:21,代码来源:PersistenceUnitProviderImpl.java

示例11: registerC3P0DataSource

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
@Test
public void registerC3P0DataSource() throws Exception {
    MetricCollector metricCollector = MonitoringCenter.getMetricCollector(MonitoringCenterTest.class);

    ComboPooledDataSource cpds = new ComboPooledDataSource();
    cpds.setDriverClass("com.mysql.jdbc.Driver");

    cpds.setMinPoolSize(2);
    cpds.setAcquireIncrement(5);
    cpds.setMaxPoolSize(20);
    cpds.setMaxStatements(180);
    cpds.setBreakAfterAcquireFailure(true);

    metricCollector.registerC3P0DataSource(cpds, "testDB");

    C3P0PooledDataSourceMetricSet c3P0PooledDataSourceMetricSet = new C3P0PooledDataSourceMetricSet(cpds);

    String[] startsWithFilters = {"MonitoringCenterTest."};

    Assert.assertEquals(c3P0PooledDataSourceMetricSet.getMetrics().size(), MonitoringCenter.getMetricsByNames(false, startsWithFilters).size());
}
 
开发者ID:centro,项目名称:monitoring-center,代码行数:22,代码来源:MetricCollectorImplTest.java

示例12: initialize

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;
}
 
开发者ID:GHzGangster,项目名称:Nomad,代码行数:25,代码来源:DB.java

示例13: getSpecificDataSource

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
@ConfigurationProperties(prefix="system.datasource")
private DataSource getSpecificDataSource(String dbname) {
	try {
		System.out.println("CONNECTING TO DB ---------------> " + dbname.replaceAll("discoursedb_ext", ""));

		ComboPooledDataSource ds = new ComboPooledDataSource();
		ds.setDriverClass(environment.getRequiredProperty("jdbc.driverClassName"));
		String host = environment.getRequiredProperty("jdbc.host");
		String port = environment.getRequiredProperty("jdbc.port");
		String database = "discoursedb_ext_" + dbname.replaceAll("discoursedb_ext_", "");
		ds.setJdbcUrl("jdbc:mysql://" + host + ":" + port + "/" + database+ "?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&useSSL=false");
		ds.setUser(environment.getRequiredProperty("jdbc.username"));
		ds.setPassword(environment.getRequiredProperty("jdbc.password"));
		ds.setAcquireIncrement(Integer.parseInt(environment.getRequiredProperty("c3p0.acquireIncrement").trim()));
		ds.setIdleConnectionTestPeriod(
				Integer.parseInt(environment.getRequiredProperty("c3p0.idleConnectionTestPeriod").trim()));
		ds.setMaxStatements(Integer.parseInt(environment.getRequiredProperty("c3p0.maxStatements").trim()));
		ds.setMinPoolSize(Integer.parseInt(environment.getRequiredProperty("c3p0.minPoolSize").trim()));
		ds.setMaxPoolSize(Integer.parseInt(environment.getRequiredProperty("c3p0.maxPoolSize").trim()));
		return ds;
	} catch (Exception e) {
		throw new RuntimeException(e);
	}
}
 
开发者ID:DiscourseDB,项目名称:discoursedb-core,代码行数:25,代码来源:DatabaseSelector.java

示例14: systemDataSource

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
@Bean(name = "systemDataSource")
   @ConfigurationProperties(prefix="system.datasource")
  public DataSource systemDataSource() {
	try {
		ComboPooledDataSource ds = new ComboPooledDataSource();
		ds.setDriverClass(environment.getRequiredProperty("jdbc.driverClassName"));
		String host = environment.getRequiredProperty("jdbc.host");
		String port = environment.getRequiredProperty("jdbc.port");
		String database = environment.getRequiredProperty("jdbc.system_database").replaceAll("discoursedb_ext_", "");
		ds.setJdbcUrl("jdbc:mysql://" + host + ":" + port + "/discoursedb_ext_" + database+ "?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8&characterSetResults=UTF-8&useSSL=false");
		ds.setUser(environment.getRequiredProperty("jdbc.username"));
		ds.setPassword(environment.getRequiredProperty("jdbc.password"));
		ds.setAcquireIncrement(Integer.parseInt(environment.getRequiredProperty("c3p0.acquireIncrement").trim()));
		ds.setIdleConnectionTestPeriod(
				Integer.parseInt(environment.getRequiredProperty("c3p0.idleConnectionTestPeriod").trim()));
		ds.setMaxStatements(Integer.parseInt(environment.getRequiredProperty("c3p0.maxStatements").trim()));
		ds.setMinPoolSize(Integer.parseInt(environment.getRequiredProperty("c3p0.minPoolSize").trim()));
		ds.setMaxPoolSize(Integer.parseInt(environment.getRequiredProperty("c3p0.maxPoolSize").trim()));
		return ds;
	} catch (Exception e) {
		throw new RuntimeException(e);
	}
}
 
开发者ID:DiscourseDB,项目名称:discoursedb-core,代码行数:24,代码来源:SystemDbConfiguration.java

示例15: start

import com.mchange.v2.c3p0.ComboPooledDataSource; //导入依赖的package包/类
public boolean start() {
    if (isStarted)
        return true;

    dataSource = new ComboPooledDataSource();
    dataSource.setJdbcUrl(jdbcUrl);
    dataSource.setUser(user);
    dataSource.setPassword(password);
    try {
        dataSource.setDriverClass(driverClass);
    } catch (PropertyVetoException e) {
        dataSource = null;
        logger.error("C3p0Plugin start error");
        throw new RuntimeException(e);
    }
    dataSource.setMaxPoolSize(maxPoolSize);
    dataSource.setMinPoolSize(minPoolSize);
    dataSource.setInitialPoolSize(initialPoolSize);
    dataSource.setMaxIdleTime(maxIdleTime);
    dataSource.setAcquireIncrement(acquireIncrement);

    isStarted = true;
    return true;
}
 
开发者ID:T-baby,项目名称:ICERest-plugin,代码行数:25,代码来源:C3p0Plugin.java


注:本文中的com.mchange.v2.c3p0.ComboPooledDataSource类示例由纯净天空整理自Github/MSDocs等开源代码及文档管理平台,相关代码片段筛选自各路编程大神贡献的开源项目,源码版权归原作者所有,传播和使用请参考对应项目的License;未经允许,请勿转载。