You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@cayenne.apache.org by Scott Anderson <sa...@airvana.com> on 2008/06/05 22:00:21 UTC
Bounded fetch limit
I've seen the setFetchLimit(int) method, but I'm wondering if there's a
way to set a starting row as well, short of using a SQLTemplate or the
like.
Re: Bounded fetch limit
Posted by Robert Zeigler <ro...@puregumption.com>.
I don't think there's an existing jira; I'll create one. :)
Robert
On Jun 5, 2008, at 6/54:16 PM , Andrus Adamchik wrote:
>
> On Jun 5, 2008, at 11:54 PM, Robert Zeigler wrote:
>
>> Any word on when?
>
> That's a tough one. The implementation is very straightforward (and
> in fact QueryMetadata already has a method 'getFetchStartIndex',
> used by ROP). But the list of similar nice-to-have things is rather
> long... I just hope that someday I can take a 6-12 months vacation
> on one of those Pacific islands that have internet backbone cables
> coming through them, turn off the phone, email and IM and do some
> real Cayenne hacking :-)
>
> Anyways, I'll add this to the list. (Is there an existing Jira?)
>
> Andrus
>
>
Re: Bounded fetch limit
Posted by Andrus Adamchik <an...@objectstyle.org>.
On Jun 5, 2008, at 11:54 PM, Robert Zeigler wrote:
> Any word on when?
That's a tough one. The implementation is very straightforward (and in
fact QueryMetadata already has a method 'getFetchStartIndex', used by
ROP). But the list of similar nice-to-have things is rather long... I
just hope that someday I can take a 6-12 months vacation on one of
those Pacific islands that have internet backbone cables coming
through them, turn off the phone, email and IM and do some real
Cayenne hacking :-)
Anyways, I'll add this to the list. (Is there an existing Jira?)
Andrus
Re: Bounded fetch limit
Posted by Robert Zeigler <ro...@puregumption.com>.
Oh, that would be nice. I found myself pining for this feature recently.
Any word on when?
Robert
On Jun 5, 2008, at 6/53:45 PM , Andrus Adamchik wrote:
> We should support the starting row in the future 3.0 milestones. For
> now, yes, the paginated list is one possible workaround.
>
> Andrus
>
>
> On Jun 5, 2008, at 11:41 PM, Scott Anderson wrote:
>
>> Not quite as elegant as what I was hoping for, but that looks like it
>> will do the trick.
>>
>> Thanks, Mike
>>
>> -----Original Message-----
>> From: Mike Kienenberger [mailto:mkienenb@gmail.com]
>> Sent: Thursday, June 05, 2008 4:10 PM
>> To: user@cayenne.apache.org
>> Subject: Re: Bounded fetch limit
>>
>> Maybe paginated queries will do what you need?
>>
>> http://cayenne.apache.org/doc12/paginated-queries.html
>>
>> On Thu, Jun 5, 2008 at 4:00 PM, Scott Anderson
>> <sa...@airvana.com>
>> wrote:
>>> I've seen the setFetchLimit(int) method, but I'm wondering if
>>> there's
>> a
>>> way to set a starting row as well, short of using a SQLTemplate or
>>> the
>>> like.
>>>
>>>
>>
>
Re: Bounded fetch limit
Posted by Andrus Adamchik <an...@objectstyle.org>.
We should support the starting row in the future 3.0 milestones. For
now, yes, the paginated list is one possible workaround.
Andrus
On Jun 5, 2008, at 11:41 PM, Scott Anderson wrote:
> Not quite as elegant as what I was hoping for, but that looks like it
> will do the trick.
>
> Thanks, Mike
>
> -----Original Message-----
> From: Mike Kienenberger [mailto:mkienenb@gmail.com]
> Sent: Thursday, June 05, 2008 4:10 PM
> To: user@cayenne.apache.org
> Subject: Re: Bounded fetch limit
>
> Maybe paginated queries will do what you need?
>
> http://cayenne.apache.org/doc12/paginated-queries.html
>
> On Thu, Jun 5, 2008 at 4:00 PM, Scott Anderson <sa...@airvana.com>
> wrote:
>> I've seen the setFetchLimit(int) method, but I'm wondering if there's
> a
>> way to set a starting row as well, short of using a SQLTemplate or
>> the
>> like.
>>
>>
>
RE: Bounded fetch limit
Posted by Scott Anderson <sa...@airvana.com>.
Not quite as elegant as what I was hoping for, but that looks like it
will do the trick.
Thanks, Mike
-----Original Message-----
From: Mike Kienenberger [mailto:mkienenb@gmail.com]
Sent: Thursday, June 05, 2008 4:10 PM
To: user@cayenne.apache.org
Subject: Re: Bounded fetch limit
Maybe paginated queries will do what you need?
http://cayenne.apache.org/doc12/paginated-queries.html
On Thu, Jun 5, 2008 at 4:00 PM, Scott Anderson <sa...@airvana.com>
wrote:
> I've seen the setFetchLimit(int) method, but I'm wondering if there's
a
> way to set a starting row as well, short of using a SQLTemplate or the
> like.
>
>
Re: Bounded fetch limit
Posted by Mike Kienenberger <mk...@gmail.com>.
Maybe paginated queries will do what you need?
http://cayenne.apache.org/doc12/paginated-queries.html
On Thu, Jun 5, 2008 at 4:00 PM, Scott Anderson <sa...@airvana.com> wrote:
> I've seen the setFetchLimit(int) method, but I'm wondering if there's a
> way to set a starting row as well, short of using a SQLTemplate or the
> like.
>
>