> > > Hi, > > The issue still isnt resolved .I have tried putting in > validationquery,testOnborrow ,and removeabandoned=true.
Are you try testOnReturn = true ? Looks like if when Apache Solr closes resources, and it requires to close the database connection, something has already closed the underlying connection . Maybe if DBCP test it before , the connection be evicted >But I got this > exception : > > java.sql.SQLException: Already closed. > at > org.apache.tomcat.dbcp.dbcp.PoolableConnection.close(PoolableConnection.java:84) > at > org.apache.tomcat.dbcp.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.close(PoolingDataSource.java:189) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.closeResources(Unknown > Source) > at > org.apache.solr.handler.dataimport.JdbcDataSource$ResultSetIterator.hasnext(Unknown > Source) > > Another interesting thing to note is that I set removeAbandoned=false,and > now I get the same exception with a different reason: > > Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1368) > at > com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1355) > at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1532) > at > com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:3274) > at > com.microsoft.sqlserver.jdbc.TDSReader.nextPacket(IOBuffer.java:3227) > at > com.microsoft.sqlserver.jdbc.TDSReader.ensurePayload(IOBuffer.java:3203) > at > com.microsoft.sqlserver.jdbc.TDSReader.readBytes(IOBuffer.java:3518) > at > com.microsoft.sqlserver.jdbc.TDSReader.readWrappedBytes(IOBuffer.java:35 > > > Help appreciated folks! > > Regards > > Aniket --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org