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
