Hello,
we are on Jackrabbit 2.4.2 and still use the deprecated XPATH for the
fulltext search over the whole site. We wanted to change this to use
SQL-2, but found that the SQL-2 implementation is still missing the
excerpt/highlighting and the spellchecker support, which is available in
SQL and XPATH. Did someone already succeed in having that features for
SQL-2 with some custom development ?
Even if these features are not part of the JCR 2.0 spec for SQL-2,
wouldn't it be useful to have them available also for the SQL-2 engine
in Jackrabbit ? If it is useful for Jackrabbit we may decide to work on
a patch for that.
Would it be ok to keep the same syntax for it as with SQL (select
excerpt(.) ... respectively select rep:spellcheck() ... ) and then to use:
row.getValue("rep:excerpt(.)")
respectively
row.getValue("rep:spellcheck()");
Besides the problem that SQL-2 now allows for joins are there any other
obstacles to implement this feature for SQL-2 ?
Regards,
Benjamin
