jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Neil <ncorbe...@hotmail.com>
Subject ISDESCENDANTNODE Sql2 query fails in Jackrabbit 2.2.1
Date Mon, 24 Jan 2011 14:50:11 GMT

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.

Mime
View raw message