jackrabbit-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Klimetschek <aklim...@day.com>
Subject Re: fulltext search sql excerpt sql2 jackrabbit 2.1.0
Date Fri, 02 Jul 2010 22:16:40 GMT
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

Mime
View raw message