jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Seidel. Robert" <Robert.Sei...@aeb.de>
Subject AW: Rather easy SQL2-query?
Date Mon, 14 Feb 2011 09:59:09 GMT
Hi Thomas,

the problem was getNodes() doesn't work with joins.

So it will be better to change the message to something like:

The getNodes() method does not work with joins, you have to use getRows() instead.

Regards, Robert

-----Urspr√ľngliche Nachricht-----
Von: Thomas Mueller [mailto:mueller@adobe.com] 
Gesendet: Montag, 14. Februar 2011 10:54
An: users@jackrabbit.apache.org
Betreff: Re: Rather easy SQL2-query?


>select f from [nt:unstructured] as x inner join [nt:file] as f on
>isdescendantnode(f, x)  WHERE(*)NAME([x]) = 'HAUPT'; expected: Need to
>specify the selector name because the query contains more than one

The exception message is strange, I will change it to:

javax.jcr.query.InvalidQueryException: Query:
select f(*)from [nt:unstructured] as x inner join [nt:file] as f on
isdescendantnode(f, x)  WHERE NAME([x]) = 'HAUPT'; expected: Need to
specify the selector name for "f" because the query contains more than one


View raw message