lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From stockii <st...@shopgate.com>
Subject Multiple DataSources- 2 tables - 2 db's- Where ... ?!
Date Mon, 26 Apr 2010 13:45:40 GMT

Hello...

i got a new problem. we put out item's table into antother database and now
i need to use multiple datascource but without successed =(

so.. here my data-config-xml in short ;)

<dataSource name="shops" type="JdbcDataSource" ... />
<entity name="active" pk="id" dataSource="shops"
 query="select id FROM shops WHERE is_active=1" /> 

<dataSource name="items" type="JdbcDataSource"  ... />
<entity name="item" pk="id" dataSource="items"
processor="org.apache.solr.handler.dataimport.CachedSqlEntityProcessor"
     query="select i.id, i.shop_id, i.name,
     from shop_items as i WHERE i.shop_id='{shops.active.id}'"  .... some
delta imports ... and categroy mappings.

so, i want only to index these items where is_active=1 in the table shops.
how can i perform this ? 

thhhxxx =)

-- 
View this message in context: http://lucene.472066.n3.nabble.com/Multiple-DataSources-2-tables-2-db-s-Where-tp756683p756683.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message