jdbc - java.sql.SQLException: No data found

Question

Its a part of Ajax jsp page

while(rs.next())  
  {
      System.out.println(rs.getString("Flat_No"));
      buffer=buffer+"<option value='"+rs.getString("Flat_No")+"'>"+rs.getString("Flat_No")+"</option>";   
  } 

There are total 4 values in Flat_No it printing first values in console and aftr that i m getting error on my jsp page "java.sql.SQLException: No data found "

Answer 1

This is a typical error when using the MS Access database through the poor JDBC-ODBC bridge driver and retrieving the same data more than once from the result set. You need to retrieve the data once and assign it to a variable and use the variable multiple times instead.

while (rs.next()) {
    String flatNo = rs.getString("Flat_No");
    buffer += "<option value='" + flatNo + "'>" + flatNo + "</option>";   
}

---

Unrelated to the concrete problem, doing this in a JSP file is a bad idea. See also Show JDBC ResultSet in HTML in JSP page using MVC and DAO pattern for another concrete example how to do it the proper way.