On 24 October 2012 10:30, mroosendaal <mroosend...@yahoo.com> wrote:
>
> Hi,
>
> We have several oracle views which contain the result of an ETL process. I
> want to index information from those views and have the following
> data-config.xml
>
> <dataSource name="jdbc"
> driver="oracle.jdbc.driver.OracleDriver"
> url="jdbc:oracle:thin:@//<host>:1521/<db> user="a" password="a"/>
> <document name="products">
> <entity name="item" query="select * from products_vw">
> <entity name="description" query="select * from
> DESCRIPTIONS_VW where
> pdt_id='${item.pdt_id}'" />
> <entity name="songtitel" query="select * from SONGS_VW where
> pdt_id='{item.pdt_id}'" />
> ....
> ....
> </entity>
> ...
>
> products can be everything and sometimes are musicproducts.
>
> it works up to the point where the 'item'/product is indexed but the rest is
> not. The only strange thing i see is that (almost) every product is indexed
> with one and the same songtitle for some reason.
What does the DIH summary say after the import is complete?
Could you share your schema.xml? Are the proper fields defined
there? Have you tried the various SELECTs manually?
For the second issue with the entity "songtitel" it might be because you are
missing a '$'. You have {item.pdt_id} instead of ${item.pdt_id}
Regards,
Gora
