You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Hardik Upadhyay (JIRA)" <ji...@apache.org> on 2013/09/07 08:01:54 UTC
[jira] [Comment Edited] (SOLR-5217) CachedSqlEntity fails with
stored procedure
[ https://issues.apache.org/jira/browse/SOLR-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13760932#comment-13760932 ]
Hardik Upadhyay edited comment on SOLR-5217 at 9/7/13 6:01 AM:
---------------------------------------------------------------
Actual use cases of nested entities are relevant to their parent entity only. if parent entity changes so do nested entity values too.off course in few use cases nested entity values may also remain same. But CachedSqlEntityProcessor should and if i am not wrong caches where conditions from queries.Same should be the case with stored procedures , as input parameters changes it should cache result set for each new parameters too.Then only CachedSqlEntityProcessor can serve its purpose.
was (Author: hupadhyay):
Actual use cases of nested entities are relevant to there parent entity only. if parent entity changes so do nested entity values too.off course in few use cases nested entity values may also remain same. But CachedSqlEntityProcessor should and if i am not wrong caches where conditions from queries.Same should be the case with stored procedures , as input parameters changes it should cache result set for each new parameters too.Then only CachedSqlEntityProcessor can serve its purpose.
> 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org