HTTP Status 500 – Internal Server Error


Type Exception Report

Message org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Couldn't get connection because we are at maximum connection count (200/200) and there are none available

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Couldn't get connection because we are at maximum connection count (200/200) and there are none available
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:599)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:515)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
	com.hanweb.jcms.filter.DownFileFilter.doFilter(DownFileFilter.java:53)

Root Cause

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Couldn't get connection because we are at maximum connection count (200/200) and there are none available
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:711)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:761)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
	com.hanweb.common.basedao.BaseDAO.queryForArrays(BaseDAO.java:170)
	com.hanweb.jcms.dao.WebSearchInfoDAO.findByCataIdAndArtId(WebSearchInfoDAO.java:3592)
	com.hanweb.jcms.service.info.SearchInfoBLF.getEntity(SearchInfoBLF.java:213)
	org.apache.jsp.jcms_005ffiles.jcms1.web30.site.module.visitcount.visit_jsp._jspService(visit_jsp.java:164)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
	com.hanweb.jcms.filter.DownFileFilter.doFilter(DownFileFilter.java:53)

Root Cause

java.sql.SQLException: Couldn't get connection because we are at maximum connection count (200/200) and there are none available
	org.logicalcobwebs.proxool.Prototyper.quickRefuse(Prototyper.java:309)
	org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:152)
	org.logicalcobwebs.proxool.ProxoolDataSource.getConnection(ProxoolDataSource.java:97)
	com.hanweb.common.datasource.AdaptiveDataSource.getConnection(AdaptiveDataSource.java:177)
	sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	net.bull.javamelody.JdbcWrapper$3.invoke(JdbcWrapper.java:781)
	net.bull.javamelody.JdbcWrapper$DelegatingInvocationHandler.invoke(JdbcWrapper.java:294)
	com.sun.proxy.$Proxy16.getConnection(Unknown Source)
	sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
	sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	java.lang.reflect.Method.invoke(Method.java:606)
	org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:333)
	org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
	net.sf.log4jdbc.DataSourceSpyInterceptor.invoke(DataSourceSpyInterceptor.java:29)
	org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
	org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:213)
	com.sun.proxy.$Proxy17.getConnection(Unknown Source)
	org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:711)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:761)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:192)
	org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate.query(NamedParameterJdbcTemplate.java:199)
	com.hanweb.common.basedao.BaseDAO.queryForArrays(BaseDAO.java:170)
	com.hanweb.jcms.dao.WebSearchInfoDAO.findByCataIdAndArtId(WebSearchInfoDAO.java:3592)
	com.hanweb.jcms.service.info.SearchInfoBLF.getEntity(SearchInfoBLF.java:213)
	org.apache.jsp.jcms_005ffiles.jcms1.web30.site.module.visitcount.visit_jsp._jspService(visit_jsp.java:164)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:395)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:339)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:728)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:239)
	net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:215)
	com.hanweb.jcms.filter.DownFileFilter.doFilter(DownFileFilter.java:53)

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/7.0.105

Baidu
sogou