Database re-connection mechanism in TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Article ID: KB0078623
Updated On:
| Products | Versions |
|---|---|
| TIBCO ActiveMatrix BusinessWorks Plug-in for Database | 8.0.0 ,8.0.1 |
Description
Database re-connection mechanism in TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Issue/Introduction
For EventPoller activity, TIBCO ActiveMatrix BusinessWorks Plug-in for Database plugin is creating 3 connections
Environment
===================================================
Product:TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 8.0.0,8.0.1
OS: All Supported Operating Systems
====================================================
Resolution
For EventPoller activity, TIBCO ActiveMatrix BusinessWorks Plug-in for Database is creating 3 connections and if any SQLException comes it first checks that connection is valid or not if valid then throw exception also generate fault job, if not valid then start to do re-connection and interval of re-connection is same polling interval.
The re-connection happens only if connection is not "valid"
Three connections Details:
1) During Polling,
2) During Mutex Acquire and Release, it is using (Due to MySQL need different connection)
3) During Job generation, once Job is ready it is updating the same record from N/S to C/F
The re-connection happens only if connection is not "valid"
Three connections Details:
1) During Polling,
2) During Mutex Acquire and Release, it is using (Due to MySQL need different connection)
3) During Job generation, once Job is ready it is updating the same record from N/S to C/F
Feedback
Yes
No
Powered by
