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
&gt; '${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

Reply via email to