Hi Daniel, >>>>> "Daniel" == Daniel Noll <[EMAIL PROTECTED]> 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 forward). 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> Daniel> Is there really no way to do OFFSET/LIMIT in Derby? That would have Not to my knowledge. Thanks, Dag Daniel> been the traditional way to do paging. Daniel> Daniel> Daniel Daniel> Daniel> -- Daniel> Daniel Noll Daniel> Daniel> NUIX Pty Ltd Daniel> Level 8, 143 York Street, Sydney 2000 Daniel> Phone: (02) 9283 9010 Daniel> Fax: (02) 9283 9020 Daniel> 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. Daniel> -- 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 message. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
