> I'm trying to use DataImportHandler
> to load my index and having some strange
> results. I have two tables in my database. DPRODUC contains
> products and
> FSKUMAS contains the skus related to each product.
>
> This is the data-config I'm using.
>
> <dataConfig>
> <dataSource type="JdbcDataSource"
>
> driver="com.ibm.as400.access.AS400JDBCDriver"
>
> url="jdbc:as400:IWAVE;prompt=false;naming=system"
>
> user="IPGUI"
>
> password="IPGUI"/>
> <document>
> <entity name="dproduc"
> query="select dprprd, dprdes from
> dproduc where dprprd like 'F%'">
> <field column="dprprd" name="id"
> />
> <field column="dprdes" name="name"
> />
> <entity name="fskumas"
> query="select fsksku, fcoclr,
> fszsiz, fskret
> from fskumas where
> dprprd='${dproduc.DPRPRD}'">
> <field
> column="fsksku" name="sku" />
> <field
> column="fcoclr" name="color" />
> <field
> column="fszsiz" name="size" />
> <field
> column="fskret" name="price" />
> </entity>
> </entity>
> </document>
> </dataConfig>
What is the primary key of dproduc table? If it is dprprd can you try adding
pk="dprprd" to <entity name="dproduc"?
<entity name="dproduc" pk="dprprd" query="select dprprd, dprdes from dproduc
where dprprd like 'F%'">
