日期:2014-05-16 浏览次数:20423 次
1.今天发现发布部署的网站多点击某一个连接的时候,会报错,我倍感惊讶,还有这样的事情,看来网站性能问题啊。页面出现的错误是:
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: javax.servlet.ServletException: java.sql.SQLException: Listener refused the connection with the following error: ORA-12519, TNS:no appropriate service handler found The Connection descriptor used by the client was: 127.0.0.1:1521:ORCL org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:460) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:355) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265) javax.servlet.http.HttpServlet.service(HttpServlet.java:820) cn.mldn.lxh.filter.EncodingFilter.doFilter(EncodingFilter.java:24)
?
错误分析:以为代码写错了,查看cn.mldn.lxh.filter.EncodingFilter.doFilter(EncodingFilter.java:24),
EncodingFilter.java的24行chain.doFilter(request,response) ;?代码很正常啊。
为什么会出现连接不到数据库的时候呢?原因是进程数超过了oracle的限制。换句话说打开数据库连接以后没有及时关闭。