如何找出一个忘记关闭数据库连接的JSP?
我们有一个内部应用系统,由厂商开发完毕后交给我们维护了。tomcat+jsp+oracle。现在时不时(频率不一定,有时1周出现2次,有时2周出不了一次)在登陆时出现错误页,如下。
从错误信息上看好像是数据库连接池满了,但实际上连接数已经配到了1000,平时同时在线人数大概在50左右。厂商初步分析是某个页面的连接忘了写关闭连接的语句,但苦于页面太多,也不好一个个查。
想请教各位高手,对于这种问题,有没有思路来准确定位这个有问题的页面?
HTTP Status 500 -
--------------------------------------------------------------------------------
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
javax.servlet.ServletException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; Cannot get a connection, pool exhausted; nested exception is org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool exhausted
org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
com.bjdv.zwcc.struts.action.CcActionServlet.process(CcActionServlet.java:44)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:525)
javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.ajaxanywhere.AAFilter.doFilter(AAFilter.java:46)