RE: DIH nested entities don't work

[mroosendaal]

Thanks, i'll give that a try tomorrow. Here's the data-config.xml which i
will try when i get to work tomorrow:

<dataConfig>
        <dataSource name=&quot;jdbc1&quot;
driver=&quot;oracle.jdbc.driver.OracleDriver&quot;
url=&quot;jdbc:oracle:thin:@//&lt;host>:1521/ENDDEV" user="un"
password="pw"/>
        <document>
                <entity name="END_FRG_PRODUCTS_VW" 
                        processor="SqlEntityProcessor"
                        dataSource="jdbc1"
                        query="select PDT_ID, SEARCH_TITLE from
END_FRG_PRODUCTS_VW">
                        <entity name="END_FRG_FEATURES_VW"
                                processor="SqlEntityProcessor"
                                
cacheImpl="org.apache.solr.handler.dataimport.BerkleyBackedCache"
                                persistCacheName="FEATURE" 
                                persistCacheBaseDir="d:\cacheloc"
                                berkleyInternalCacheSize="1000000"
                                persistCacheFieldNames="PDT_ID,PDT_FEATURES"
                                persistCacheFieldTypes="STRING,STRING"
                                berkleyInternalShared="true"
                                cacheKey="PDT_ID"
                                cacheLookup="END_FRG_PRODUCTS_VW.PDT_ID"
                                dataSource="jdbc1"
                                query="select PDT_ID, PDT_FEATURES from
END_FRG_FEATURES_VW"/>
                        <entity name="END_FRG_TAGS_VW"
                                processor="SqlEntityProcessor"
                                
cacheImpl="org.apache.solr.handler.dataimport.BerkleyBackedCache"
                                persistCacheName="TAGS" 
                                persistCacheBaseDir="d:\cacheloc"
                                berkleyInternalCacheSize="1000000"
                                persistCacheFieldNames="PDT_ID,TAGS"
                                persistCacheFieldTypes="STRING,STRING"
                                berkleyInternalShared="true"
                                cacheKey="PDT_ID"
                                cacheLookup="END_FRG_PRODUCTS_VW.PDT_ID"
                                dataSource="jdbc1"
                                query="select PDT_ID, TAGS from 
END_FRG_TAGS_VW"/>
                        <entity name="END_FRG_CATEGORIES_VW"
                                processor="SqlEntityProcessor"
                                
cacheImpl="org.apache.solr.handler.dataimport.BerkleyBackedCache"
                                persistCacheName="CATEGORIES" 
                                persistCacheBaseDir="d:\cacheloc"
                                berkleyInternalCacheSize="1000000"
                                
persistCacheFieldNames="PDT_ID,CGY_CODE,WHEN_NO_CGY"
                                persistCacheFieldTypes="STRING,STRING,STRING"
                                berkleyInternalShared="true"
                                cacheKey="PDT_ID"
                                cacheLookup="END_FRG_PRODUCTS_VW.PDT_ID"
                                dataSource="jdbc1"
                                query="select PDT_ID, CGY_CODE, WHEN_NO_CGY from
END_FRG_CATEGORIES_VW"/>
                </entity>
        </document>
</dataConfig>

the views are specific for the indexing process so each view (11) contains
all the information we want, thus the ' SELECT *'. I see in the logging that
Solr infers the correct type.

Thanks,
Maarten



--
View this message in context: 
http://lucene.472066.n3.nabble.com/DIH-nested-entities-don-t-work-tp4015514p4019822.html
Sent from the Solr - User mailing list archive at Nabble.com.