I have several similar databases that I'd like to import from 14 to be exact.
there is also a 15th database where I can get a listing of the 14 database.
I'm trying to do a variable datasource such as:
<datasource url="jdbc:mysql://localhost/${local.code}" name="content" />
<datasource url="jdbc:mysql://localhost/master" name="master" />
then my import query looks like this
<document name="items">
<entity datasource="master" name="local" query="select code from locals"
rootEntity="false">
<entity datasource="content" name="item" query=" select *, ${local.code}
as code from item" />
</entity>
</document>
The above configuration works, but the ${local.code} variable is ONLY
resolved the first time so it looks throught the correct # of times, and I
can see {$local.code} being resolved in each of the item queries, but the
data source never changes.
I also tried creating datasources for each local and then using a variable
datasource in the entity such as:
<datasource url="jdbc:mysql://localhost/aaa" name="content_aaa" />
<datasource url="jdbc:mysql://localhost/bbb" name="content_bbb" />
<datasource url="jdbc:mysql://localhost/ccc" name="content_ccc" />
<datasource url="jdbc:mysql://localhost/master" name="master" />
and then the document as:
<document name="items">
<entity datasource="master" name="local" query="select code from locals"
rootEntity="false">
<entity datasource="content_${local.code}" name="item" query=" select *,
${local.code} as code from item" />
</entity>
</document>
but the ${local.code} variable is not resolved and it attempts to connect to
the literal source content_${local.code}.
any ideas how I can get all of the items imported for all of the locals at
once?
--
View this message in context:
http://lucene.472066.n3.nabble.com/Variable-datasources-tp2249568p2249568.html
Sent from the Solr - User mailing list archive at Nabble.com.
