[jira] Updated: (CAY-1068) Add support for start index/offset of queries

From: Anton Sakalouski (JIRA) ("Anton)
Date: Wed Jul 09 2008 - 08:08:52 EDT

  • Next message: Anton Sakalouski (JIRA): "[jira] Updated: (CAY-1068) Add support for start index/offset of queries"

         [ https://issues.apache.org/cayenne/browse/CAY-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

    Anton Sakalouski updated CAY-1068:
    ----------------------------------

        Attachment: patch.txt

    The feature implementation. It uses native sql-language capabilities of Mysql, Oracle, HSSQL and Postgre for the rest dbs the first "offset" rows are leaved out in JDBCResultIterator.

    > Add support for start index/offset of queries
    > ---------------------------------------------
    >
    > Key: CAY-1068
    > URL: https://issues.apache.org/cayenne/browse/CAY-1068
    > Project: Cayenne
    > Issue Type: Improvement
    > Components: Cayenne Core Library
    > Affects Versions: 3.0
    > Reporter: Robert Zeigler
    > Assignee: Andrus Adamchik
    > Priority: Minor
    > Attachments: patch.txt
    >
    >
    > Cayenne already allows us to programatically set a query fetch limit.
    > It would be nice if we could also specify a fetch index/fetch offset into a query, to make it simple to fetch, eg, the 100th through the 150th results from the database.

    -- 
    This message is automatically generated by JIRA.
    -
    You can reply to this email to add a comment to the issue online.
    



    This archive was generated by hypermail 2.0.0 : Wed Jul 09 2008 - 08:09:16 EDT