Uhg... my mistake. Thanks!
On Wed, Aug 18, 2010 at 10:22 AM, Ahmet Arslan <iori...@yahoo.com> wrote: >> 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? > > > >
