db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik" <Dag.Wan...@Sun.COM>
Subject Re: CLOBs and the Client driver
Date Thu, 06 Oct 2005 00:12:36 GMT

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

Mime
View raw message