HTTP Status 500 - org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.

type Exception report

message org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.

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

exception

org.apache.jasper.JasperException: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:555)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:476)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	ch.base.util.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:107)

root cause

org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: Cannot open connection; uncategorized SQLException for SQL [???]; SQL state [null]; error code [0]; An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.; nested exception is java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
	org.springframework.jdbc.support.SQLStateSQLExceptionTranslator.translate(SQLStateSQLExceptionTranslator.java:96)
	org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.translate(SQLErrorCodeSQLExceptionTranslator.java:257)
	org.springframework.orm.hibernate3.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:329)
	org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:316)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:317)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:288)
	ch.base.hibernate.dao.SHCommonDao.query(SHCommonDao.java:237)
	s91.tag.DocListTag.doStartTag(DocListTag.java:235)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspx_meth_s91_005fdoclist_005f0(index_jsp.java:483)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspx_meth_cache_005fcache_005f0(index_jsp.java:264)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspService(index_jsp.java:141)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	ch.base.util.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:107)

root cause

java.sql.SQLException: An SQLException was provoked by the following failure: com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
	com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:68)
	com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:57)
	com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:213)
	com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:64)
	com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboPooledDataSource.java:464)
	org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
	org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:304)
	org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
	org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
	org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
	org.hibernate.loader.Loader.doQuery(Loader.java:661)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
	org.hibernate.loader.Loader.doList(Loader.java:2147)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
	org.hibernate.loader.Loader.list(Loader.java:2021)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
	ch.base.hibernate.dao.SHCommonDao$3.doInHibernate(SHCommonDao.java:247)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:312)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:288)
	ch.base.hibernate.dao.SHCommonDao.query(SHCommonDao.java:237)
	s91.tag.DocListTag.doStartTag(DocListTag.java:235)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspx_meth_s91_005fdoclist_005f0(index_jsp.java:483)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspx_meth_cache_005fcache_005f0(index_jsp.java:264)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspService(index_jsp.java:141)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	ch.base.util.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:107)

root cause

com.mchange.v2.resourcepool.ResourcePoolException: A ResourcePool could not acquire a resource from its primary factory or source.
	com.mchange.v2.resourcepool.BasicResourcePool.awaitAcquire(BasicResourcePool.java:870)
	com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:201)
	com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:209)
	com.mchange.v2.c3p0.PoolBackedDataSource.getConnection(PoolBackedDataSource.java:64)
	com.mchange.v2.c3p0.ComboPooledDataSource.getConnection(ComboPooledDataSource.java:464)
	org.springframework.orm.hibernate3.LocalDataSourceConnectionProvider.getConnection(LocalDataSourceConnectionProvider.java:80)
	org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:304)
	org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:109)
	org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:105)
	org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1561)
	org.hibernate.loader.Loader.doQuery(Loader.java:661)
	org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:223)
	org.hibernate.loader.Loader.doList(Loader.java:2147)
	org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2026)
	org.hibernate.loader.Loader.list(Loader.java:2021)
	org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:369)
	org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:298)
	org.hibernate.impl.SessionImpl.list(SessionImpl.java:1020)
	org.hibernate.impl.QueryImpl.list(QueryImpl.java:74)
	ch.base.hibernate.dao.SHCommonDao$3.doInHibernate(SHCommonDao.java:247)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:312)
	org.springframework.orm.hibernate3.HibernateTemplate.execute(HibernateTemplate.java:288)
	ch.base.hibernate.dao.SHCommonDao.query(SHCommonDao.java:237)
	s91.tag.DocListTag.doStartTag(DocListTag.java:235)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspx_meth_s91_005fdoclist_005f0(index_jsp.java:483)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspx_meth_cache_005fcache_005f0(index_jsp.java:264)
	org.apache.jsp.qiuz.zpbs.index_jsp._jspService(index_jsp.java:141)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:438)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:396)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:340)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
	ch.base.util.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:107)

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


Apache Tomcat/8.0.32