title: how to display limited records in a jsp page
body: <p>i need to display limited no of records in a my page. i have around 10,000 records and when I run my java web application,on submitting the form it says "Error query" 10,650 matches found, can fetch  less than 995 rows only".</p>
  
  <p>hence how do I use pagination and print say 500 records each page?</p>
  
  <p>Any ideas is really helpful.</p>
  
  <pre><code> &lt;table name="Table1" style="width:300px" border="1" cellpadding="5"&gt;
  &lt;thead&gt;
   &lt;th&gt;FullName&lt;/th&gt;
  &lt;th&gt;Givename&lt;/th&gt;
  &lt;th&gt;LastName&lt;/th&gt;
    &lt;th&gt;Manager&lt;/th&gt;
      &lt;th&gt;Email&lt;/th&gt;
     &lt;th&gt;PhoneNumber&lt;/th&gt;
         &lt;th&gt;Title&lt;/th&gt;
       &lt;th&gt;Description&lt;/th&gt;
           &lt;/thead&gt;
  
          &lt;tbody&gt;
  &lt;%
  
    for(User temp1:users)
    {
  
    out.print("&lt;tr&gt;");
  
    out.print("&lt;td&gt;");
  
     out.print(temp1.getFullName());
  
        out.print("&lt;/td&gt;");
    out.print("&lt;td&gt;");
  
    out.print(temp1.getGivenName());
  
    out.print("&lt;/td&gt;"); 
    out.print("&lt;td&gt;");
  
   out.print(temp1.getSn());
  
   out.print("&lt;/td&gt;"); 
   out.print("&lt;td&gt;");
  
   out.print(temp1.getManager());
  
    out.print("&lt;/td&gt;"); 
    out.print("&lt;td&gt;");
  
   out.print(temp1.getEmail());
  
    out.print("&lt;/td&gt;"); 
   out.print("&lt;td&gt;");
  
  out.print(temp1.getTelephoneNumber());
  
   out.print("&lt;/td&gt;"); 
   out.print("&lt;td&gt;");
  
   out.print(temp1.getTitle());
  
   out.print("&lt;/td&gt;"); 
   out.print("&lt;td&gt;");
  
  out.print(temp1.getDescription());
  
  out.print("&lt;/td&gt;"); 
  
  
    out.print("&lt;/tr&gt;");
  
      }
     %&gt;&lt;/tbody&gt;
     &lt;/table&gt;
  </code></pre>
  
  <p>It will print row by row.the output is more than 10,000 records hence I need to fetch it 500 records per page. Now did you get my question?Thanks</p>