Here is my DIH config: <dataConfig> <dataSource name="ds1" type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost1/dbname1" user="db_username1" password="db_password1"/> <dataSource name="ds2" type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="jdbc:mysql://localhost2/dbname2" user="db_username2" password="db_password2"/> <document name="products"> <entity name="item" dataSource="ds1" query="select * from item"> <field column="ID" name="id" /> <field column="NAME" name="name" />
<entity name="feature" dataSource="ds2" query="select description from feature where item_id='${item.ID}'"> <field name="features" column="description" /> </entity> </entity> </document> </dataConfig> I am having trouble with delta import. I think it is because the main entity and the sub-entity use different data source. I have tried using both a delta query: deltaQuery="select id from item where id in (select item_id as id from feature where last_modified > '${dih.last_index_time}') or last_modified > '${dih.last_index_time}'" and a parentDeltaQuery: <entity name="feature" pk="ITEM_ID" query="select DESCRIPTION as features from FEATURE where ITEM_ID='${item.ID}'" deltaQuery="select ITEM_ID from FEATURE where last_modified > '${dih.last_index_time}'" parentDeltaQuery="select ID from item where ID=${feature.ITEM_ID}"/> I ended up with an SQL error for both. Is there any way to make delta import work in my case? Bill