jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Furst, Carl" <Carl.Fu...@mlb.com>
Subject Re: jcr sql2 - contains() full text search not working
Date Wed, 27 Jun 2012 17:59:03 GMT
Thanks Torsten,

So even using JQOM would not help here. I'll read up more on lucine and
find out more. My main stumbling block here was where the query was being
executed. Was it on the Derby level or the Lucine level..

This has cleared that part of it up for me as well.

Thanks again,

Carl Furst






On 6/27/12 1:50 PM, "Torsten Stolpmann" <stolpmann@verit.de> wrote:

>Hi Carl,
>
>per default the underlying Lucene implementation does not match leading
>wildcards for performance reasons. See also:
>https://wiki.apache.org/lucene-java/LuceneFAQ#What_wildcard_search_support
>_is_available_from_Lucene.3F
>
>So just matching '*' will not work, but eg. 'i*' might give you the
>results you were looking for.
>
>Sadly enough I did not find any reference to this in the JackRabbit
>documentation.
>
>Took me quite a while to find that too.
>
>Hope this helps,
>
>Torsten
>
>On 27.06.2012 17:19, Furst, Carl wrote:
>> I'm probably missing something here but everything I've read so far
>>leads
>> me to believe this should work..
>>
>> I have nodes in a repositoy of type nt:folder and nt:file. nt:file has a
>> child node jcr:content of type nt:resource which has a child property
>> called jcr:data
>>
>> There are many cases where the jcr:data column has the world 'include'
>>in
>> it. They are jsp files so, yes, I know this word exists in several
>>files.
>>
>> So here's the sql I use:
>>
>> select * from [nt:resource] where  contains([jcr:data], 'include');
>>
>> Here's the sql that is returned from q.getStatement() :
>>
>> SELECT [nt:resource].* FROM [nt:resource] WHERE
>> CONTAINS([nt:resource].[jcr:data], 'include');
>>
>> Here is a sample text in jcr:data to search on.
>>
>> <%@ include file="..."
>>
>>
>> ... More jsp here..
>> <%/jsp:include...
>>
>> Yet it doesn┬╣t find it. I feel I'm missing something.. Do I need to add
>>a
>> "searchable" mixin or something?
>>
>> Any ideas why this is not being found?
>>
>> It used to be that apache had the cdn file for jackrabbit node types was
>> readily available. Does anyone know where I can find the cdn file for
>> jackrabbit node types?
>>
>> jcr:content is unstructured, but I explicitly make the type nt:resource
>> (otherwise the statement would would not be parsed, Query object would
>> throw an error, like "table not found," right? Because the type is a
>> table). So the type is right.. The field is right.. The search is not
>> working.
>>
>>
>> I'm using Jackrabbit without any special configuration. Just the war in
>>a
>> simple tomcat deployment. So it's sitting on top of Derby and Lucine.
>>
>>
>> Any help would be appreciated.
>>
>> Thanks,
>>
>> Carl Furst
>>
>>
>>
>>
>>
>>
>>
>> **********************************************************
>>
>> MLB.com: Where Baseball is Always On
>>
>






**********************************************************

MLB.com: Where Baseball is Always On
Mime
View raw message