Hi, I did a debugger session and found that the column names are case sensitive (at least with Oracle). The column names are retreived from the JDBC metadatas and I found that my objectid is in fact OBJECTID.
So now, I'm able to do an update with the following config (pay attention to the OBJECTID): <entity name="test" pk="OBJECTID" query="select * from table" deltaImportQuery="select * from table where objectid='${dataimporter.delta.OBJECTID}'" deltaQuery="select objectid from table where lastupdate > '${dataimporter.last_index_time}'"> </entity> Is there a way to be "case insensitive" ? Anyway, it works now and that's the most important thing! :-) Thanks to all, Florian cbennett wrote: > > Hi, > > It looks like the deltaImportQuery needs to be changed you are using > dataimporter.delta.id which is not correct, you are selecting objected in > the deltaQuery, so the deltaImportQuery should be using > dataimporter.delta.objectid > > So try this: > > <entity name="test" pk="objectid" > query="select * from table" > deltaImportQuery="select * from table where > objectid='${dataimporter.delta.objectid}'" > deltaQuery="select objectid from table where lastupdate > > '${dataimporter.last_index_time}'"> > </entity> > > Colin. > -- View this message in context: http://lucene.472066.n3.nabble.com/Problem-with-DIH-delta-import-on-JDBC-tp763469p765262.html Sent from the Solr - User mailing list archive at Nabble.com.