jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rakesh Vidyadharan <rak...@sptci.com>
Subject Re: Equivalent JCR_SQL2 statement
Date Wed, 11 Nov 2009 11:51:19 GMT

On 11 Nov 2009, at 3:23:42 AM, Marcel Reutegger wrote:

> Hi,
> 
> please note that there are no plans to abandon XPath support in
> jackrabbit. the deprecation status is only with the specification.
> therefore I suggest you stick with XPath unless you need functionality
> that requires JQOM or SQL-2.

Thanks, that is good news.  I will stick to XPath for now.

> 
> On Mon, Nov 9, 2009 at 14:32, Rakesh Vidyadharan <rakesh@sptci.com> wrote:
>> On 9 Nov 2009, at 1:36:25 AM, Thomas Müller wrote:
>> select * from ['nt:unstructured'] where ['jcr:path'] like '/%/unitTestPage'
>> and ['cms:nodeType'] = 'page'
> 
> that doesn't work because SQL-2 does not support the jcr:path pseudo
> property, which is only present in JCR 1.0 SQL.
> 
> what you rather want is:
> 
> select * from [nt:base] where name() = 'unitTestPage' and
> [cms:nodeType] = 'page'
> 
> regards
> marcel

I tested this as well and still get back no results.  Strange, since I found the SQL2 unit
tests in the QOM package of JR, and I was able to verify my syntax against those.  Anyway,
XPath for me until later.

Thanks
Rakesh
Mime
View raw message