HTTP Status 500 – Internal Server Error


Type Exception Report

Message An exception occurred processing [detail.jsp] at line [33]

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

Exception

org.apache.jasper.JasperException: An exception occurred processing [detail.jsp] at line [33]

30: <%
31: Driver DriverR = (Driver)Class.forName(MM_miRNA2Disease_DRIVER).newInstance();
32: Connection ConnR = DriverManager.getConnection(MM_miRNA2Disease_STRING,MM_miRNA2Disease_USERNAME,MM_miRNA2Disease_PASSWORD);
33: PreparedStatement StatementR = ConnR.prepareStatement("SELECT *  FROM miR2Dis.reference_information  WHERE PMID = " + D.getObject("PMID") + "");
34: ResultSet R = StatementR.executeQuery();
35: boolean R_isEmpty = !R.next();
36: boolean R_hasData = !R_isEmpty;


Stacktrace:
	org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:626)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:500)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

javax.servlet.ServletException: java.sql.SQLException: Illegal operation on empty result set.
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:666)
	org.apache.jsp.detail_jsp._jspService(detail_jsp.java:694)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53)

Root Cause

java.sql.SQLException: Illegal operation on empty result set.
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1056)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
	com.mysql.jdbc.SQLError.createSQLException(SQLError.java:927)
	com.mysql.jdbc.ResultSetImpl.checkRowPos(ResultSetImpl.java:817)
	com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4703)
	com.mysql.jdbc.ResultSetImpl.getObject(ResultSetImpl.java:4933)
	org.apache.jsp.detail_jsp._jspService(detail_jsp.java:181)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:71)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:477)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:385)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:329)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:733)
	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.38