hikari连接池配置测试
最大连接数20,其他配置默认
测试代码:
ExecutorService executor = Executors.newFixedThreadPool(20);
for (int i = 0; i < 20; i++) {
executor.submit(new Runnable() {
@Override
public void run() {
try {
Connection cn = jdbcTemplate.getDataSource().getConnection();
Statement state = cn.createStatement();
state.execute("select 1 from dual");
Thread.sleep(31000);
cn.close();
state.close();
} catch (SQLException | InterruptedException e) {
e.printStackTrace();
}
}
});
}
//业务代码
searchIndustryNewsDbData.searchDbDataMethod();