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.
