Hi Mike,
Can you try removing ' <field column="doc_id" name="DOC_ID" /> from the
nested entities? Just keep it in the top level entity.
Regards,
Rakesh Varna
On Wed, Jan 11, 2012 at 7:26 AM, Gora Mohanty <g...@mimirtech.com> wrote:
> 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
>
