SQL Server failover error: Connection Closed

Last Year
JorgeR
MANAGEMENT CONSOLE

Summary

During a Bizagi deployment in a SQL Server cluster, the deployment could fail when the cluster switches from one node to another. This issue can be bypassed by modifying the configuration in JBoss files.

Applies to

Bizagi 10.x JEE using JBoss

Symptoms

When a SQL server failover is executed, Bizagi returns an error with the message: Connection Closed

Cause

The datasource settings in the JBoss standalone configuration file are not correct or are missing.

Solution

1. Edit the file standalone.xml for Clustered JBoss configuration or domain.xml Standard JBoss configuration, both of them located in C:\BizagiJEE\[BizagiVersion]\jboss-eap-6.2\standalone\configuration

2. Search the datasource segment and edit or add the validation parameters with the following script.

<validation>
<valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.mssql.MSSQLValidConnectionChecker"/>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
<background-validation>true</background-validation>
<background-validation-millis>1000</background-validation-millis>
</validation>


Details

Last Modified:Last Year
Last Modified By: Andread
Type: ERROR
Level: Intermediate
Rated 5 stars based on 1 vote
Article has been viewed 2.9K times.

Options