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 "

score 11 · Accepted Answer · edited May 23 '17 at 12:01

11

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.

edited May 23 '17 at 12:01

Community

1
1

answered Feb 29 '12 at 18:37

BalusC

1,082,665
372
3,610
3,555

Solved..Thanks..I am also in support for MVC..but my organisation says don't use it as my project business logic is not that big/my project mostly doing DB operations such as INSERT,UPDATE,DELETE – Shaggy Feb 29 '12 at 18:49
1

You're welcome. Be careful with XSS and SQL injection attack holes. – BalusC Feb 29 '12 at 18:50

java.sql.SQLException: No data found

1 Answers1

Linked

Related