You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Sa...@innovations.de on 2010/10/06 10:12:25 UTC

SQL CONTAINS function

Hi all,

 

I am using Jackrabbit 1.6.2 and have problems with a SQL statement using
the "CONTAINS" function. I want to perform a fulltext search on the
binary content of my files stored in jackrabbit. The files have a
primary node type of nt:file and the jcr:content child node is of type
nt:resource. The content of the file is indexed. Now I want to perform a
fulltext search with the following statement:

 

SELECT * FROM nt:base WHERE contains(jcr:data, 'myData')

 

However the result set is always empty. If I rewrite the query to:

 

SELECT * FROM nt:base WHERE contains(., 'myData')

 

my files will be found.

 

My question is:

 

Does Jackrabbit support using the CONTAINS function only for several
attributes like jcr:data or is it only possible to search all indexed
properties? Or do I misunderstand something?

 

Kind regards

 

Sascha Theves
Platform and Technology (INST/EPI)

--
Innovations Software Technology
Bosch Group
Ziegelei 7, 88090 Immenstaad, Germany
Telefon: +49(0)7545-202-537
Fax:       +49(0)7545-202-301
sascha.theves@innovations.de
<BL...@innovations.de>  
www.innovations.de <http://www.innovations.de/> 

Executives: Achim Berger, Thomas Cotic, Thomas Schmid
Register Court Ulm HRB 631888

This message may contain confidential and privileged information. Any
unauthorized review, use, disclosure or distribution is prohibited. If
you are not the intended recipient, please inform us immediately and
destroy this message including all copies thereof.

 


Re: SQL CONTAINS function

Posted by Ard Schrijvers <a....@onehippo.com>.
On Wed, Oct 6, 2010 at 10:12 AM,  <Sa...@innovations.de> wrote:
> Hi all,
>
>
>
> I am using Jackrabbit 1.6.2 and have problems with a SQL statement using
> the "CONTAINS" function. I want to perform a fulltext search on the
> binary content of my files stored in jackrabbit. The files have a
> primary node type of nt:file and the jcr:content child node is of type
> nt:resource. The content of the file is indexed. Now I want to perform a
> fulltext search with the following statement:
>
>
>
> SELECT * FROM nt:base WHERE contains(jcr:data, 'myData')

jcr:data is not indexed as a separate property but only on nodescope
level. Also see [1] where it was discussed lately,

Regards Ard

[1] http://jackrabbit.510166.n4.nabble.com/jcr-data-query-question-td518136.html

>
>
>
> However the result set is always empty. If I rewrite the query to:
>
>
>
> SELECT * FROM nt:base WHERE contains(., 'myData')
>
>
>
> my files will be found.
>
>
>
> My question is:
>
>
>
> Does Jackrabbit support using the CONTAINS function only for several
> attributes like jcr:data or is it only possible to search all indexed
> properties? Or do I misunderstand something?
>
>
>
> Kind regards
>
>
>
> Sascha Theves
> Platform and Technology (INST/EPI)
>
> --
> Innovations Software Technology
> Bosch Group
> Ziegelei 7, 88090 Immenstaad, Germany
> Telefon: +49(0)7545-202-537
> Fax:       +49(0)7545-202-301
> sascha.theves@innovations.de
> <BL...@innovations.de>
> www.innovations.de <http://www.innovations.de/>
>
> Executives: Achim Berger, Thomas Cotic, Thomas Schmid
> Register Court Ulm HRB 631888
>
> This message may contain confidential and privileged information. Any
> unauthorized review, use, disclosure or distribution is prohibited. If
> you are not the intended recipient, please inform us immediately and
> destroy this message including all copies thereof.
>
>
>
>



-- 
Hippo
Europe  •  Amsterdam  Oosteinde 11  •  1017 WT Amsterdam  •  +31 (0)20 522 4466
USA  • San Francisco  185 H Street Suite B  •  Petaluma CA 94952-5100
•  +1 (707) 773 4646
Canada    •   Montréal  5369 Boulevard St-Laurent  •  Montréal QC H2T
1S5  •  +1 (514) 316 8966
www.onehippo.com  •  www.onehippo.org  •  info@onehippo.com