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> 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.


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().


View raw message