Try this..

<entity name=&quot;Cat1&quot;  
                    query=&quot;SELECT CategoryName,&lt;b>SKU* from
CAT_TABLE WHERE CategoryLevel=1" cacheKey=*"Cat1.SKU"*
cacheLookup="Product.SKU" processor="CachedSqlEntityProcessor">
                                <field column="CategoryName"
name="Category1" /> 
                        </entity>

Also not sure if you are using Alpha / Beta release of SOLR 4.0.

In Solr 3.6, 3.6.1, 4.0-Alpha & 4.0-Beta, the "cacheKey" parameter was
re-named "cachePk". This is renamed back for 4.0 (& 3.6.2, if released). See
SOLR-3850





--
View this message in context: 
http://lucene.472066.n3.nabble.com/How-do-I-use-CachedSqlEntityProcessor-tp4064919p4065116.html
Sent from the Solr - User mailing list archive at Nabble.com.

Reply via email to