On Tue, Jan 10, 2012 at 7:09 AM, Mike O'Leary <tmole...@uw.edu> wrote:
[...]
> My data-config.xml file looks like this:
>
> <dataConfig>
> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://localhost:3306/bioscope" user="db_user"
> password=""/>
> <document name="bioscope">
> <entity name="docs" pk="doc_id" query="SELECT doc_id, type FROM
> bioscope.docs"
> deltaQuery="SELECT doc_id FROM bioscope.docs where last_modified >
> '${dataimporter.last_index_time}'">
> <field column="doc_id" name="DOC_ID"/>
> <field column="type" name="DOC_TYPE"/>
Your SELECT above does not include the field "type"
> <entity name="codes" pk="id" query="SELECT id, origin, type, code FROM
> bioscope.codes WHERE doc_id='${docs.doc_id}'"
^^^^^^ This should be: WHERE id=='${docs.doc_id}' as 'id' is what
you are selecting in this entity.
Same issue for the second nested entity, i.e., replace doc_id= with id=
Regards,
Gora
