[Bug 2055] New: Implement "skipping over results" in prepared statements

[bugzilla-daemon at icedtea.classpath.org]

http://icedtea.classpath.org/bugzilla/show_bug.cgi?id=2055

            Bug ID: 2055
           Summary: Implement "skipping over results" in prepared
                    statements
           Product: Thermostat
           Version: hg
          Hardware: x86_64
                OS: Linux
            Status: NEW
          Severity: enhancement
          Priority: P5
         Component: Thermostat
          Assignee: unassigned at icedtea.classpath.org
          Reporter: sgehwolf at redhat.com
                CC: thermostat at icedtea.classpath.org

See bug 2021 for the original idea. There is no way for a user to skip over
some results. One use case would be to support paged loading of hosts. E.g.
load the first 100 hosts and only once the user scrolls down load more. In the
latter case one would like to do something like:

QUERY hosts WHERE 'foo' = ?s SKIP 100 LIMIT 100

This should return results 101 up to 200. Using cursors is too late in the game
since - in order to save on the number of HTTP requests issued - a web cursor
comes back with some results already. Alternative would be to return no results
and require another HTTP request to actually fetch results. IMHO a better
approach is to know this right away and do the right thing(tm). Thus, something
like skip would be needed.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.openjdk.java.net/pipermail/distro-pkg-dev/attachments/20141028/59cc42dc/attachment-0001.html>