HTTP Status 500 - Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool


type Exception report

message Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool

description The server encountered an internal error that prevented it from fulfilling this request.

exception

org.springframework.web.util.NestedServletException: Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:681)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:574)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	com.caixin.web.system.EncodeFilter.doFilter(EncodeFilter.java:31)

root cause

org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
	org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80)
	org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:572)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:717)
	com.caixin.dao.mysql.SptopicLabelDAOImpl.findTagBeanByBqid(SptopicLabelDAOImpl.java:162)
	com.caixin.web.action.NewTagPageAction.handleRequest(NewTagPageAction.java:72)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:574)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	com.caixin.web.system.EncodeFilter.doFilter(EncodeFilter.java:31)

root cause

java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
	com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:106)
	com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:65)
	com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:62)
	com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:531)
	com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	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:572)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:717)
	com.caixin.dao.mysql.SptopicLabelDAOImpl.findTagBeanByBqid(SptopicLabelDAOImpl.java:162)
	com.caixin.web.action.NewTagPageAction.handleRequest(NewTagPageAction.java:72)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:574)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	com.caixin.web.system.EncodeFilter.doFilter(EncodeFilter.java:31)

root cause

com.mchange.v2.resourcepool.ResourcePoolException: Attempted to use a closed or broken resource pool
	com.mchange.v2.resourcepool.BasicResourcePool.ensureNotBroken(BasicResourcePool.java:1632)
	com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:524)
	com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:477)
	com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:525)
	com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:128)
	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:572)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:636)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:665)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:673)
	org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:717)
	com.caixin.dao.mysql.SptopicLabelDAOImpl.findTagBeanByBqid(SptopicLabelDAOImpl.java:162)
	com.caixin.web.action.NewTagPageAction.handleRequest(NewTagPageAction.java:72)
	org.springframework.web.servlet.mvc.SimpleControllerHandlerAdapter.handle(SimpleControllerHandlerAdapter.java:48)
	org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:790)
	org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:719)
	org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:669)
	org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:574)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:624)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	com.caixin.web.system.EncodeFilter.doFilter(EncodeFilter.java:31)

note The full stack trace of the root cause is available in the Apache Tomcat/7.0.70 logs.


Apache Tomcat/7.0.70