JDBC Connections Time Out

Problem

JDBC connections from Linux to MS SQL Server 2008 R2/Windows 2008 R2 time out after 40 seconds causing SQL/Stored Procedure Tasks that take longer than 40 seconds to fail with the following exception:
 

2014-09-22-14:51:37:034 -0400  ERROR [Ops.General.15.EP.SqlHandler.ecd8ab62183f4b9dbf32d3ea4ad0a126.74b824ad1ca84142a40d3ec1f84d4d2b.0] SQLServerException - Connection reset
com.microsoft.sqlserver.jdbc.SQLServerException: Connection reset 
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1667)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.terminate(SQLServerConnection.java:1654)
          at com.microsoft.sqlserver.jdbc.TDSChannel.read(IOBuffer.java:1789)
          at com.microsoft.sqlserver.jdbc.TDSReader.readPacket(IOBuffer.java:4838)
          at com.microsoft.sqlserver.jdbc.TDSCommand.startResponse(IOBuffer.java:6150)
          at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:402)
          at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350)
          at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696)
          at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1715)
          at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180)
          at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155)
          at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.execute(SQLServerPreparedStatement.java:332)
          at com.stonebranch.opswise.server.events.SqlEventHandler.storedProc(SqlEventHandler.java:266)

Resolution

To disable TCP Chimney Offload, follow these steps:

Step 1

Use administrative credentials to open a command prompt.

Step 2

At the command prompt, enter the following command: netsh int tcp set global chimney=disabled

Step 3

Press ENTER:.


For additional information, see:

http://support.microsoft.com/kb/951037