1、查看Weblogic 的控制台,发现可用数量为0
![](https://i-blog.csdnimg.cn/blog_migrate/e1eb4c435011319dff307daa79828cc7.png)
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.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 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
;
![](https://i-blog.csdnimg.cn/blog_migrate/3461fcfd3fa4a6d6ea45fd3b2c36cdba.png)
select
*
from
v$sql s
where
s.ADDRESS=
'00007FF7806F68C8'
and
s.HASH_VALUE=
'2015143317'
;
![](https://i-blog.csdnimg.cn/blog_migrate/3eb472ee8e7dd0d6e7238fe9a224b778.png)
4、查代码,知道是哪个交易报的错误,明确是没有Close连接的原因。
5、虽然知道是没有close的原因,从工程里面看来使用spring来管理,应该由spring来负责关闭才对,但实际上没有。
6、测试了N轮后,发现通过getBean获取出来的对象,执行后,居然不会自动关闭