HTTP Status 500 – Internal Server Error


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 uuid, url, doc_date, title, summary, '人民币' AS query FROM bank_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '人民币' AS query FROM forex_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '人民币' AS query FROM stock_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '人民币' AS query FROM metal_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)

	UNION
			(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM bank_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM forex_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM stock_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM metal_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)

	UNION
			(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM bank_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM forex_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM stock_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM metal_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)

	
: 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 uuid, url, doc_date, title, summary, '人民币' AS query FROM bank_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '人民币' AS query FROM forex_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '人民币' AS query FROM stock_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '人民币' AS query FROM metal_news
WHERE (
 utitle LIKE '%人民币%' 
OR usummary LIKE '%人民币%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)

	UNION
			(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM bank_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM forex_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM stock_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '日元 利差 交易' AS query FROM metal_news
WHERE (
 utitle LIKE '%日元%' 
OR usummary LIKE '%日元%' 
OR
 utitle LIKE '%利差%' 
OR usummary LIKE '%利差%' 
OR
 utitle LIKE '%交易%' 
OR usummary LIKE '%交易%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)

	UNION
			(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM bank_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM forex_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM stock_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)
UNION
(
SELECT uuid, url, doc_date, title, summary, '澳元 行情' AS query FROM metal_news
WHERE (
 utitle LIKE '%澳元%' 
OR usummary LIKE '%澳元%' 
OR
 utitle LIKE '%行情%' 
OR usummary LIKE '%行情%' 
) AND status = 0
AND doc_date is not null 
AND last_updated > DATE_SUB(now(), INTERVAL 1 WEEK)
LIMIT 3 
)

	
: 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.stat_005ftop_005fsearched_005fquery_005fweekly_html._jspService(stat_005ftop_005fsearched_005fquery_005fweekly_html.java:2979)
	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.stat_005ftop_005fsearched_005fquery_005fweekly_html._jspService(stat_005ftop_005fsearched_005fquery_005fweekly_html.java:1796)
	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.ByteArrayRow.getValue(ByteArrayRow.java:91)
	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.stat_005ftop_005fsearched_005fquery_005fweekly_html._jspService(stat_005ftop_005fsearched_005fquery_005fweekly_html.java:1796)
	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.


Apache Tomcat/8.5.98