"I/O Error: Connection reset" occurs while long running Queries queries.

Solution Unverified - Updated -

Issue

  • While performing some long running SQL Queries the against "SQLServer 2008R2" throws the following exception on JBoss logs:
 Caused by: java.net.SocketException: Connection reset
    at java.net.SocketInputStream.read(SocketInputStream.java:168)
    at java.io.DataInputStream.readFully(DataInputStream.java:178)
    at java.io.DataInputStream.readFully(DataInputStream.java:152)
    at net.sourceforge.jtds.jdbc.SharedSocket.readPacket(SharedSocket.java:826)
    at net.sourceforge.jtds.jdbc.SharedSocket.getNetPacket(SharedSocket.java:707)
    at net.sourceforge.jtds.jdbc.ResponseStream.getPacket(ResponseStream.java:466)
    at net.sourceforge.jtds.jdbc.ResponseStream.read(ResponseStream.java:103)
    at net.sourceforge.jtds.jdbc.ResponseStream.peek(ResponseStream.java:88)
    at net.sourceforge.jtds.jdbc.TdsCore.wait(TdsCore.java:3870)
    at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1042)

Environment

  • JBoss Enterprise Application Platform (EAP)
    • 5.x
    • 6.x

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In