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>