RE: LIMIT in SQL queries

I really do appreciate your help and I hate to bug you too
much but I
tried implementing your suggestion and it seems that
jackrabbit's rmi
Query implementation does not implement the setLimit or
setOffset
functions.  Am I just looking in the wrong place? Does
anyone have any
clue of an equivalent rmi query that will work for me?
Thanks again

-----Original Message-----
From: Martin Zdila [mailto:m.zdilamwaysolutions.com] 
Sent: Friday, March 28, 2008 4:19 PM
To: usersjackrabbit.apache.org
Subject: Re: LIMIT in SQL queries

hi brett

afaik it is planned for the JCR 2. see 
http://wiki.apache.org/jackrabbit/Proposed_JCR_2.0
_API_Changes

cu

On Fri 28. March 2008 20:38:06 Conoly, Brett wrote:
> Awesome, I don't know that I ever would have found
that.  My only
> question is does anyone know if there are plans to make
the LIMIT
> functionality a requirement for all JCR
implementations?  In other
words
> so it will be portable among all JSR-170 compliant
repositories?
> Thanks again,
> Brett
>
>
> -----Original Message-----
> From: Martin Zdila [mailto:m.zdilamwaysolutions.com]
> Sent: Friday, March 28, 2008 3:31 PM
> To: usersjackrabbit.apache.org
> Subject: Re: LIMIT in SQL queries
>
> hi brett
>
> final Query query =
>
session.getWorkspace().getQueryManager().createQuery(querySt
ring,
> Query.XPATH);
> ((QueryImpl) query).setLimit(limit);
> ((QueryImpl) query).setOffset(offset);
> final QueryResult queryResult = query.execute();
> final long totalSize = ((QueryResultImpl)
queryResult).getTotalSize();
>
> cu
>
> On Fri 28. March 2008 20:27:25 Conoly, Brett wrote:
> > Hey all,
> >
> > I'm currently trying to implement a method that
will return a
> > NodeIterator from the repository based on an SQL
query that I pass
it.
> > The only problem right now is that I can't seem to
find the
equivalent
> > of the SQL LIMIT function.  Does anyone happen to
know if there is
> > equivalent functionality or an alternative to do
what I'm looking
for?
> >
> > Thanks in advance,
> >
> > Brett

-- 
Martin Zdila 
CTO

M-Way Solutions Slovakia s.r.o.
Letna 27, 040 01 Kosice
Slovakia

tel:+421-908-363-848
mailto:m.zdilamwaysolutions.com
http://www.mwaysolutions
.com
xmpp:zdilajabbim.sk (Jabber)
skype:m.zdila

Hi,

On Fri, Mar 28, 2008 at 10:45 PM, Conoly, Brett
<Brett.Conolydigitalinsight.com> wrote:
> I really do appreciate your help and I hate to bug you
too much but I
>  tried implementing your suggestion and it seems that
jackrabbit's rmi
>  Query implementation does not implement the setLimit
or setOffset
>  functions.  Am I just looking in the wrong place?

The RMI layer does not currently support he setLimit and
setOffset methods.

> Does anyone have any clue of an equivalent rmi query
that will work for me?

The pure JCR 1.0 way to simulate offset/limit is the
following:

    QueryResult result = ...;
    NodeIterator nodes = result.getNodes();
    nodes.skip(...);
    for (int i = 0; i < ... && nodes.hasNext();
i++) {
        nodes.nextNode();
    }

BR,

Jukka Zitting