Question

spring+ibatis 连接池泄漏怎么排查 数据库连接泄漏为0.连接池inative_connection_timeout设置0

spring+ibatis 连接池泄漏怎么排查
数据库方面连接会话是还有很多未使用,看了控制台监控服务的，数据库连接泄漏为0.连接池inative_connection_timeout设置0，数据库方面连接会话是还有很多未使用，在同个应用服务中，其它功能可以正常使用，就某个定时任务使用（25秒执行一次），在action中通过spring的ApplicationContext来getBean获取连接（怀疑这里导致内存泄漏），请问有什么方法可以排查程序中的数据库连接泄漏
报错信息：
org.springframework.transaction.CannotCreateTransactionException: Could not open JDBC Connection for transaction; nested exception is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
Caused by: org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:103)
at org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at com.eshore.tpcm.pub.datasource.MultiDataSource.getConnection(MultiDataSource.java:153)
at com.poson.daopub.database.datasource.MultiDataSource.getConnection(MultiDataSource.java:31)
at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:182)
at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:315)
at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:257)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:102)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:185)
at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:652)
at com.eshore.tpcm.intf.cuv.service.impl.BpmCuvMsgProcThreeServiceImpl$$EnhancerByCGLIB$$2ade596f.getPendingData(<generated>)
at com.eshore.tpcm.intf.cuv.task.BpmCuvMsgProcThreeTask.run(BpmCuvMsgProcThreeTask.java:62)
Caused by: java.util.NoSuchElementException: Timeout waiting for idle object
at org.apache.commons.pool.impl.GenericObjectPool.borrowObject(GenericObjectPool.java:825)
at org.apache.commons.dbcp.PoolingDataSource.getConnection(PoolingDataSource.java:95)
... 15 more

Answer 1

详细日志打印出来

查看每一次执行事务过后连接是否回收了
这个只有仔细排查

如果发现连接使用了但是没有关闭，就是连接池爆勒的原因