TIBCO BusinessEvents agent executes specific SQL to validate database connection.
Article ID: KB0089582
Updated On:
| Products | Versions |
|---|---|
| TIBCO BusinessEvents Enterprise Edition | - |
| Not Applicable | - |
Description
Resolution:
Description:
===========
By default TIBCO BusinessEvents agent executes the following SQL statement every 60secs (backingstore enabled).
"Select 10 from dual"
Environment:
===========
TIBCO Business Events 4.x/5.x
All Operating Systems
Symptoms:
=========
SQL statement "Select 10 from dual" processed every 60 secs.
Cause:
======
This is a static query to validate the database connection (by default executed every 60 seconds).
Resolution:
========
It is possible to define the check intervall by adding the following property to the Cluster Deployment Descriptor (CDD)
e.g. increase time interval to 600 secs
<property name="be.backingstore.test.connections.interval" value="600"/>
Description:
===========
By default TIBCO BusinessEvents agent executes the following SQL statement every 60secs (backingstore enabled).
"Select 10 from dual"
Environment:
===========
TIBCO Business Events 4.x/5.x
All Operating Systems
Symptoms:
=========
SQL statement "Select 10 from dual" processed every 60 secs.
Cause:
======
This is a static query to validate the database connection (by default executed every 60 seconds).
Resolution:
========
It is possible to define the check intervall by adding the following property to the Cluster Deployment Descriptor (CDD)
e.g. increase time interval to 600 secs
<property name="be.backingstore.test.connections.interval" value="600"/>
Issue/Introduction
TIBCO BusinessEvents agent executes specific SQL to validate database connection.
Feedback
Yes
No
Powered by
