Re: dataimport.properties is not updated on delta-import

2010-06-30 Thread warb
I've finally found the problem causing the delta-import to fail and thought I would post it here for future reference (if someone makes the same mistake I did). I had forgot to collect the "id" column in the deltaImportQuery. I should, of course, have known this from the log entires about documen

Re: dataimport.properties is not updated on delta-import

2010-06-25 Thread Alexey Serba
Please note that Oracle ( or Oracle jdbc driver ) converts column names to upper case eventhough you state them in lower case. If this is the case then try to rewrite your query in the following form select id as "id", name as "name" from table On Thursday, June 24, 2010, warb wrote: > > Hello ag

Re: dataimport.properties is not updated on delta-import

2010-06-24 Thread Erick Erickson
Is there any chance that the "id" field is, indeed, missing for those documents? Does your schema require ID? I've also seen constraints added to a DB that are not retro-active, so even if there is a constraint requiring ID it's still possible that some items in your DB don't have them. A shot in

Re: dataimport.properties is not updated on delta-import

2010-06-24 Thread warb
Hello again! Upon further investigation it seems that something is amiss with delta-import after all, the delta-import does not actually import anything (I thought it did when I ran it previously but I am not sure that was the case any longer.) It does complete successfully as seen from the front

Re: dataimport.properties is not updated on delta-import

2010-06-23 Thread Stefan Moises
Hi, what I have experienced is that the primary key seems to be case sensitive for the delta queries, at least for some jdcd drivers... see http://lucene.472066.n3.nabble.com/Problem-with-DIH-delta-import-on-JDBC-tp763469p765262.html ... so make sure you specify it with the correct case (e.g.

dataimport.properties is not updated on delta-import

2010-06-23 Thread warb
Hello! I am having some difficulties getting dataimport (DIH) to behave correctly in Solr 1.4.0. Indexing itself works just as it is supposed to with both full-import and delta-import adding modified or newly created records to the index. The problem is however that the date and time of the last