Hi Daniel, >>>>> "Daniel" == Daniel Noll <[EMAIL PROTECTED]> 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
