You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cayenne.apache.org by "Robert Zeigler (JIRA)" <de...@cayenne.apache.org> on 2008/06/05 23:28:52 UTC
[jira] Created: (CAY-1068) Add support for start index/offset of
queries
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
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.
[jira] Updated: (CAY-1068) Add support for start index/offset of
queries
Posted by "Anton Sakalouski (JIRA)" <de...@cayenne.apache.org>.
[ 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.
[jira] Closed: (CAY-1068) Add support for start index/offset of
queries
Posted by "Andrus Adamchik (JIRA)" <de...@cayenne.apache.org>.
[ https://issues.apache.org/cayenne/browse/CAY-1068?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Andrus Adamchik closed CAY-1068.
--------------------------------
Resolution: Fixed
Fix Version/s: 3.0
> 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
> Fix For: 3.0
>
> Attachments: patch.txt, 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.
[jira] Updated: (CAY-1068) Add support for start index/offset of
queries
Posted by "Anton Sakalouski (JIRA)" <de...@cayenne.apache.org>.
[ 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
refactored version of the same patch.
> 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, 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.