Question
MSJ Software Solutions Ltd
CA
Last activity: 22 Feb 2019 15:35 EST
com.microsoft.sqlserver.jdbc.SQLServerException:Connection close (SA-1510)
Article:
SA-1510 provided a solution to make a local change to Tomcat Server Configuration.
https://community.pega.com/support/support-articles/commicrosoftsqlserverjdbcsqlserverexceptionconnection-close
Can someone suggest equivalent configuration for Jboss Server.
Error Messages:
Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: The connection is closed.
at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDriverError(SQLServerException.java:226)
at com.microsoft.sqlserver.jdbc.SQLServerConnection.checkClosed(SQLServerConnection.java:1051) at com.microsoft.sqlserver.jdbc.SQLServerConnection.setAutoCommit(SQLServerConnection.java:3029) at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:905) at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1918) at
***Edited by Moderator Marissa to update platform capability tags****
Accepted Solution
Pegasystems Inc.
US
Hi Madhu,
You can look into your JBOSS documentation and set the above suggested change into your META-INF/context.xml(or equivalent context xml in your configuration) as specified over here under 4. Configure JBoss Web's Resource Factory section. If you have any further doubts then you can reach your Server administrator who might help you further.Hope that might help you.
Regards
Mahesh M