-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Alexander Klimetschek wrote: > http://www.h2database.com/jcr/grammar.html > http://svn.apache.org/viewvc/jackrabbit/trunk/jackrabbit-spi-commons/src/test/resources/org/apache/jackrabbit/spi/commons/query/sql2/test.sql2.txt?view=markup >
Thx Alex, that helped. But I still have problems doing the search that I wanted to do. I've set up the Jackrabbit webapp and used the "Populate" page to load some documents into the repository. Now I want to do a full text search query. I've tried the following: SELECT * FROM [nt:file] AS file WHERE contains(file.*,'text') but this gives no results. Another query I've tried, as the nt:file node type definition states that the actual content of the files is stored in nt:resource nodes, is SELECT * FROM [nt:resource] but that results in a exception javax.jcr.RepositoryException: ':' not allowed in name whereas the same query using nt:file works fine. Can anyone say what's wrong and how to do a full text search with JCR-SQL2 ? - -- Linkwerk - Software und Beratung für vernetzte Information Telefon: +49 40 69 66 48 14 Web: www.linkwerk.com Linkwerk GmbH, Oberaltenallee 20a, 22081 Hamburg, Handelsregister Hamburg, HRB 95084 Geschäftsführer: Stefan Mintert -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAktezEAACgkQSm4S1ty9BPVc/QCg11ce7JqfGgGqt5mevgffZeLe 5yIAmwRpySC76qdS/y5LPEKbBg5ypL++ =wPBr -----END PGP SIGNATURE-----
