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:aklimets@day.com] 
Gesendet: Samstag, 3. Juli 2010 00:17
An: users@jackrabbit.apache.org; friedhelm.matten@iscad-it.de
Betreff: Re: fulltext search sql excerpt sql2 jackrabbit 2.1.0

On Fri, Jul 2, 2010 at 17:10, Friedhelm Matten
<friedhelm.matten@iscad-it.de> 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
alexander.klimetschek@day.com