日期:2014-05-16  浏览次数:20423 次

网站访问量高峰期数据库断连接

1.今天发现发布部署的网站多点击某一个连接的时候,会报错,我倍感惊讶,还有这样的事情,看来网站性能问题啊。页面出现的错误是:

HTTP Status 500 -


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的限制。换句话说打开数据库连接以后没有及时关闭。


我的异常网推荐解决方案:The server encountered an internal error () that prevented it from fulfilling this request.,http://www.aiyiweb.com/java-web/317.html