Пример #1
0
  public void druid() throws Exception {
    DruidDataSource dataSource = new DruidDataSource();

    dataSource.setInitialSize(initialSize);
    dataSource.setMaxActive(maxActive);
    dataSource.setMaxIdle(maxIdle);
    dataSource.setMinIdle(minIdle);
    dataSource.setMaxWait(maxWait);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setUsername(user);
    dataSource.setPassword(password);
    dataSource.setValidationQuery(validationQuery);
    dataSource.setTestOnBorrow(testOnBorrow);
    dataSource.setTestOnBorrow(testWhileIdle);
    dataSource.setTestOnBorrow(testOnReturn);
    dataSource.setRemoveAbandoned(removeAbandoned);
    dataSource.setRemoveAbandonedTimeout(removeAbandonedTimeout);
    dataSource.setTimeBetweenEvictionRunsMillis(timeBetweenEvictionRunsMillis);
    dataSource.setMinEvictableIdleTimeMillis(minEvictableIdleTimeMillis);
    dataSource.setNumTestsPerEvictionRun(numTestsPerEvictionRun);

    for (int i = 0; i < TEST_COUNT; ++i) {
      p0(dataSource, "druid", threadCount);
    }
    System.out.println();
  }
  /**
   * 配置数据源
   *
   * @param ds
   * @return
   * @throws SQLException
   */
  @Bean(initMethod = "init", destroyMethod = "close")
  public DataSource dataSource(DruidSettings ds) {
    DruidDataSource dataSource = new DruidDataSource();
    dataSource.setUrl(ds.getUrl());
    dataSource.setUsername(ds.getUsername());
    dataSource.setPassword(ds.getPassword());
    dataSource.setInitialSize(ds.getInitialSize());
    dataSource.setMaxActive(ds.getMaxActive());
    dataSource.setMinIdle(ds.getMinIdle());
    dataSource.setMaxWait(ds.getMaxWait());
    dataSource.setValidationQuery(ds.getValidationQuery());
    dataSource.setTimeBetweenEvictionRunsMillis(ds.getTimeBetweenEvictionRunsMillis());
    dataSource.setMinEvictableIdleTimeMillis(ds.getMinEvictableIdleTimeMillis());
    dataSource.setTestWhileIdle(ds.isTestWhileIdle());
    dataSource.setTestOnBorrow(ds.isTestOnBorrow());
    dataSource.setTestOnReturn(ds.isTestOnReturn());
    dataSource.setPoolPreparedStatements(ds.isPoolPreparedStatements());
    dataSource.setMaxOpenPreparedStatements(ds.getMaxOpenPreparedStatements());

    try {
      dataSource.setFilters(ds.getFilters());
    } catch (SQLException e) {
      e.printStackTrace();
      LOGGER.error("init druid source error", e);
    }

    LOGGER.debug("init druid source");
    return dataSource;
  }
 protected void setUp() throws Exception {
   dataSource = new DruidDataSource();
   dataSource.setUrl("jdbc:mock:xxx");
   dataSource.setMaxActive(1);
   dataSource.setInitialSize(1);
   dataSource.setTestOnBorrow(false);
   dataSource.init();
 }
  public void test_error_5() throws Exception {
    DruidPooledConnection conn = dataSource.getConnection().unwrap(DruidPooledConnection.class);

    conn.close();

    dataSource.setInitialSize(dataSource.getInitialSize());

    {
      Exception error = null;
      try {
        dataSource.setInitialSize(10);
      } catch (Exception ex) {
        error = ex;
      }
      Assert.assertNotNull(error);
    }
  }
Пример #5
0
 static {
   dataSource.setDriverClassName("com.mysql.jdbc.Driver");
   dataSource.setUsername("flower");
   dataSource.setPassword("flower");
   dataSource.setUrl("jdbc:mysql://localhost:3306/flower");
   dataSource.setInitialSize(5);
   dataSource.setMinIdle(1);
   dataSource.setPoolPreparedStatements(false);
 }
  protected void setUp() throws Exception {
    System.setProperty("druid.mysql.usePingMethod", "false");

    dataSource = new DruidDataSource();
    dataSource.setUrl("jdbc:mock:xxx");
    dataSource.setDbType("mysql");
    dataSource.setValidationQuery("select 1");
    dataSource.setValidConnectionChecker(new MySqlValidConnectionChecker());
    dataSource.setInitialSize(1);
    dataSource.setTestOnBorrow(true);
  }
Пример #7
0
  public void test_concurrent_2() throws Exception {
    final DruidDataSource dataSource = new DruidDataSource();

    Class.forName("com.alibaba.druid.mock.MockDriver");

    dataSource.setInitialSize(10);
    dataSource.setMaxActive(maxPoolSize);
    dataSource.setMinIdle(minPoolSize);
    dataSource.setMaxIdle(maxPoolSize);
    dataSource.setPoolPreparedStatements(true);
    dataSource.setDriverClassName(driverClass);
    dataSource.setUrl(jdbcUrl);
    dataSource.setPoolPreparedStatements(true);

    final int THREAD_COUNT = 2;
    final int LOOP_COUNT = 1000 * 1000;

    final CountDownLatch startLatch = new CountDownLatch(1);
    final CountDownLatch endLatch = new CountDownLatch(THREAD_COUNT);

    for (int threadIndex = 0; threadIndex < THREAD_COUNT; ++threadIndex) {
      Thread thread =
          new Thread() {

            public void run() {
              try {
                startLatch.await();

                for (int i = 0; i < LOOP_COUNT; ++i) {
                  Connection conn = dataSource.getConnection();
                  conn.close();
                }
              } catch (Throwable e) {
                e.printStackTrace();
              } finally {
                endLatch.countDown();
              }
            }
          };
      thread.start();
    }

    startLatch.countDown();
    endLatch.await();

    Assert.assertEquals(THREAD_COUNT * LOOP_COUNT, dataSource.getConnectCount());
    Assert.assertEquals(THREAD_COUNT * LOOP_COUNT, dataSource.getCloseCount());
    Assert.assertEquals(0, dataSource.getConnectErrorCount());
    Assert.assertEquals(0, dataSource.getActiveCount());
  }
Пример #8
0
 public void init() throws SQLException {
   druidDataSource = new DruidDataSource();
   //		druidDataSource.setDriverClassName(driver);
   druidDataSource.setOracle(false);
   druidDataSource.setUrl(url);
   druidDataSource.setUsername(username);
   druidDataSource.setPassword(password);
   druidDataSource.setMaxActive(maxActive);
   druidDataSource.setMinIdle(minIdle);
   druidDataSource.setInitialSize(initialSize);
   //		 配置获取连接等待超时的时间。 单位是毫秒
   druidDataSource.setMaxWait(3000);
   //		配置间隔多久才进行一次检测,检测需要关闭的空闲连接,单位是毫秒
   druidDataSource.setTimeBetweenEvictionRunsMillis(60000);
   //		 配置一个连接在池中最小生存的时间,单位是毫秒
   druidDataSource.setMinEvictableIdleTimeMillis(300000);
   //		打开PSCache,并且指定每个连接上PSCache的大小
   druidDataSource.setPoolPreparedStatements(false);
   druidDataSource.setTestOnBorrow(false);
   druidDataSource.setTestWhileIdle(true);
   druidDataSource.setValidationQuery("SELECT 'x'");
   druidDataSource.init();
 }
  protected void setUp() throws Exception {
    DruidDataSourceStatManager.clear();

    driver = new MockDriver();

    dataSource = new DruidDataSource();
    dataSource.setUrl("jdbc:mock:xxx");
    dataSource.setDriver(driver);
    dataSource.setInitialSize(1);
    dataSource.setMaxActive(2);
    dataSource.setMaxIdle(2);
    dataSource.setMinIdle(1);
    dataSource.setMinEvictableIdleTimeMillis(300 * 1000); // 300 / 10
    dataSource.setTimeBetweenEvictionRunsMillis(10); // 180 / 10
    dataSource.setTestWhileIdle(true);
    dataSource.setTestOnBorrow(false);
    dataSource.setValidationQuery("SELECT 1");
    dataSource.setFilters("stat");
    dataSource.setPoolPreparedStatements(false);
    dataSource.setMaxPoolPreparedStatementPerConnectionSize(20);

    //        ((StatFilter) dataSource.getProxyFilters().get(0)).setMaxSqlStatCount(100);
  }
Пример #10
0
  protected void setUp() throws Exception {
    DruidDataSourceStatManager.clear();

    driver = new MockDriver();

    dataSource = new DruidDataSource();
    dataSource.setUrl("jdbc:mock:xxx");
    dataSource.setDriver(driver);
    dataSource.setInitialSize(1);
    dataSource.setMaxActive(2);
    dataSource.setMaxIdle(2);
    dataSource.setMinIdle(1);
    dataSource.setMinEvictableIdleTimeMillis(300 * 1000); // 300 / 10
    dataSource.setTimeBetweenEvictionRunsMillis(180 * 1000); // 180 / 10
    dataSource.setTestWhileIdle(true);
    dataSource.setTestOnBorrow(false);
    dataSource.setValidationQuery("SELECT 1");
    dataSource.setFilters("stat,trace");

    JdbcStatContext context = new JdbcStatContext();
    context.setTraceEnable(true);
    JdbcStatManager.getInstance().setStatContext(context);
  }