multiple data source indexing through data import handler

2015-01-23 Thread Qiu Mo
I am indexing data from two different databases, but I can't add second 
database to indexing, can anyone help!  below is my dats-config.xml
























my log indicate that '${item.ID}' is not catch any value from entity item.

Thanks,

Joe Moore


Re: multiple data source indexing through data import handler

2015-01-23 Thread Qiu Mo

Alex,

Thanks,  I tried ${item.id},  it doesn’t work. 
However, if hardcode a id number instead of  '${item.id}’ , the it add this one 
line to every document.

for example 
select description from feature where item_id=3456

then this single description is added to every document as a field. it seems 
the parent entity item.id is
not passed to the second entity.

Thanks,

Qiu Mo (Joe)



From: Alexandre Rafalovitch 
Sent: Friday, January 23, 2015 3:25 PM
To: solr-user
Subject: Re: multiple data source indexing through data import handler

Try ${item.id} as that's what you are mapping it to.

See also: https://issues.apache.org/jira/browse/SOLR-4383

Regards,
   Alex.

Sign up for my Solr resources newsletter at http://www.solr-start.com/


On 23 January 2015 at 15:01, Qiu Mo  wrote:
> I am indexing data from two different databases, but I can't add second 
> database to indexing, can anyone help!  below is my dats-config.xml
>
>
>  url="jdbc:mysql://XXX" user="XXX" password="XXX"/>
>
>  url="jdbc:mysql://XXX" user="XXX" password="XXX"/>
>
>
> 
>
> 
>
> 
>
>
> 
>
> 
>
> 
>
>
>
> 
>
> my log indicate that '${item.ID}' is not catch any value from entity item.
>
> Thanks,
>
> Joe Moore