[
https://issues.apache.org/jira/browse/SOLR-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13763038#comment-13763038
]
Hardik Upadhyay commented on SOLR-5217:
---------------------------------------
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="[getAllRevDetPlatWideSearch] '1','-1'">
<entity name="folderadmin_list" processor="CachedSqlEntityProcessor"
dataSource="JDBC" query="select * from FoldersAdminList" cacheKey="user_id"
cacheLookup="folder_id=document.folder_id and project_id=document.project_id">
<field name="folderadmin_list" column="user_id" />
</entity>
</entity>
> 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: Hardik Upadhyay
> Attachments: db-data-config.xml
>
>
> 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 is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
