Return-Path: X-Original-To: apmail-jackrabbit-users-archive@minotaur.apache.org Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id CB233E27B for ; Fri, 23 Nov 2012 10:05:04 +0000 (UTC) Received: (qmail 79434 invoked by uid 500); 23 Nov 2012 10:05:04 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 79394 invoked by uid 500); 23 Nov 2012 10:05:03 -0000 Mailing-List: contact users-help@jackrabbit.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@jackrabbit.apache.org Delivered-To: mailing list users@jackrabbit.apache.org Received: (qmail 79367 invoked by uid 99); 23 Nov 2012 10:05:03 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Nov 2012 10:05:03 +0000 X-ASF-Spam-Status: No, hits=-0.0 required=5.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [194.1.211.22] (HELO smtp-gw.artificial-solutions.com) (194.1.211.22) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 23 Nov 2012 10:04:55 +0000 Received: from webmail.artificial-solutions.com (unknown [192.168.106.11]) by smtp-gw.artificial-solutions.com (Postfix) with ESMTP id 0F1BA4FA0 for ; Fri, 23 Nov 2012 11:04:34 +0100 (CET) X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable Subject: RE: JCR SQL2 query - NullPointerException in DescendantSelfAxisQuery Date: Fri, 23 Nov 2012 11:04:33 +0100 Message-ID: <21F0E9E7ED2D894F8385A92C80336BF30AD77D10@arti-sr-28.artificial-solutions.com> In-Reply-To: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: JCR SQL2 query - NullPointerException in DescendantSelfAxisQuery Thread-Index: Ac3I5qxEK1LTh1uBTFe+lx5qES3XQQAes0mg References: <21F0E9E7ED2D894F8385A92C80336BF30AD77B52@arti-sr-28.artificial-solutions.com> From: "Robert Haycock" To: X-Virus-Checked: Checked by ClamAV on apache.org Reason is because I am not writing this query explicitly and the existing code uses CONTAINS :) Using '=3D' does in fact work. It's a shame CONTAINS doesn't work = though. Thanks. -----Original Message----- From: oliver.gregory@gmail.com [mailto:oliver.gregory@gmail.com]=20 Sent: 22 November 2012 19:21 To: users@jackrabbit.apache.org Subject: Re: JCR SQL2 query - NullPointerException in DescendantSelfAxisQuery Hello Robert, document.libraryVersion and document.documentId are properties ? Why not simply using equality : SELECT * FROM [nt:xxxxNode] AS document WHERE ISDESCENDANTNODE(document, '/thexxxxRoot/07cc41fc-a221- 4fd7-8d2b-0cc8a8719b25') AND document.documentId =3D '378d57e4-0036-4537-bdd4-305e62aa9a67' AND document.libraryVersion =3D 1 Query Examples here : http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-spi-commons/src /test/resources/org/apache/jackrabbit/spi/commons/query/sql2/test.sql2.t xt?view=3Dmarkup 2012/11/22 Manfred Sattler > Have you the right lucene version,3.0.3? > > > Am 22.11.2012 15:42, schrieb Robert Haycock: > > Hi, >> >> >> >> I was trying to do a JCR SQL2 query... >> >> >> >> SELECT * FROM [nt:xxxxNode] AS document WHERE=20 >> ISDESCENDANTNODE(document, >> '/thexxxxRoot/07cc41fc-a221-**4fd7-8d2b-0cc8a8719b25') AND ( CONTAINS >> (document.documentId, '378d57e4-0036-4537-bdd4-**305e62aa9a67') AND=20 >> CONTAINS (document.libraryVersion, '1')) >> >> >> >> ... and got this exception... >> >> >> >> java.lang.NullPointerException >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.**DescendantSelfAxisQuery$* >> * >> Descenda >> ntSelfAxisScorer.nextDoc(**DescendantSelfAxisQuery.java:**474) >> >> at org.apache.lucene.search.** >> Scorer.score(Scorer.java:61) >> >> at >> org.apache.lucene.search.**IndexSearcher.search(**IndexSearcher.java: >> 212) >> >> at >> org.apache.lucene.search.**Searcher.search(Searcher.java:**67) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.** >> SortedLuceneQueryHits.getHits(**So >> rtedLuceneQueryHits.java:156) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.**SortedLuceneQueryHits.> it>( >> **Sor >> tedLuceneQueryHits.java:113) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.**JackrabbitIndexSearcher.* >> * >> evaluate >> (JackrabbitIndexSearcher.java:**109) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.**LuceneQueryFactory.execut >> e(** >> Lucen >> eQueryFactory.java:219) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.join.QueryEngine.** >> execute(QueryEn >> gine.java:465) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.join.QueryEngine.** >> execute(QueryEn >> gine.java:126) >> >> at >> >> org.apache.jackrabbit.core.**query.lucene.join.QueryEngine.** >> execute(QueryEn >> gine.java:115) >> >> at >> >> org.apache.jackrabbit.core.**query.QueryObjectModelImpl$2.** >> perform(QueryObj >> ectModelImpl.java:129) >> >> at >> >> org.apache.jackrabbit.core.**query.QueryObjectModelImpl$2.** >> perform(QueryObj >> ectModelImpl.java:124) >> >> at >> >> org.apache.jackrabbit.core.**session.SessionState.perform(** >> SessionState.jav >> a:216) >> >> at >> >> org.apache.jackrabbit.core.**query.QueryObjectModelImpl.** >> execute(QueryObjec >> tModelImpl.java:123) >> >> This happened in 2.4.3 so I tried 2.5.2 and still got it. >> >> >> >> Is there a workaround? >> >> >> >> Rob. >> >> >> >> Ps. Should exceptions be posted to dev or user? >> > >