HTTP Status 500 – Internal Server Error


Type Exception Report

Message javax.servlet.ServletException: com.cgbid.util.AppException: net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.cgbid.message.CgNewsdate newSimp WHERE newSimp.status=1 and newSimp.viewStatus=0 AND ( ) and newSimp.putdate >= to_date('2002-01-01','yyyy-mm-dd HH24:mi:ss') and newSimp.putdate <= to_date('2024-03-30','yyyy-mm-dd HH24:mi:ss') ORDER BY newSimp.putdate DESC]

Description The server encountered an unexpected condition that prevented it from fulfilling the request.

Exception

org.apache.jasper.JasperException: javax.servlet.ServletException: com.cgbid.util.AppException: net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.cgbid.message.CgNewsdate newSimp WHERE  newSimp.status=1   and newSimp.viewStatus=0  AND  (  )  and newSimp.putdate >= to_date('2002-01-01','yyyy-mm-dd HH24:mi:ss') and newSimp.putdate <= to_date('2024-03-30','yyyy-mm-dd HH24:mi:ss') ORDER BY newSimp.putdate DESC]
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:582)
	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: com.cgbid.util.AppException: net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.cgbid.message.CgNewsdate newSimp WHERE  newSimp.status=1   and newSimp.viewStatus=0  AND  (  )  and newSimp.putdate >= to_date('2002-01-01','yyyy-mm-dd HH24:mi:ss') and newSimp.putdate <= to_date('2024-03-30','yyyy-mm-dd HH24:mi:ss') ORDER BY newSimp.putdate DESC]
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:907)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:833)
	org.apache.jsp.client.news.news_jsp._jspService(news_jsp.java:1086)
	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.cgbid.util.AppException: net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.cgbid.message.CgNewsdate newSimp WHERE  newSimp.status=1   and newSimp.viewStatus=0  AND  (  )  and newSimp.putdate >= to_date('2002-01-01','yyyy-mm-dd HH24:mi:ss') and newSimp.putdate <= to_date('2024-03-30','yyyy-mm-dd HH24:mi:ss') ORDER BY newSimp.putdate DESC]
	com.cgbid.message.CgNewsManagerImpl.getSeeNews(CgNewsManagerImpl.java:707)
	org.apache.jsp.client.news.news_jsp._jspService(news_jsp.java:372)
	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

net.sf.hibernate.QueryException: Incorrect query syntax [FROM com.cgbid.message.CgNewsdate newSimp WHERE  newSimp.status=1   and newSimp.viewStatus=0  AND  (  )  and newSimp.putdate >= to_date('2002-01-01','yyyy-mm-dd HH24:mi:ss') and newSimp.putdate <= to_date('2024-03-30','yyyy-mm-dd HH24:mi:ss') ORDER BY newSimp.putdate DESC]
	net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:166)
	net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
	net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294)
	net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562)
	net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533)
	net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
	com.cgbid.message.CgNewsManagerImpl.getSeeNews(CgNewsManagerImpl.java:704)
	org.apache.jsp.client.news.news_jsp._jspService(news_jsp.java:372)
	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.util.NoSuchElementException
	java.util.LinkedList.getLast(LinkedList.java:257)
	net.sf.hibernate.hql.WhereParser.closeExpression(WhereParser.java:293)
	net.sf.hibernate.hql.WhereParser.token(WhereParser.java:233)
	net.sf.hibernate.hql.ClauseParser.token(ClauseParser.java:87)
	net.sf.hibernate.hql.PreprocessingParser.token(PreprocessingParser.java:123)
	net.sf.hibernate.hql.ParserHelper.parse(ParserHelper.java:29)
	net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:149)
	net.sf.hibernate.hql.QueryTranslator.compile(QueryTranslator.java:138)
	net.sf.hibernate.impl.SessionFactoryImpl.getQuery(SessionFactoryImpl.java:294)
	net.sf.hibernate.impl.SessionImpl.getQueries(SessionImpl.java:1562)
	net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1533)
	net.sf.hibernate.impl.QueryImpl.list(QueryImpl.java:39)
	com.cgbid.message.CgNewsManagerImpl.getSeeNews(CgNewsManagerImpl.java:704)
	org.apache.jsp.client.news.news_jsp._jspService(news_jsp.java:372)
	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.96