SqlException: Invalid state, the Connection object is closed & java.sql.SQLException: I/O Error: Connection reset

Marcus Wong Theen Nam 1,111 Reputation points
2021-02-19T03:37:27.443+00:00

I've received alert from the application vendor and the error message was "SqlException: Invalid state, the Connection object is closed" and also "java.sql.SQLException: I/O Error: Connection reset ". May I know is there anything we can check from SQL server side?

Thank you.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,319 questions
0 comments No comments
{count} votes

3 answers

Sort by: Most helpful
  1. Olaf Helper 43,161 Reputation points
    2021-02-19T06:47:32.13+00:00

    Connection object is closed … May I know is there anything we can check from SQL server side?

    There is nothing to check on SQL Server side.
    The application (or network layer) closed the connection to SQL Server in one part of the code, by whatever reason, and try to use the closed connection in an other part of the code.

    0 comments No comments

  2. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2021-02-22T05:27:32.443+00:00

    Hi MarcusWong-9726,

    You can try to collect simultaneous Network traces using Wireshark or Network monitor from both the application server and SQL Server.
    Please refer to SQL Error: I/O Error: Connection reset and Collect data using Network Monitor which might help.

    Best Regards,
    Amelia

    0 comments No comments

  3. Marcus Wong Theen Nam 1,111 Reputation points
    2021-03-12T02:47:19.183+00:00

    Hi,

    Just to update, the app team has done some modification in their codes to fix this issue so I believe that it was not related to SQL server. Thanks for the assistance.

    0 comments No comments