[DIH] deltaQuery has no column to resolve to declared primary key pk='id'

[Hangu Choi <de...@gmail.com>]

Hi,
I stuck in DIH...

full import is fine.
and delta import was also fine before I add deltaQuery and parentDeltaQuery
in 'auth' entity.

thank you for any help..




<dataConfig>
    <dataSource driver="org.mariadb.jdbc.Driver"

url="jdbc:mysql://localhost:3306/mydb?allowMultiQueries=true"
                user="sa"
                password="" />
    <document>
        <entity name="article" PK="article_id"
                query="select article_id, revision_id, title, content,
utc_rev_datetime from article_revision a1 where revision_id in  (select
max(revision_id) from article_revision a2 where a1.article_id =
a2.article_id)"
                deltaImportQuery="select article_id, revision_id, title,
content, utc_rev_datetime from article_revision a1 where revision_id in
 (select max(revision_id) from article_revision a2 where a1.article_id =
a2.article_id) and article_id=${dataimporter.delta.article_id}"
                deltaQuery="select article_id from article_revision a1
where revision_id in  (select max(revision_id) from article_revision a2
where a1.article_id = a2.article_id) and a1.utc_rev_datetime >
'${dataimporter.last_index_time}'">
           <field column="article_id" name="id" />
           <field column="title" name="title" />
           <field column="utc_rev_datetime" name="utc_rev_datetime" />
           <field column="content" name="content" />
           <entity name="auth" PK="auth_id"
                        query="select * from article_authority where
article_id ='${article.article_id}'"
                        deltaQuery="select article_id from
article_authority where utc_last_managed_datetime >
'${dataimporter.last_index_time}'"
                        parentDeltaQuery="select article_id from
article_revision a1 where revision_id in  (select max(revision_id) from
article_revision a2 where a1.article_id = a2.article_id) and
a1.article_id=${auth.article_id}" >
                <field name="auth_id" column="auth_id" />
                <field name="read_auth_level" column="read_auth_level" />
                <field name="manager_id" column="manager_id" />
                <field name="utc_last_managed_datetime"
column="utc_last_managed_datetime" />
           </entity>
        </entity>
    </document>
</dataConfig>





Regards,
Hangu