type Exception report
message org.hibernate.exception.GenericJDBCException: Cannot open connection
description The server encountered an internal error that prevented it from fulfilling this request.
exception
org.apache.jasper.JasperException: org.hibernate.exception.GenericJDBCException: Cannot open connection org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:549) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:470) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.zbxsoft.netbid.web.ScriptFilter.doFilter(ScriptFilter.java:77) com.zbxsoft.netbid.web.EncodingFilter.doFilter(EncodingFilter.java:40)
root cause
org.hibernate.exception.GenericJDBCException: Cannot open connection org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:420) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) 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:224) org.hibernate.loader.Loader.doList(Loader.java:2145) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) org.hibernate.loader.Loader.list(Loader.java:2024) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) com.zbxsoft.netbid.dao.BidSessionDAO.getSessionListByStatus(BidSessionDAO.java:243) com.zbxsoft.netbid.service.BidSessionService.getAllStartBidSession(BidSessionService.java:73) com.zbxsoft.netbid.cache.BidSessionCache.getAllBidSession(BidSessionCache.java:42) com.zbxsoft.netbid.cache.BidSessionCache.getBidSessionBySeid(BidSessionCache.java:217) org.apache.jsp.hall.index_jsp._jspService(index_jsp.java:105) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.zbxsoft.netbid.web.ScriptFilter.doFilter(ScriptFilter.java:77) com.zbxsoft.netbid.web.EncodingFilter.doFilter(EncodingFilter.java:40)
root cause
java.sql.SQLException: Listener refused the connection with the following error: ORA-12528, TNS:listener: all appropriate instances are blocking new connections The Connection descriptor used by the client was: 192.168.0.173:1521:VENDUEDB oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111) oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:260) oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386) oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:413) oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164) oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752) java.sql.DriverManager.getConnection(DriverManager.java:582) java.sql.DriverManager.getConnection(DriverManager.java:154) org.logicalcobwebs.proxool.ProxyFactory.buildProxyConnection(ProxyFactory.java:41) org.logicalcobwebs.proxool.Prototyper.buildConnection(Prototyper.java:150) org.logicalcobwebs.proxool.PrototyperController.buildConnection(PrototyperController.java:88) org.logicalcobwebs.proxool.ConnectionPool.getConnection(ConnectionPool.java:222) org.logicalcobwebs.proxool.ProxoolDriver.connect(ProxoolDriver.java:89) java.sql.DriverManager.getConnection(DriverManager.java:582) java.sql.DriverManager.getConnection(DriverManager.java:207) org.hibernate.connection.ProxoolConnectionProvider.getConnection(ProxoolConnectionProvider.java:53) org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:417) org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144) 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:224) org.hibernate.loader.Loader.doList(Loader.java:2145) org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2029) org.hibernate.loader.Loader.list(Loader.java:2024) org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:375) org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:308) org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:153) org.hibernate.impl.SessionImpl.list(SessionImpl.java:1106) org.hibernate.impl.QueryImpl.list(QueryImpl.java:79) com.zbxsoft.netbid.dao.BidSessionDAO.getSessionListByStatus(BidSessionDAO.java:243) com.zbxsoft.netbid.service.BidSessionService.getAllStartBidSession(BidSessionService.java:73) com.zbxsoft.netbid.cache.BidSessionCache.getAllBidSession(BidSessionCache.java:42) com.zbxsoft.netbid.cache.BidSessionCache.getBidSessionBySeid(BidSessionCache.java:217) org.apache.jsp.hall.index_jsp._jspService(index_jsp.java:105) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:432) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:390) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:334) javax.servlet.http.HttpServlet.service(HttpServlet.java:728) com.zbxsoft.netbid.web.ScriptFilter.doFilter(ScriptFilter.java:77) com.zbxsoft.netbid.web.EncodingFilter.doFilter(EncodingFilter.java:40)
note The full stack trace of the root cause is available in the Apache Tomcat logs.