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 &gt; 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

Reply via email to