Type Exception Report
Message javax.servlet.ServletException: javax.servlet.jsp.JspException:
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.apache.jasper.JasperException: javax.servlet.ServletException: javax.servlet.jsp.JspException: SELECT * FROM bank_news WHERE bank_id = '7' AND doc_date is not null group by url order by doc_date desc limit 5 : Zero date value prohibited org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:618) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:488) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Root Cause
javax.servlet.ServletException: javax.servlet.jsp.JspException: SELECT * FROM bank_news WHERE bank_id = '7' AND doc_date is not null group by url order by doc_date desc limit 5 : Zero date value prohibited org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:904) org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:833) org.apache.jsp.tc.indiv_005fbank_005fcurrency_html._jspService(indiv_005fbank_005fcurrency_html.java:3337) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Root Cause
java.sql.SQLException: Zero date value prohibited com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:130) com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:98) com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:90) com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:64) com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:74) com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:99) com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1222) org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.getObject(DelegatingResultSet.java:734) org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.getObject(DelegatingResultSet.java:734) org.apache.taglibs.standard.tag.common.sql.ResultImpl.<init>(ResultImpl.java:91) org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:216) org.apache.jsp.tc.indiv_005fbank_005fcurrency_html._jspService(indiv_005fbank_005fcurrency_html.java:2535) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Root Cause
com.mysql.cj.exceptions.DataReadException: Zero date value prohibited com.mysql.cj.result.LocalDateTimeValueFactory.localCreateFromDatetime(LocalDateTimeValueFactory.java:84) com.mysql.cj.result.LocalDateTimeValueFactory.localCreateFromDatetime(LocalDateTimeValueFactory.java:44) com.mysql.cj.result.AbstractDateTimeValueFactory.createFromDatetime(AbstractDateTimeValueFactory.java:104) com.mysql.cj.protocol.a.MysqlTextValueDecoder.decodeDatetime(MysqlTextValueDecoder.java:94) com.mysql.cj.protocol.result.AbstractResultsetRow.decodeAndCreateReturnValue(AbstractResultsetRow.java:87) com.mysql.cj.protocol.result.AbstractResultsetRow.getValueFromBytes(AbstractResultsetRow.java:244) com.mysql.cj.protocol.a.result.TextBufferRow.getValue(TextBufferRow.java:131) com.mysql.cj.jdbc.result.ResultSetImpl.getLocalDateTime(ResultSetImpl.java:955) com.mysql.cj.jdbc.result.ResultSetImpl.getObject(ResultSetImpl.java:1219) org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.getObject(DelegatingResultSet.java:734) org.apache.tomcat.dbcp.dbcp2.DelegatingResultSet.getObject(DelegatingResultSet.java:734) org.apache.taglibs.standard.tag.common.sql.ResultImpl.<init>(ResultImpl.java:91) org.apache.taglibs.standard.tag.common.sql.QueryTagSupport.doEndTag(QueryTagSupport.java:216) org.apache.jsp.tc.indiv_005fbank_005fcurrency_html._jspService(indiv_005fbank_005fcurrency_html.java:2535) org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:465) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:383) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:331) javax.servlet.http.HttpServlet.service(HttpServlet.java:583) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:51)
Note The full stack trace of the root cause is available in the server logs.