[jira] [Issue Comment Deleted] (SOLR-5217) CachedSqlEntity fails with stored procedure

["Solr Node (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/SOLR-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Solr Node updated SOLR-5217:
----------------------------
    Comment: was deleted

(was: I have just changed my db-data-config.xml and replaced stored procedure call with SQL query,but still it seems to be not working.Bellow is my updated config

<entity name="document" transformer="ClobTransformer"  dataSource="JDBC" query="[xxxxxSearch] '1','-1'">
         <entity name="folderadmin_list" processor="CachedSqlEntityProcessor" dataSource="JDBC" query="select * from xxxList"    cacheKey="user_id" cacheLookup="folder_id=document.folder_id and project_id=document.project_id">
                <field name="folderadmin_list" column="user_id" />
            </entity>  

</entity>

The error says  "The cache lookup value : folder_id=document.folder_id is resolved to be null in the entity :folderadmin_list")

> CachedSqlEntity fails with stored procedure
> -------------------------------------------
>
>                 Key: SOLR-5217
>                 URL: https://issues.apache.org/jira/browse/SOLR-5217
>             Project: Solr
>          Issue Type: Bug
>          Components: contrib - DataImportHandler
>            Reporter: Solr Node
>
> When using DIH with CachedSqlEntityProcessor and importing data from MS-sql using stored procedures, it imports data for nested entities only once and then every call with different arguments for nested entities are only served from cache.My db-data-config is attached.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org