lucene-dev mailing list archives

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


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]
         <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" />


> CachedSqlEntity fails with stored procedure
> -------------------------------------------
>                 Key: SOLR-5217
>                 URL:
>             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:

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message