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.