[
https://issues.apache.org/jira/browse/SOLR-5217?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13763038#comment-13763038
]
Solr Node edited comment on SOLR-5217 at 3/19/15 7:39 AM:
----------------------------------------------------------
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"
was (Author: hupadhyay):
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>
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: [email protected]
For additional commands, e-mail: [email protected]
