lucene-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hardik Upadhyay (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SOLR-5217) CachedSqlEntity fails with stored procedure
Date Tue, 10 Sep 2013 13:29:51 GMT

    [ 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: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org


Mime
View raw message