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 12:58:15 GMT

Hi Daniel,

>>>>> "Daniel" == Daniel Noll <daniel@nuix.com.au> wrote:
Daniel> Yeah, I found that too.  It does still seem odd that I should be getting 
Daniel> an error about the result set being forward only, when I'm only moving 
Daniel> forward, but maybe that's just a poor error message on the part of 
Daniel> either JDBC or Derby.

I guess the JDBC specification (Derby is compliant here, it is *not*
an error) is the way it is to allow implementations to offer scroll
forward without requiring any means of explicit positioning (skipping

Daniel> Stepping through with next() is a bit unreasonable though.  Is it fast?  

I would assume most implementations fetch the data over the network
once you do next. Derby does, using a prefetch of 64 rows.

Daniel> I guess as long as it doesn't result in any network traffic due to the 
Daniel> row data itself, it's fine.  But if it does transfer the row data when I 
Daniel> won't be using it, then stepping over 10,000 rows would be
Daniel> slow.

If you know you wouldn't be visiting 10,000 rows without looking at
them, maybe there a way to make the query result set smaller?
If not, I guess it will be slow...

Daniel> Is there really no way to do OFFSET/LIMIT in Derby?  That would have 

Not to my knowledge. 


Daniel> been the traditional way to do paging.
Daniel> Daniel
Daniel> -- 
Daniel> Daniel Noll
Daniel> NUIX Pty Ltd
Daniel> Level 8, 143 York Street, Sydney 2000
Daniel> Phone: (02) 9283 9010
Daniel> Fax:   (02) 9283 9020
Daniel> This message is intended only for the named recipient. If you are not
Daniel> the intended recipient you are notified that disclosing, copying,
Daniel> distributing or taking any action in reliance on the contents of this
Daniel> message or attachment is strictly prohibited.
Dag H. Wanvik
Sun Microsystems, Web Services, Database Technology Group
Haakon VII gt. 7b, N-7485 Trondheim, Norway
Tel: x43496/+47 73842196, Fax:  +47 73842101

NOTICE: This email message is for the sole use of the intended
recipient(s) and may contain confidential and privileged
information. Any unauthorized review, use, disclosure or distribution
is prohibited. If you are not the intended recipient, please contact
the sender by reply email and destroy all copies of the original

View raw message