HTTP Status 500 - javax.servlet.ServletException: java.sql.SQLException: Connection is closed. Query: select distinct province_code from web_newenergy.ne_bidding_bulletin where ne_type=? and is_show=1 and province!='' group by province_code Parameters: [2]


type Exception report

message javax.servlet.ServletException: java.sql.SQLException: Connection is closed. Query: select distinct province_code from web_newenergy.ne_bidding_bulletin where ne_type=? and is_show=1 and province!='' group by province_code Parameters: [2]

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: Connection is closed. Query: select distinct province_code from web_newenergy.ne_bidding_bulletin where ne_type=? and is_show=1 and province!='' group by province_code Parameters: [2]
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:561)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:462)
	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:731)
	com.jerei.website.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:87)

root cause

javax.servlet.ServletException: java.sql.SQLException: Connection is closed. Query: select distinct province_code from web_newenergy.ne_bidding_bulletin where ne_type=? and is_show=1 and province!='' group by province_code Parameters: [2]
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:916)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:845)
	org.apache.jsp.bidding_005flist_jsp._jspService(bidding_005flist_jsp.java:469)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	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:731)
	com.jerei.website.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:87)

root cause

java.sql.SQLException: Connection is closed. Query: select distinct province_code from web_newenergy.ne_bidding_bulletin where ne_type=? and is_show=1 and province!='' group by province_code Parameters: [2]
	org.apache.commons.dbutils.QueryRunner.rethrow(QueryRunner.java:542)
	org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:399)
	org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:372)
	com.jerei.website.utils.db.DBHelper.list(DBHelper.java:50)
	org.apache.jsp.bidding_005flist_jsp._jspService(bidding_005flist_jsp.java:130)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:731)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:439)
	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:731)
	com.jerei.website.filter.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:87)

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


Apache Tomcat/7.0.85