KB-1129 How to configure JBoss databases to reconnect automatically in Appian

This article outlines how to configure a data source configured in a *-ds.xml file to attempt to reconnect automatically if the connection is lost. This does not apply to data sources configured in the Admin Console.

  1. Edit the *-ds.xml located in <JBOSS_HOME>/standalone/deployments.
  2. Inside the <xa-datasource> tag in the desired data source, add one of the below elements depending on your RDBMS vendor:

Oracle/MySQL

<validation>
    <validate-on-match>true</validate-on-match>
    <background-validation>false</background-validation>
    <check-valid-connection-sql>SELECT 1 FROM DUAL</check-valid-connection-sql>
</validation>

SQL Server

<validation>
    <validate-on-match>true</validate-on-match>
    <background-validation>false</background-validation>
    <check-valid-connection-sql>SELECT GETDATE()</check-valid-connection-sql>
</validation>

Affected Versions

This article applies to all versions of Appian using JBoss as an application server.

Last Reviewed: July 2017

Related
Recommended