I am trying to use Solr's DataImportHandler to index a large number of database
records in a SQL Server database that is owned and managed by a group we are
collaborating with. The indexing jobs I have run so far, except for the initial
very small test runs, have failed due to database connection resets. I have
gotten indexing jobs to go further by using CachedSqlEntityProcessor and
specifying responseBuffering=adaptive in the connection url, but I think in
order to index that data I'm going to have to work out how to catch database
connection reset exceptions and resubmit the queries that failed. Can anyone
can suggest a good way to approach this? Or have any of you encountered this
problem and worked out a solution to it already?
Thanks,
Mike
