Ich habe folgendes in dataconfig_1.xml
<?xml version="1.0" encoding="UTF-8"?>
<dataConfig>
<dataSource batchSize="-1" convertType="true" driver="com.mysql.jdbc.Driver" password="solrpw" url="jdbc:mysql://127.0.0.1/solrDB" user="solruser"/>
<document name="items">
<entity name="root" pk="id" preImportDeleteQuery="data\_source:1" query="select a.id, a.body, a.headline title ,a.date datecreated, a.title\_id ,t.name publisher\_name from article as a inner join title as t on t.id=a.title\_id" transformer="TemplateTransformer" deltaImportQuery="select a.id, a.body, a.headline title ,a.date datecreated, a.title\_id ,t.name publisher\_name from article as a inner join title as t on t.id=a.title\_id where last\_update\_time > '${dataimporter.last\_index\_time}'" deltaQuery="select id from article where last\_update\_time > '${dataimporter.last\_index\_time}'">
<field column="data\_source" template="1"/>
<field column="data\_source\_type" template="Jdbc"/>
<field column="data\_source\_name" template="syndigate\_solr"/>
</entity>
</document>
</dataConfig>
und in dataimport_1.properties habe ich
#Tue Aug 02 06:53:21 UTC 2011
last\_index\_time=2011-08-02 06\\:52\\:51
root.last\_index\_time=2011-08-02 06\\:52\\:51
Wenn ich jetzt deltaimport ausführe
http://myip:8888/solr/collection1/dataimport\_1?command=delta-import
Ich habe folgende Antwort erhalten
<response>
<lst name="responseHeader">
<int name="status">0</int>
<int name="QTime">8</int>
</lst>
<lst name="initArgs">
<lst name="defaults">
<str name="config">dataconfig\_1.xml</str>
</lst>
</lst>
<str name="command">delta-import</str>
<str name="status">idle</str>
<str name="importResponse"/>
<lst name="statusMessages">
<str name="Time Elapsed">0:0:1.552</str>
<str name="Total Requests made to DataSource">2</str>
<str name="Total Rows Fetched">18954</str>
<str name="Total Documents Processed">0</str>
<str name="Total Documents Skipped">0</str>
<str name="Delta Dump started">2011-08-02 09:35:52</str>
<str name="Identifying Delta">2011-08-02 09:35:52</str>
<str name="Deltas Obtained">2011-08-02 09:35:52</str>
<str name="Building documents">2011-08-02 09:35:52</str>
<str name="Total Changed Documents">18954</str>
<str name="">Indexing failed. Rolled back all changes.</str>
<str name="Rolledback">2011-08-02 09:35:52</str>
</lst>
<str name="WARNING">
This response format is experimental. It is likely to change in the future.
</str>
</response>
Haben Sie eine Idee, was ich falsch mache? Danke für Ihre Hilfe