On Fri, Nov 14, 2008 at 4:35 PM, Marc Sturlese <[EMAIL PROTECTED]> wrote:
>
> Hey there, I am using dataimport with full-import successfully but there's no
> way do make it work with delta-import. Aparently solr doesn't show any error
> but it does not do what it is supose to.
> I thing the problme is with dataimport.properties because it is never
> updated. I have it placed in the same folder as solrconfig.xml and
> schema.xml and the writing permissions are set propertly. What makes me
> doubt is that couldn't find anywhere to tell solr the path of this file.
> Don't know if solr is suposed to find it automatically.
>
> My data-config.xml looks like this:
> <dataConfig>
> <dataSource type="JdbcDataSource" driver="com.mysql.jdbc.Driver"
> url="jdbc:mysql://path_db" user="user" password="pwd"/>
> <document name="product">
> <entity name="entity_n" pk="id" query="select id,field1 from table
> order by id limit 1000" deltaQuery="select id from table where
> dt_last_modified > '${dataimporter.last_index_time}' order by id" >
> <field name="id" column="id" />
> <field name="field1" column="field1" />
> </entity>
> </document>
> </dataConfig>
> *I have in the rows of the table a timestamp field called dt_last_modified
>
> Other thing that can't exactly understant is why i have to put the query and
> delta-query... why just with deltaquery (with more fields in the select) is
> not enough?
deltaQuery is used to identify the changed rows.
after the changed rows are identified , it uses the query, or
deltaImportQuery to do the actual import
>
> After the ejecution everything seems to go ok (even with the debug and
> verbose mode) but no docs have changed and dataimport.properties is not
> updated...
>
> Any suggestion? Have done many tests but no way...
>
> --
> View this message in context:
> http://www.nabble.com/troubles-with-delta-import-tp20498449p20498449.html
> Sent from the Solr - User mailing list archive at Nabble.com.
>
>
--
--Noble Paul
