Ankit Dweivedi
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)
April 19, 2011 at 3:57 PM
Use the following query:
String query1="SELECT SQL_CALC_FOUND_ROWS * FROM db2admin.reglimit "+iPageNo+","+showRows+"";
If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.
Ask your questions, our development team will try to give answers to your questions.
