Hi Daniel,
>>>>> "Daniel" == Daniel Noll <daniel@nuix.com.au> wrote:
Daniel> However, absolute(101) throws an error, and relative(101) throws an error.
Daniel>
Daniel> Am I really expected to call next() N times to get to the row I want?
Daniel> What if I want row 10,000?
The JDBC 3.0 JavaDoc says both relative and absolute are illegal for
FORWARD_ONLY, I am afraid, cf.
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html#relative(int)
http://java.sun.com/j2se/1.4.2/docs/api/java/sql/ResultSet.html#absolute(int)
See also, the 3.0 specification (section 14.2.2) which states: "For a
ResultSet object that is of type TYPE_FORWARD_ONLY, the only valid
cursor movement method is next. All other cursor movement methods
throw an SQLException."
So, yes, you will have to step through with next().
Dag
|