Support Article

com.microsoft.sqlserver.jdbc.SQLServerException:Connection close

SA-1510

Summary



Users face intermittent connectivity issues while accessing the database. Whenever database connectivity is lost, the error message displays.

Error Messages



Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
    at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:130)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:294)
    at com.microsoft.sqlserver.jdbc.SQLServerConnection.getAutoCommit(SQLServerConnection.java:1754)
    at com.pega.pegarules.data.internal.access.DatabaseConnectionImpl.getAutoCommit(DatabaseConnectionImpl.java:724)
    at com.pega.pegarules.data.internal.access.ConnectionManagerImpl.returnConnection(ConnectionManagerImpl.java:1803)



Root Cause



A defect or misconfiguration in the PRPC operating environment 


Resolution



Perform the following local-change:

Add the following parameters to the Tomcat context.xml file:


maxActive="100"
maxIdle="30"
maxWait="10000"
validationQuery="SELECT 1"
testOnBorrow="true"
validationInteval="30000"

Published November 16, 2016 - Updated October 8, 2020


100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.