jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Conoly, Brett" <Brett.Con...@digitalinsight.com>
Subject RE: LIMIT in SQL queries
Date Fri, 28 Mar 2008 20:45:39 GMT
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.zdila@mwaysolutions.com] 
Sent: Friday, March 28, 2008 4:19 PM
To: users@jackrabbit.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.zdila@mwaysolutions.com]
> Sent: Friday, March 28, 2008 3:31 PM
> To: users@jackrabbit.apache.org
> Subject: Re: LIMIT in SQL queries
>
> hi brett
>
> final Query query =
> session.getWorkspace().getQueryManager().createQuery(queryString,
> 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.zdila@mwaysolutions.com
http://www.mwaysolutions.com
xmpp:zdila@jabbim.sk (Jabber)
skype:m.zdila

Mime
View raw message