Your delta query i.e. deltaQuery ="select distinct clai_idn as clai_idn from claim_history where clai_idn=29">
always gets only one row with a fixed "clai_idn". So here you fetch the same row. What you would want is to get all rows after a particular time, for that you may want to include timestamp in your deltaQuery as in the eg. here: http://wiki.apache.org/solr/DataImportHandler#Delta-Import_Example <http://wiki.apache.org/solr/DataImportHandler#Delta-Import_Example> -- View this message in context: http://lucene.472066.n3.nabble.com/delta-import-giving-Total-Documents-Processed-0-tp4089118p4089138.html Sent from the Solr - User mailing list archive at Nabble.com.