Thursday, February 14, 2008 09:39 AM
Could it be possible that the
boolean b = rs.first();
is attempting to set the cursor to the first element in the result set, but since there is none, it returns an invalid cursor state when you try to access it.
I have a tendency to use something like...
String str = rs.getString(1);
In almost all implementations, this will give a false
return when there is no ResultSet.
Like Robert says, it seems to be a bad implementation of the driver. Try using something besides a JDBC/OBDC driver if there is one available.