Re: DIH nested entities don't work

[mroosendaal]

None taken:-)

Here's the info

OS: Linux
Java: 1.6
Oracle driver: ojdbc14.jar

*view structure:*
END_FRG_PRODUCTS_VW
        pdt_id
        pdt_title
        stock_availability
        pdt_pce_bolprice
        gpc_id
        offer_type
        search_rank
        search_title
        
END_FRG_FEATURES_VW
        pdt_id
        pdt_features

END_FRG_SONGS_VW
        pdt_id
        songtitle
        te_beluisteren
        
there are # products
        some have 1 or more features
        some have 1 or more songs

*data-config.xml:*
<dataConfig>
<dataSource name=&quot;jdbc&quot;
driver=&quot;oracle.jdbc.driver.OracleDriver&quot;
url=&quot;jdbc:oracle:thin:@//&lt;host>:1521/ENDDEV" user="<un>"
password="pw"/>
    <document name="products">
        <entity name="item" query="select * from END_FRG_PRODUCTS_VW">
                <entity name="features" query="select * from 
END_FRG_FEATURES_VW where
PDT_ID='${item.PDT_ID}'"  processor="SqlEntityProcessor"
cacheImpl="SortedMapBackedCache" />
                <entity name="songtitel" query="select * from END_FRG_SONGS_VW 
where
PDT_ID='${item.PDT_ID}'"  processor="SqlEntityProcessor"
cacheImpl="SortedMapBackedCache" />
        </entity>
    </document>
</dataConfig>

*schema.xml*
http://pastebin.com/TtSQuhCX

*what i;ve tried*
* importing only the products --> worked
* importing only the songs (as the root entity) --> worked
* importing products and songs (as a subentity) --> every product gets the
same songtitle but no 'te_beluisteren'-field
* importing products with features and songs --> same as previous.

Hope you can point me in the right direction.

Thanks,
Maarten



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