Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm
Precedence: bulk
Reply-To: users@jackrabbit.apache.org
Received-SPF: error (athena.apache.org: local policy)
Date: Mon, 17 Jun 2013 10:44:16 +0200 (CEST)
From: Ulrich <Forums@gombers.de>
Reply-To: Ulrich <Forums@gombers.de>
To: jackrabbit <users@jackrabbit.apache.org>
Message-ID: <580215121.304333.1371458656285.open-xchange@com4.strato.de>
In-Reply-To: <1324617394.293657.1371456085527.open-xchange@com4.strato.de>
References: <1324617394.293657.1371456085527.open-xchange@com4.strato.de>
Subject: Re: JCR-JQOM: JOIN returns Message: WARN  NodeIteratorImpl -
 Exception retrieving Node with Id: null
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
Importance: Medium

I tried the same example with JCR-SQL2. This fails for another reason - but may
help to understand what I try to do:

queryString = "select * from [nt:file] as parent " +
              "inner join [nt:resource] as child on ISCHILDNODE(child,parent)" +
               "WHERE ISDESCENDANTNODE([descendant],/content/testit)";

Here I get an Exception; there is probably a syntax error in the queryString.
(I'm not familiar with the syntax).

Exception in thread "main" javax.jcr.query.InvalidQueryException: Query:
select * from [nt:file] as parent inner join [nt:resource] as child on
ISCHILDNODE(child,parent)WHERE
ISDESCENDANTNODE([descendant],/content(*)/testit); expected: )

Ulrich


> Ulrich <Forums@gombers.de> hat am 17. Juni 2013 um 10:01 geschrieben:
>
>
> Still fighting with JCR-JQOM:
> I need to retrieve "jcr:lastModified" from jcr:contend-childnode of every
> nt:file-Node. My approach is:
>
> Selector ntFileSelector = qomf.selector("nt:file", "Parent");
> Selector jcrContentSelector = qomf.selector("nt:resource", "Child");
> Join join = qomf.join(ntFileSelector, jcrContentSelector,
> QueryObjectModelFactory.JCR_JOIN_TYPE_INNER,
>      qomf.childNodeJoinCondition(jcrContentSelector.getSelectorName(),
> ntFileSelector.getSelectorName()));
> Constraint getSubtree = qomf.descendantNode(ntFileSelector.getSelectorName(),
> subtree);
> QueryObjectModel qom = qomf.createQuery(join, getSubtree, null, null);
> QueryResult queryResult = qom.execute();
> nodeIterator = queryResult.getNodes();
>
> From this I get four times the message:
>    WARN  NodeIteratorImpl - Exception retrieving Node with Id: null
> This means I get this message for every node which I expected to be selected
> within the subtree.
>
> If I run the query without the "JOIN":
> QueryObjectModel qom = qomf.createQuery(ntFileSelector, getSubtree, null,
> null);
> it is fine.
>
> brdgs,
> Ulrich