pagination.jsp:

pagination.jsp:

After runing this jsp it again gives exception . pls can u tell what is reason behind this ?? An Exception is that:-

org.apache.jasper.JasperException: An exception occurred processing JSP page /jsp/pagination.jsp at line 49

46: } 47: String query1="SELECT SQLCALCFOUND_ROWS * FROM db2admin.reg limit "+iPageNo+","+showRows+""; 48: ps1=conn.prepareStatement(query1); 49: ResultSet rs1=ps1.executeQuery(); 50: 51: String query2="SELECT FOUND_ROWS() as cnt"; 52: ps2=conn.prepareStatement(query2);

Stacktrace: org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:524) org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:417) org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320) org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266) javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

View Answers

April 19, 2011 at 3:57 PM

Use the following query:

String query1="SELECT SQL_CALC_FOUND_ROWS * FROM db2admin.reglimit "+iPageNo+","+showRows+"";









Related Tutorials/Questions & Answers:

Ads