Configure CSA to Mitigate Frequently Dropped Database Connections

If you are experiencing frequently dropped database connections, configure the JBoss data source connections to mitigate the problem.

In a standalone environment, do the following:

1. Stop the CSA service:

   Windows:

   1. Navigate to Control Panel > Administrative Tools > Services.
   2. Right-click on the CSA service.
   3. Select Stop.

   Linux:

   From a command prompt, type service csa stop.

2. Edit the CSA_HOME/jboss-as/standalone/configuration/standalone.xml file:

   1. Find the dataSource tag which is used for CSA database configuration.

   2. Add the following after the line that ends with </security>:

      Oracle

      <validation>
<check-valid-connection-sql>select 1 from DUAL</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
</validation>

      MS SQL or PostgreSQL

      <validation>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
</validation>

3. Start the CSA service:

   Windows:

   1. Navigate to Control Panel > Administrative Tools > Services.
   2. Right-click on the CSA service.
   3. Select Start.

   Linux:

   From a command prompt, type service csa start.

In a clustered environment, do the following:

1. Stop the CSA service:

   Windows:

   1. Navigate to Control Panel > Administrative Tools > Services.
   2. Right-click on the CSA service.
   3. Select Stop.

   Linux:

   From a command prompt, type service csa stop.

2. Edit the CSA_HOME/jboss-as/standalone/configuration/standalone-full-ha.xml file:

   1. Find the dataSource tag which is used for CSA database configuration.

   2. Add the following after the line that ends with </security>:

      Oracle:

      <validation>
<check-valid-connection-sql>select 1 from DUAL</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
</validation>

      MS SQL or PostgreSQL:

      <validation>
<check-valid-connection-sql>select 1</check-valid-connection-sql>
<validate-on-match>false</validate-on-match>
</validation>

3. Start the CSA service:

   Windows:

   1. Navigate to Control Panel > Administrative Tools > Services.
   2. Right-click on the CSA service.
   3. Select Start.

   Linux:

   From a command prompt, type service csa start.