Thanks, the xpath query will do it, but I can't work with joins.
I need joins, or I must write several queries which collect the different data and must than match all. This will be a problem. Regards, Friedhelm -----Ursprüngliche Nachricht----- Von: Alexander Klimetschek [mailto:[email protected]] Gesendet: Samstag, 3. Juli 2010 00:17 An: [email protected]; [email protected] Betreff: Re: fulltext search sql excerpt sql2 jackrabbit 2.1.0 On Fri, Jul 2, 2010 at 17:10, Friedhelm Matten <[email protected]> wrote: > Hi, > > I would like to change from jackrabbit 1.6.2 to jackrabbit 2.1.0 > > and test following full text search > > select * from [nt:resource] AS resource where contains(resource.*, > '%DocumentText%') > > for Dokuments word, pdf,. . > > With > > RowIterator ri = qr.getRows(); > > while (ri.hasNext()) { > > Row row = ri.nextRow(); > > // row.getValue("rep:excerpt(jcr:data)").getString(); > > double score = row.getScore(); > > logger.info("--->>>score: " + score); > > Value excerpt = row.getValue("rep:excerpt(jcr:data)"); > > logger.info("--->>>: " + excerpt); > > } > > > There a result rows but excerpt is null. Hmm, might be a bug in JCR-SQL2. Otherwise you can continue to use your old query with JCR-SQL. It is deprecated in the JCR 2.0 spec, but Jackrabbit will still continue to support both jcr-sql and xpath from the 1.0 specification. Regards, Alex -- Alexander Klimetschek [email protected]
