ResultSet is type forward only

[Maria Modeste]

I am a new developer in JSP and Java. I am building a site using JSP and running an SQL statement the following

String Search = "Select claimNo from claim;";
Statement stmt1 =con.createStatement();

ResultSet res = stmt1.executeQuery(Search);

res.first();
int r=0;

while (res.next())
{
r = res.getInt("claimNo");

}
res.close();
out.println(r);

Result set type is TYPE_FORWARD_ONLY. From my research, I understand that a result set can be scrollable or Type_Forward_Only. I tried by initializing the result set to res.first(); before using the result set, but I am still getting the error message.
If I use while (res.last()) I am still receiving the same message. I really want to loop through the result set to the last tuple in my database.

Can anyone help resolve this problem?

[sjalle]

After you do this:

ResultSet res = stmt1.executeQuery(Search);

you are positioned before the first record. Then you loop through like:

while (res.next()) {
  System.out.printlnt(res.getInt("claimNo"));
}

... and thats basically it...