question

MarcusWong-9726 avatar image
0 Votes"
MarcusWong-9726 asked ·

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

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-general
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

OlafHelper-2800 avatar image
0 Votes"
OlafHelper-2800 answered ·

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.



·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

AmeliaGu-msft avatar image
0 Votes"
AmeliaGu-msft answered ·

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


·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

MarcusWong-9726 avatar image
0 Votes"
MarcusWong-9726 answered ·

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.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.