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 [email protected] <BLOCKED::mailto:[email protected]> 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.
