Return-Path: Delivered-To: apmail-jackrabbit-users-archive@minotaur.apache.org Received: (qmail 55277 invoked from network); 25 Jan 2011 12:27:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 25 Jan 2011 12:27:03 -0000 Received: (qmail 12485 invoked by uid 500); 25 Jan 2011 12:27:02 -0000 Delivered-To: apmail-jackrabbit-users-archive@jackrabbit.apache.org Received: (qmail 12359 invoked by uid 500); 25 Jan 2011 12:27:00 -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 Delivered-To: moderator for users@jackrabbit.apache.org Received: (qmail 38262 invoked by uid 99); 24 Jan 2011 14:50:37 -0000 X-ASF-Spam-Status: No, hits=4.5 required=10.0 tests=FREEMAIL_ENVFROM_END_DIGIT,FREEMAIL_FROM,RFC_ABUSE_POST,SPF_SOFTFAIL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: softfail (athena.apache.org: transitioning domain of ncorbet23@hotmail.com does not designate 216.139.236.26 as permitted sender) Date: Mon, 24 Jan 2011 06:50:11 -0800 (PST) From: Neil To: users@jackrabbit.apache.org Message-ID: <1295880611281-3234156.post@n4.nabble.com> Subject: ISDESCENDANTNODE Sql2 query fails in Jackrabbit 2.2.1 MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Jackrabbit 2.2.1 / Tomcat 6.0 After upgrading to Jackrabbit 2.2.1 ( with hopes of increasing query performance ) , we get the following error running what seems to be this simple query: SELECT * FROM [ths:file] as file LEFT OUTER JOIN [ths:name] as names ON ISDESCENDANTNODE(names,file) WHERE (upper(names.[ths:firstName]) = 'JUSTIN') The following exception is returned: org.apache.lucene.search.BooleanQuery$TooManyClauses: maxClauseCount is set to 1024 at org.apache.lucene.search.BooleanQuery.add(BooleanQuery.java:163) at org.apache.lucene.search.BooleanQuery.add(BooleanQuery.java:154) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.getDescendantNodeQuery(LuceneQueryFactory.java:421) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.create(LuceneQueryFactory.java:399) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.addBooleanConstraint(LuceneQueryFactory.java:501) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.addBooleanConstraint(LuceneQueryFactory.java:496) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.getOrQuery(LuceneQueryFactory.java:479) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.create(LuceneQueryFactory.java:378) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.mapConstraintToQueryAndFilter(LuceneQueryFactory.java:365) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.mapConstraintToQueryAndFilter(LuceneQueryFactory.java:313) at org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.execute(LuceneQueryFactory.java:189) at org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:222) at org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:137) at org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:184) at org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:147) at org.apache.jackrabbit.core.query.QueryObjectModelImpl.execute(QueryObjectModelImpl.java:114) at com.ths.server.dao.FileDao.findBySQLQuery(FileDao.java:394) at com.ths.server.dao.FileDao.searchFilesByCriteria(FileDao.java:160) at com.ths.server.servlets.FileSearchServiceImpl.searchByCriteria(FileSearchServiceImpl.java:45) The query worked when we were using Jackrabbit 2.1.0. Any suggestions or help would be greatly appreciated. Thanks in advance, Neil -- View this message in context: http://jackrabbit.510166.n4.nabble.com/ISDESCENDANTNODE-Sql2-query-fails-in-Jackrabbit-2-2-1-tp3234156p3234156.html Sent from the Jackrabbit - Users mailing list archive at Nabble.com.