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 <[email protected]> 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
