I have the data-config.xml detailed below  (Stripped down a bit for
simplicity) -
When I run the delta import, the design_template delta query is running and
modified rows are being returned.  However, the parentDeltaQuery is never
executed.

Any thoughts?

Thanks,

Micahael


<dataConfig>
<dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver" url="URL"
user="USER" password="PASSWORD"/>
 <document name="catalog_item_doc">
<entity name="catalog_item" transformer="script:catalog_item"
pk="catalog_item_id"
 query="select catalog_item_id,catalog_item_code  from catalog_item"
deltaQuery="select catalog_item_id from catalog_item where date_updated >
'${dataimporter.last_index_time}'"
 deletedPkQuery="select catalog_item_id from catalog_item_delete where
date_deleted > '${dataimporter.last_index_time}'"
>

 <field column="catalog_item_code" name="catalog_item_code" />

 <entity name="design_template"  transformer="script:stone_type"
id="design_template_id" pk="design_template_id"
  query="select name from design_template where
design_template_id='${catalog_item.design_template_id_fk}'"
 deltaQuery="select design_template_id from design_template where
date_updated > '${dataimporter.last_index_time}'"
parentDeltaQuery="select catalog_item_id from catalog_item where
design_template_id_fk = '${design_template.design_template_id}'"
 >
   <field column="name" name="name" />
   </entity>

</entity>
 </document>
</dataConfig>

Reply via email to