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:[email protected]] Gesendet: Montag, 14. Februar 2011 10:54 An: [email protected] Betreff: Re: Rather easy SQL2-query? Hi, >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 >selector. 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 selector. Regards, Thomas
