proxool+spring 数据池连接相关注意点

警告: #0002 was active for 634297 milliseconds and has been removed automaticaly. The Thread responsible was named 'http-8080-1', but the last SQL it performed is unknown because the trace property is not enabled.

proxool .xml 中 ,当数据池有连接一直占用超过你设置的最大时间时,不管是否在使用中都会被移除!于是就出现了上面的警告,原因是有连接没有关闭,如果是proxool集成Spring则一定要在事务中把连接关闭释放!!这样上面的错误就解决了!

<maximum-active-time>1200000</maximum-active-time>

<aop:config> 
<aop:advisor advice-ref="mytx" pointcut="execution(* com.service.iservice.*.*(..))" />
</aop:config>

 

原文地址:https://www.cnblogs.com/tankaixiong/p/2959691.html