RE: DIH nested entities don't work

Hi James, Just to let you know, i've just completed the PoC and it worked great! Thanks. What i still find difficult to is how to implement a 'guided' navigation with Solr. That is one of the strenghts of Endeca and with Solr you have to create this yourself. What are your thoughts on that and wh

RE: DIH nested entities don't work

Hi, I got things working for 7 views and it looks good! Next things is getting all the views in the index and getting my schema.xml in order. I'll let you know how it goes! Thanks!!!, Maarten -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-entities-don-t-work-t

RE: DIH nested entities don't work

Hi James, I was out for a week hence the late response. I did as you suggested and i can import several views in parallel. However running the data-import which does the join gives the following errors: 27-nov-2012 10:11:24 org.apache.solr.common.SolrException log SEVERE: Exception while processi

RE: DIH nested entities don't work

Hi, You are correct about not wanting to index everything every day, however for this PoC i need a 'bootstrap' mechanism which basically does what Endeca does. The 'defaultRowPrefetch' in the solrconfig.xml does not seem to take, i'll have a closer look. With the long time, it appeard that one o

RE: DIH nested entities don't work

Hi James, Just gave it a go and it worked! That's the good news. The problem now is getting it to work faster. It took over 2 hours just to index 4 views and i need to get information from 26. I tried adding the defaultRowPrefetch="2" as a jdbc parameter but it does not seem to honour that. I

RE: DIH nested entities don't work

Thanks, i'll give that a try tomorrow. Here's the data-config.xml which i will try when i get to work tomorrow: :1521/ENDDEV" user="un" password="pw"/> the view

RE: DIH nested entities don't work

Hi, I've created a jar with 5 files: 4 files with DIHCache*.java 1 file named BerkleyBackedCache.java I've changed the data-config based on your input. What i see it doing is that it is building a cache at the given location. However the first testrun took almost *3* hours before i got a message:

RE: DIH nested entities don't work

Additional information: i just finished a test for 10.000 records (the db containts 600K products), it took 25 minutes and all the parents records had the same 'feature'. -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-entities-don-t-work-tp4015514p4019227.html Se

RE: DIH nested entities don't work

Hi James, What i did: * build a jar from the patch * downloaded the BDB library * added them to my classpath * download a nightly 4.1 Sol build * created a db config according to: http://svn.apache.org/repos/asf/lucene/dev/branches/branch_4x/solr/contrib/dataimporthandler/src/test/org/apache/solr/

Re: DIH nested entities don't work

Hi, It seems to work without the cache option, the downside is it will takes ages for everything to be indexed and my testset is 20 times smaller than the productset. Indexing just the root item takes 3 minutes (>600K) but every subentity takes more time which is obvious but i would've hoped it w

Re: DIH nested entities don't work

Hi, I've tried the subselection query and it works fine. It's weekend now:-) so what i'm going to do is remove the cache option. I'll also try a different jdbc driver and a few jdbc driver options. Thanks, Maarten -- View this message in context: http://lucene.472066.n3.nabble.com/DIH-nested-

Re: DIH nested entities don't work

None taken:-) Here's the info OS: Linux Java: 1.6 Oracle driver: ojdbc14.jar *view structure:* END_FRG_PRODUCTS_VW pdt_id pdt_title stock_availability pdt_pce_bolprice gpc_id offer_type search_rank search_title END_FRG_FEAT

Re: DIH nested entities don't work

Hi, I tried giving the pdt_id from the subentity a specific value and it worked. Only now every product has the same value. I tried a different subentity with the construct subentity.pdt_id='${entity.pdt_id}' with the same result as above, all products had a songtitle with the same value. So wh

Re: DIH nested entities don't work

Hi, The views are very specific and every column contains relevant information, thus the '*'. But a strange thing happened, i ran the data-import again and for some reason products had features but still no synonyms. The only thing i changed was to use: processor="SqlEntityProcessor " cacheImpl="

Re: DIH nested entities don't work

Hi, Here's the relevant part of my schema: pdt_id ... the data is read from into another searchengine fine but i'll try the select queries individually. The field-definitions need some tweaking. As for the songtitle, this was a typo Cheers, Maarten

DIH nested entities don't work

Hi, We have several oracle views which contain the result of an ETL process. I want to index information from those views and have the following data-config.xml :1521/ user="a" password="a"/> ... products