Online Training Spring Hibernate Training in Delhi R Programming Training Course Big Data and Hadoop Training Java Training  




Share on Google+Share on Google+

Ankit Dweivedi
1 Answer(s)      6 years and 3 months ago
Posted in : JSP-Servlet

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( org.apache.jasper.servlet.JspServletWrapper.service( org.apache.jasper.servlet.JspServlet.serviceJspFile( org.apache.jasper.servlet.JspServlet.service( javax.servlet.http.HttpServlet.service(

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: