Re: Variable datasources

2011-01-14 Thread tjpoe

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:

 

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

 
  
   
   
 

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.


Re: Variable datasources

2011-01-13 Thread Gora Mohanty
On Fri, Jan 14, 2011 at 1:02 AM, tjpoe  wrote:
[...]
> I also tried creating datasources for each local and then using a variable
> datasource in the entity such as:
>
> 
> 
> 
> 
>
> and then the document as:
>
> 
>   rootEntity="false">
>  
>  
> 
>
> but the ${local.code} variable is not resolved and it attempts to connect to
> the literal source content_${local.code}.
[...]

As you have discovered, the datasource attribute is not variable resolved.
There was a thread on this subject a couple of days ago, and apparently
Alexei has resolved the issue. Please see:
http://www.mail-archive.com/solr-user@lucene.apache.org/msg45407.html

Regards,
Gora


Variable datasources

2011-01-13 Thread tjpoe

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: 




then my import query looks like this


 
  
 


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:






and then the document as:


 
  
 


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.