lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tjpoe <tanner.post...@gmail.com>
Subject Re: Variable datasources
Date Fri, 14 Jan 2011 18:18:30 GMT

I was actually able to figure this out using a slightly different method

since the databases exist on the same server I simply made a single
datasource with no database selected:

<datasource url="jdbc:mysql://localhost/" name="content" /> 

then in the queries, I qualify using the full database notation:
database.table rather than just table

<document name="items"> 
 <entity datasource="content" name="local" query="select code from
master.locals"  rootEntity="false"> 
  <entity datasource="content" name="item" query=" select *,  ${local.code}
as code from content_${local.code}.item" /> 
  </entity> 
</document> 

it works as expected
-- 
View this message in context: http://lucene.472066.n3.nabble.com/Variable-datasources-tp2249568p2257334.html
Sent from the Solr - User mailing list archive at Nabble.com.

Mime
View raw message