[ 
http://jira.nuxeo.org/browse/NXP-4035?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=59679#action_59679
 ] 

Florent Guillaume commented on NXP-4035:
----------------------------------------

Note that in the example, MY_LEXER is a lexer "preference" that has to be 
created in the tablespace used by the Nuxeo database, and this can only be done 
by a DBA user.

So for instance you can temporarily give DBA rights to the Nuxeo database user, 
execute something like:
BEGIN 
    CTXSYS.CTX_DDL.CREATE_PREFERENCE ('MY_LEXER', 'BASIC_LEXER');" 
    CTXSYS.CTX_DDL.SET_ATTRIBUTE ('MY_LEXER', 'base_letter', 'YES');" 
    CTXSYS.CTX_DDL.SET_ATTRIBUTE ('MY_LEXER', 'index_stems', 'FRENCH');" 
    CTXSYS.CTX_DDL.CREATE_PREFERENCE('MY_WORLIST', 'BASIC_WORDLIST'); 
    CTXSYS.CTX_DDL.SET_ATTRIBUTE('MY_WORLIST', 'stemmer', 'FRENCH');
    CTXSYS.CTX_DDL.SET_ATTRIBUTE('MY_WORLIST', 'substring_index', 'NO');
    CTXSYS.CTX_DDL.SET_ATTRIBUTE('MY_WORLIST', 'prefix_index', 'NO');
END;
then remove the DBA right.

You can then use  <fulltext analyzer="LEXER MY_LEXER WORDLIST MY_WORDLIST"/> 

> VCS: make Oracle fulltext lexer configurable
> --------------------------------------------
>
>                 Key: NXP-4035
>                 URL: http://jira.nuxeo.org/browse/NXP-4035
>             Project: Nuxeo Enterprise Platform
>          Issue Type: Improvement
>          Components: Core SQL Storage
>    Affects Versions: 5.2 GA
>            Reporter: Florent Guillaume
>            Assignee: Florent Guillaume
>             Fix For: 5.2.1
>
>
> Make Oracle lexer configurable for fulltext.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets

Reply via email to