Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread Noble Paul നോബിള്‍ नोब्ळ्
Thanks for pointing this out. The wiki had a problem fro a while and we could not update the documentation. It is updated here http://wiki.apache.org/solr/DataImportHandler#cached On Thu, Jan 28, 2010 at 6:31 PM, KirstyS wrote: > > Thanks, > I saw that mistake and I have it working now!!! thank y

Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread KirstyS
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 chec

Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread Rolf Johansson
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" : > > Okay, I changed

Re: Help using CachedSqlEntityProcessor

2010-01-28 Thread KirstyS
Okay, I changed my entity to look like this (have included my main entity as well): 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? A

Re: Help using CachedSqlEntityProcessor

2010-01-27 Thread Noble Paul നോബിള്‍ नोब्ळ्
cacheKey and cacheLookup are required attributes . On Thu, Jan 28, 2010 at 12:51 AM, KirstyS wrote: > > Thanks. I am on 1.4..so maybe that is the problem. > Will try when I get back to work tomorrow. > Thanks > > > Rolf Johansson-2 wrote: >> >> I recently had issues with CachedSqlEntityProcessor

Re: Help using CachedSqlEntityProcessor

2010-01-27 Thread KirstyS
Thanks. I am on 1.4..so maybe that is the problem. Will try when I get back to work tomorrow. Thanks Rolf Johansson-2 wrote: > > I recently had issues with CachedSqlEntityProcessor too, figuring out how > to > use the syntax. After a while, I managed to get it working with cacheKey > and > cac

Re: Help using CachedSqlEntityProcessor

2010-01-27 Thread Rolf Johansson
I recently had issues with CachedSqlEntityProcessor too, figuring out how to use the syntax. After a while, I managed to get it working with cacheKey and cacheLookup. I think this is 1.4 specific though. It seems you have double WHERE clauses, one in the query and one in the where attribute. Try