jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Martin Zdila <m.zd...@mwaysolutions.com>
Subject Re: LIMIT in SQL queries
Date Fri, 28 Mar 2008 20:19:27 GMT
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