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 "

Community · Accepted Answer · 2017-05-23 12:01:38Z

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, 2017 at 12:01

CommunityBot

11 silver badge

answered Feb 29, 2012 at 18:37

BalusC

1.1m377 gold badges3.7k silver badges3.6k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Shaggy Over a year ago

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

BalusC Over a year ago

You're welcome. Be careful with XSS and SQL injection attack holes.

Collectives™ on Stack Overflow

java.sql.SQLException: No data found

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related