Hi, I am having problems getting the delta-import to work for my schema. Following what i have found in the list, jira and the wiki below configuration should just work but it doesn't.
<dataConfig> <dataSource name="ora" driver="oracle.jdbc.OracleDriver" url="jdbc:oracle:thin:@....." user="...." password="...."/> <dataSource name="orablob" type="FieldStreamDataSource" /> <document name="mydocuments"> <entity dataSource="ora" name="attachment" pk="id" query="select id, bytes from attachment where application = 'MYAPP'" deltaImportQuery="select id, bytes from attachment where application = 'MYAPP' and id = '${dataimporter.attachment.id}'" deltaQuery="select id from attachment where application = 'MYAPP' and modified_on > to_date('${dataimporter.attachment.last_index_time}', 'yyyy-mm-dd hh24:mi:ss')"> <field column="id" name="attachmentId" /> <entity dataSource="orablob" processor="TikaEntityProcessor" url="bytes" dataField="attachment.bytes"> <field column="text" name="attachmentContents"/> </entity> </entity> </document> </dataConfig> The sql generated in the deltaquery is correct, the timestamp is passed correctly. When i execute that query manually in the DB it returns the pk of the rows that were added. However no documents are added to the index. What am i missing here ?? I'm using a build snapshot from 03/02. Thanks Jorg