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

Question

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.

Answer 1

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.

Answer 2

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

Answer 3

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.