> I'm trying to use a delta query to update a specific entity
> by its
> primary key. The URL I'm using is:
>
> http://localhost:8080/solr/core2/dataimport?command=delta-import&did=5&commit=true&debug=true
>
> Where 5 is the PK.
>
> In my db config I have:
>
> <entity
> name="place"
>
> query="select
> OurID,Name,City,State,lat,lng,cost from place"
>
> deltaQuery="select OurID from place where OurID=
> '${dataimporter.request.did}'"
>
> deltaImportQuery="select
> OurID,Name,City,State,lat,lng,cost from place where
> OurID='${dataimporter.delta.id}'"
>
> >
>
> When I run the URL above I see the following results:
>
> <response>
> <lst name="responseHeader">
> <int name="status">0</int>
> <int name="QTime">0</int>
> </lst>
> <lst name="initArgs
> <lst name="defaults">
> <str name="config">db-data-config.xml</str>
> </lst>
> </lst>
> <str name="command">delta-import</str>
> <str name="status">idle</str>
> <str name="importResponse"/>
> <lst name="statusMessages">
> <str name="Total Requests made to
> DataSource">2</str>
> <str name="Total Rows Fetched">1</str>
> <str name="Total Documents Skipped">0</str>
> <str name="Delta Dump started">2010-08-18
> 10:06:17</str>
> <str name="Identifying Delta">2010-08-18
> 10:06:17</str>
> <str name="Deltas Obtained">2010-08-18
> 10:06:17</str>
> <str name="Building documents">2010-08-18
> 10:06:17</str>
> <str name="Total Changed Documents">1</str>
> <str name="Total Documents Processed">0</str>
> <str name="Time taken ">0:0:0.32</str>
> </lst>
>
> </response>
>
> It looks like its finding the row, but for some reason it's
> not
> processing it - any ideas?
Shouldn't it be OurID='${dataimporter.delta.OurID}' in deltaQuery?
