Random issue com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

Question

I am getting below issue while running jobs which are making connection with SQL server. The jobs are failing randomly with below error:

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.

at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:234) ~[mssql-jdbc-8.2.2.jre8.jar!/:?]

at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1130) ~[mssql-jdbc-8.2.2.jre8.jar!/:?]

at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:3520) ~[mssql-jdbc-8.2.2.jre8.jar!/:?]

at com.microsoft.sqlserver.jdbc.SQLServerConnection.createStatement(SQLServerConnection.java:3179) ~[mssql-jdbc-8.2.2.jre8.jar!/:?]

Jobs are written in java and we are making JDBC call

Answer 1

Hi @Kumar,

This is a random issue, please verify that there are no network issues causing the connection to drop. Ensuring stable network connectivity. The connection might be timing out due to inactivity. Ensure your connection pool settings are configured correctly, especially parameters like maxIdle and maxWait. In addition, if your application is sending a large number of requests, it might be hitting some resource limits. Adjusting the connection pool size and other related settings can help.

 

---

If the answer is helpful,  please click "Accept Answer" and kindly upvote it.