I have an Java application deployed on windows 20083 R2 machine connecting to SQL server on the same server.
once a week, we start getting this error.
Caused by: java.sql.SQLException: I/O Error: Connection reset
Caused by: java.net.SocketException: Connection reset
java.sql.SQLException: Invalid state, the Connection object is closed.
then i have restart the SQL server instance and then all works fine for the next couple of days,weeks. then the same issue. what could it be and how to solve this issue for good.