SQL Exception: Cursor state not valid

[Dominic Steng�rd]

Hey fellow javacoders!

Im running JDBC on top of a DB2 database.
When I run the following code:

 
private boolean validateResultSetData(ResultSet rs) {
        try {
while(rs.next()) {
double var4 = rs.getDouble(4);
double var3 = rs.getDouble(3);
int var2 = rs.getInt(2);
String var1 = rs.getString(1).trim();

// Do something to collected data ...
}
rs.beforeFirst();
} catch (SQLException e) {
System.out.println("SQLException: " + e.getMessage(  ));
LOGGER.error("Error occured while quering database", e);
}
return true;
}

I get the following error when rs.beforeFirst() is executed:

SQL Exception: Cursor state not valid.

Have you guys got any thoughts on why this is happening and how to solve it?
Thanks in advance!

Kind regards
[ March 08, 2008: Message edited by: Dominic Steng�rd ]

[Herman Schelti]

hi Dominic,

rs.beforeFirst(); 

Check DB2's documentation if it supports this at all.
Lookign at your code, I think you don't need this line anyway.

Herman