目前。我用mysql数据库,proxool做连接池,jsp网页进行数据查询
proxool连接池的部分配置如下:
<maximum-connection-count>20</maximum-connection-count>
<minimum-connection-count>2</minimum-connection-count>
<simultaneous-build-throttle>20</simultaneous-build-throttle>
<house-keeping-sleep-time>5000</house-keeping-sleep-time>
<maximum-active-time>6000</maximum-active-time>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<maximum-connection-lifetime>7000</maximum-connection-lifetime>问题是:
当我关闭应用页面后,发现mysql中的开启的两个连接线程(minimum-connection-count中配置的)依然存在,
我在网上看到maximum-connection-lifetime好像是控制连接释放的
但是连接线程却没有释放,为什么?是我哪里配置错了吗
proxool连接池的部分配置如下:
<maximum-connection-count>20</maximum-connection-count>
<minimum-connection-count>2</minimum-connection-count>
<simultaneous-build-throttle>20</simultaneous-build-throttle>
<house-keeping-sleep-time>5000</house-keeping-sleep-time>
<maximum-active-time>6000</maximum-active-time>
<house-keeping-test-sql>select CURRENT_DATE</house-keeping-test-sql>
<maximum-connection-lifetime>7000</maximum-connection-lifetime>问题是:
当我关闭应用页面后,发现mysql中的开启的两个连接线程(minimum-connection-count中配置的)依然存在,
我在网上看到maximum-connection-lifetime好像是控制连接释放的
但是连接线程却没有释放,为什么?是我哪里配置错了吗
if(pstmt != null)
{
pstmt.close();
pstmt = null;
}
if(rs != null)
{
rs.close();
rs = null;
}
if(con != null)
{
con.close();
con = null;
}