Thanks, I saw that mistake and I have it working now!!! thank you for all your help. Out of interest, is the cacheKey and cacheLookup documented anywhere?
Rolf Johansson-2 wrote: > > It's always a good thing if you can check the debug log (fx catalina.out) > or > run with debug/verbose to check how Solr runs trough the dataconfig. > > You've also made a typo in the pk and query, "LinkedCatAricleId" is > missing > a "t". > > /Rolf > > Den 2010-01-28 11.20, skrev "KirstyS" <kirst...@gmail.com>: > >> >> Okay, I changed my entity to look like this (have included my main entity >> as >> well): >> <document name="ArticleDocument"> >> <entity name="article" pk="CmsArticleId" >> query="Select * from vArticleSummaryDetail_SolrSearch >> (nolock) >> WHERE ArticleStatusId = 1" >> >> <entity name="LinkedCategory" pk="LinkedCatAricleId" >> query="SELECT LinkedCategoryBC, CmsArticleId as >> LinkedCatAricleId >> FROM LinkedCategoryBreadCrumb_SolrSearch (nolock)" >> processor="CachedSqlEntityProcessor" >> cacheKey="LinkedCatArticleId" >> cacheLookup="article.CmsArticleId" >> </entity> >> </entity> >> </document> >> >> BUT now the index is taking SO much longer!!!!!!!!!!!!!!!! Have I missed >> any >> other configurationg changes? Do I need to add anything into the >> solfconfig.xml file? Do I have my syntax completely wrong? >> >> Any help is greatly appreciated!!! > > > -- View this message in context: http://old.nabble.com/Help-using-CachedSqlEntityProcessor-tp27337635p27355501.html Sent from the Solr - User mailing list archive at Nabble.com.