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 19:38:06 GMT
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