You are viewing a plain text version of this content. The canonical link for it is here.
Posted to solr-user@lucene.apache.org by mi...@basf.com on 2012/04/06 20:13:57 UTC

SolrEntityProcessor Configuration Problem

Dear all,
I'm facing a problem with SolrEntityProcessor, when having it configured 
under a JDBC Datasource.
My configuration looks like this:

<entity name="V_MARKET_STUDIES"  datasource="jdbc-2" query="select * from 
V_MARKET_STUDIES" transformer="ClobTransformer">

                        <field column="ID" name="id" />
                        <field column="TYPE" name="type" />
                        <field column="LOCALE" name="locale" />

                        <field column="TITLE" name="title" />

                        <field column="KEYWORDS" name="keywords"  
clob="true"/>
                        <field column="TOPICS" name="topics"/>
                        <field column="EXTENDED_KEYWORDS" 
name="extended_keywords"                clob="true"/>
                        <field column="PUBLICATION_DATE" 
name="publication_date"/>
 
                        <field column="OWNER" name="owner" />

                        <field column="DL_FILE_ENTRY_ID" 
name="dl_file_entry_id" />
                        <field column="DL_FILE_VERSION_ID" 
name="dl_file_version_id" />
                        <field column="DL_FOLDER_ID" name="dl_folder_id" 
/>
                        <field column="FILE_NAME" name="file_name" />
                        <field column="EXTENSION" name="extension" />
                        <field column="URL_LINK" name="urllink" />


                <entity name="sep"   processor="SolrEntityProcessor"
                 fl="content" url="http://vmcenter120:8983/solr/" 
query="folderId:${V_MARKET_STUDIES.DL_FOLDER_ID}" 
fq="entryClassPK:${V_MARKET_STUDIES.DL_FILE_ENTRY_ID}">
                <field column="content" name="content" />
 
                </entity>
        </entity>

I have 6 rows in the Oracle Database, but only the first row is processed 
right, means that the 2nd Solr is queried
and the results went to the document, the remaining 5 rows where processed 
without quering the 2nd Solr and therfore
didn't have the content field filled.

Any suggestions?
Did I configured something wrong, or misunderstand something wrong?
Thanks for your help


Best regards
Michael

Re: SolrEntityProcessor Configuration Problem

Posted by Lance Norskog <go...@gmail.com>.
The SolrEntityProcessor resolves all of its parameters at start time,
not for each query. This technique cannot work. I filed it:

https://issues.apache.org/jira/browse/SOLR-3336

On Fri, Apr 6, 2012 at 11:13 AM,  <mi...@basf.com> wrote:
> Dear all,
> I'm facing a problem with SolrEntityProcessor, when having it configured
> under a JDBC Datasource.
> My configuration looks like this:
>
> <entity name="V_MARKET_STUDIES"  datasource="jdbc-2" query="select * from
> V_MARKET_STUDIES" transformer="ClobTransformer">
>
>                        <field column="ID" name="id" />
>                        <field column="TYPE" name="type" />
>                        <field column="LOCALE" name="locale" />
>
>                        <field column="TITLE" name="title" />
>
>                        <field column="KEYWORDS" name="keywords"
> clob="true"/>
>                        <field column="TOPICS" name="topics"/>
>                        <field column="EXTENDED_KEYWORDS"
> name="extended_keywords"                clob="true"/>
>                        <field column="PUBLICATION_DATE"
> name="publication_date"/>
>
>                        <field column="OWNER" name="owner" />
>
>                        <field column="DL_FILE_ENTRY_ID"
> name="dl_file_entry_id" />
>                        <field column="DL_FILE_VERSION_ID"
> name="dl_file_version_id" />
>                        <field column="DL_FOLDER_ID" name="dl_folder_id"
> />
>                        <field column="FILE_NAME" name="file_name" />
>                        <field column="EXTENSION" name="extension" />
>                        <field column="URL_LINK" name="urllink" />
>
>
>                <entity name="sep"   processor="SolrEntityProcessor"
>                 fl="content" url="http://vmcenter120:8983/solr/"
> query="folderId:${V_MARKET_STUDIES.DL_FOLDER_ID}"
> fq="entryClassPK:${V_MARKET_STUDIES.DL_FILE_ENTRY_ID}">
>                <field column="content" name="content" />
>
>                </entity>
>        </entity>
>
> I have 6 rows in the Oracle Database, but only the first row is processed
> right, means that the 2nd Solr is queried
> and the results went to the document, the remaining 5 rows where processed
> without quering the 2nd Solr and therfore
> didn't have the content field filled.
>
> Any suggestions?
> Did I configured something wrong, or misunderstand something wrong?
> Thanks for your help
>
>
> Best regards
> Michael



-- 
Lance Norskog
goksron@gmail.com