Weblogic连接池泄漏排查

1、查看Weblogic 的控制台，发现可用数量为0

2、查看日志，报错，获取不到连接

Caused by: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mcmRACDataSource to allocate to applications, please increase the size of the pool and retry..     at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)     at org.springframework.jdbc.core.support.JdbcDaoSupport.getConnection(JdbcDaoSupport.java:133)     at com.ccb.openframework.persist.jdbc.JdbcPersistenceImpl.currentConnection(JdbcPersistenceImpl.java:269)     at com.ccb.openframework.persist.support.PersistServiceDelegate.getConnection(PersistServiceDelegate.java:407)     at com.ccb.nmcmsq.data.dos.impl.flow.ClrgFlowImpl.checkTable(ClrgFlowImpl.java:120)     at com.ccb.nmcmsq.service.impl.flow.A06410010ServiceImpl.queryClrgFlow(A06410010ServiceImpl.java:74)     at sun.reflect.GeneratedMethodAccessor324.invoke(Unknown Source)     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)     at java.lang.reflect.Method.invoke(Method.java:606)     at com.ccb.openframework.disphctrl.ReflectionInvoker.doInvoke(ReflectionInvoker.java:190)     at com.ccb.openframework.disphctrl.ReflectionInvoker.invoke(ReflectionInvoker.java:70)     ... 83 more Caused by: weblogic.jdbc.extensions.PoolLimitSQLException: weblogic.common.resourcepool.ResourceLimitException: No resources currently available in pool mcmRACDataSource to allocate to applications, please increase the size of the pool and retry..     at weblogic.jdbc.common.internal.JDBCUtil.wrapAndThrowResourceException(JDBCUtil.java:270)     at weblogic.jdbc.pool.Driver.connect(Driver.java:153)     at weblogic.jdbc.jts.Driver.getNonTxConnection(Driver.java:662)     at weblogic.jdbc.jts.Driver.connect(Driver.java:128)     at weblogic.jdbc.common.internal.RmiDataSource.getConnectionInternal(RmiDataSource.java:589)     at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:545)     at weblogic.jdbc.common.internal.RmiDataSource.getConnection(RmiDataSource.java:538)     at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)     at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)     ... 93 more

3、从PLSQL工具中查询是哪条SQL的问题

select count (*),v.PREV_SQL_ADDR,v.PREV_HASH_VALUE

from v$session v group by v.PREV_SQL_ADDR,v.PREV_HASH_VALUE

  order by count (*) desc ;

select * from v$sql s where s.ADDRESS= '00007FF7806F68C8' and s.HASH_VALUE= '2015143317' ;

4、查代码，知道是哪个交易报的错误，明确是没有Close连接的原因。

5、虽然知道是没有close的原因，从工程里面看来使用spring来管理，应该由spring来负责关闭才对，但实际上没有。

6、测试了N轮后，发现通过getBean获取出来的对象，执行后，居然不会自动关闭