[
https://issues.apache.org/jira/browse/SOLR-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13760957#comment-13760957
]
Shalin Shekhar Mangar commented on SOLR-5217:
---------------------------------------------
I'm trying to understand the bug here.
I assume that you are trying to use CachedSqlEntityProcessor as in example 1 in
http://wiki.apache.org/solr/DataImportHandler#CachedSqlEntityProcessor
For example:
{code}
<entity name="x" query="select * from x">
<entity name="y" query="select * from y where xid=${x.id}"
processor="CachedSqlEntityProcessor">
</entity>
<entity>
{code}
Except that, instead of a SQL query, you are using parameterized stored
procedures. In such a case, when a query is run the results are stored and if
the same query is run again, it is fetched from the cache and returned. Are you
seeing a different behaviour?
> 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]
