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:[EMAIL PROTECTED] Sent: Friday, March 28, 2008 4:19 PM To: [email protected] 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:[EMAIL PROTECTED] > Sent: Friday, March 28, 2008 3:31 PM > To: [email protected] > 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:[EMAIL PROTECTED] http://www.mwaysolutions.com xmpp:[EMAIL PROTECTED] (Jabber) skype:m.zdila
