are you sure your schema.xml has a <uniqueKey> field to UPDATE docs. to remove deleted docs you must have deletedPkQuery attribute in the root entity
On Tue, Mar 17, 2009 at 8:48 PM, Giovanni De Stefano <giovanni.destef...@gmail.com> wrote: > Hello all, > > I have a table TEST in an Oracle DB with the following columns: URI > (varchar), CONTENT (varchar), CREATION_TIME (date). > > The primary key both in the DB and Solr is URI. > > Here is my data-config.xml: > > <dataConfig> > <dataSource > driver="oracle.jdbc.driver.OracleDriver" > url="jdbc:oracle:thin:@localhost:1521/XE" > user="username" > password="password" > /> > <document name="Test"> > <entity > name="test_item" > pk="URI" > query="select URI,CONTENT from TEST" > * deltaQuery="select URI,CONTENT from TEST where > TO_CHAR(CREATION_TIME,'YYYY-MM-DD HH:MI:SS') > > '${dataimporter.last_index_time}'" * > > > <field column="URI" name="uri"/> > <field column="CONTENT" name="content"/> > </entity> > </document> > </dataConfig> > > The problem is that anytime I perform a delta-import, the index keeps being > populated as if new documents were added. In other words, I am not able to > UPDATE an existing document or REMOVE a document that is not anymore in the > DB. > > What am I missing? How should I specify my deltaQuery? > > Thanks a lot in advance! > > Giovanni > -- --Noble Paul