Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: pass (herse.apache.org: domain of graeme.rocher@gmail.com
 designates 66.249.82.227 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:reply-to:sender:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition:x-google-sender-auth;
        b=kJZHFEIq6xG0xKPwZhW8jvYu+kyO+BvYovQCU09cWGkXVYM4GdQOgyaWVDHToRNpJLztyo8yruAnPpnZgWAlJbrBdPUN8F7b++UyTYbC7PoqTRMFy0dcs3j1f+Sxy6MD9GMQV5eQmf2qCQhyFJmbl4mbGIw7LQgUq3o0IrQ0KMo=
Message-ID: <3f2c19a70702120704y846557cqfab2b3033a5573fe@mail.gmail.com>
Date: Mon, 12 Feb 2007 15:04:26 +0000
From: "Graeme Rocher" <graemerocher@yahoo.co.uk>
Reply-To: graemerocher@yahoo.co.uk
Sender: graeme.rocher@gmail.com
To: users@jackrabbit.apache.org
Subject: Pagination of results & position() comparison queries
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Hi,

I'm trying to figure out how to go about doing some form of pagination
of query results. In Hibernate app you would likely use the
setFirstResult and setMaxResults properties to manipulate the result
set. However, Hibernate handles the various SQL dialect issues around
data pagination for you.

I tried the following with an xpath query:

//wiki:WikiEntry[(position() > 10) and (position() < 20)]

which I was hoping would return me all the "WikiEntry" items between
10 and 20, however it throws this exception:

javax.jcr.query.InvalidQueryException: Unsupported expression with
position(). Only = is supported.

So given that this kind of comparison is not supported with the
position() function, how would I go about creating the query I'm
after? Is it possible at all?

Regards,

-- 
Graeme Rocher
Grails Project Lead
http://grails.org