HTTP Status 500 – Internal Server Error


Type Exception Report

Message java.sql.SQLException: Illegal operation on empty result set.

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

Exception

javax.servlet.ServletException: java.sql.SQLException: Illegal operation on empty result set.
	org.apache.struts.action.RequestProcessor.processException(RequestProcessor.java:545)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:486)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

java.sql.SQLException: Illegal operation on empty result set.
	com.mysql.jdbc.ResultSet.checkRowPos(ResultSet.java:659)
	com.mysql.jdbc.ResultSet.getNativeInt(ResultSet.java:3636)
	com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2338)
	com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2353)
	discoland.DBAccess.getComment(DBAccess.java:2590)
	discoland.ViewComment.execute(ViewComment.java:35)
	org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:484)
	org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:274)
	org.apache.struts.action.ActionServlet.process(ActionServlet.java:1482)
	org.apache.struts.action.ActionServlet.doGet(ActionServlet.java:507)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:634)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:741)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Note The full stack trace of the root cause is available in the server logs.


Apache Tomcat/9.0.12