Re: How to debug DIH with MySQL?

[dan whelan]

just a guess but this might need to change from

${biblio.id}

to

${book.id}

Since the entity name is book instead of biblio



On 1/10/12 10:37 AM, Walter Underwood wrote:

I see a missing required "title" field for every document when I'm using DIH. 
Yes, these documents have titles in the database. Is there a way to see what exact 
queries are sent to MySQL or received by MySQL?

Here is a relevant chunk of the dataConfig:

     <entity name="book" query="select * from biblio where id&lt; 10000">
       <field name="id" column="id" />
       <field name="isbn" column="isbn" />
       <field name="isbn" column="ean" />

       <entity name="biblio_title"
              query="select title from biblio_title where 
biblio_id='${biblio.id}'">
        <field name="title" column="title" />
       </entity>

wunder
--
Walter Underwood
wun...@wunderwood.org
Search Guy, Chegg