Please file this as a JIRA. Also, is it possible to test this on the Solr trunk?
On Thu, May 17, 2012 at 8:10 AM, Rahul Warawdekar <rahul.warawde...@gmail.com> wrote: > Hi, > > I am using Solr 3.4 on Tomcat 6 and using DIH to index data from a MS SQL > Server 2008 database. > > In case my database is down, or is refusing connections due to any reason, > DIH throws an exception as mentioned below > > "org.apache.solr.handler.dataimport.DataImportHandlerException: Unable to > execute query: ....................................... > .... > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368)" > > But when the database is up and running and the next indexing job runs, it > gives me the same error. > I need to restart Tomcat in order to succesfully connect again to the > database. > > My dataSource settings in data-config.xml are as follows > <dataSource jndiName="java:comp/env/jdbc/XXX" type="JdbcDataSource" > readOnly="true" /> > > Has anyone come across this issue before ? > If yes, what is the resolution ? > Am I missng anything in the dataSource attributes (autoCommit=true) ?? > -- > Thanks and Regards > Rahul A. Warawdekar -- Lance Norskog goks...@gmail.com
