lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From tjpoe <>
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" /> 

it works as expected
View this message in context:
Sent from the Solr - User mailing list archive at

View raw message