While connecting to the database using TIBCO ActiveMatrix BusinessWorks Plug-in for Database, after stopping the adapter, why does TIBCO ActiveMatrix BusinessWorks Plug-in for Database creates inactive sessions?
book
Article ID: KB0076228
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database
7.2
Description
While connecting to the database using TIBCO ActiveMatrix BusinessWorks Plug-in for Database, after stopping the adapter, why does TIBCO ActiveMatrix BusinessWorks Plug-in for Database creates inactive sessions?
Issue/Introduction
The TIBCO ActiveMatrix BusinessWorks Plug-in for Database (ADB adapter)will close all the created connections when it stops
Environment
==================
Product: TIBCO ActiveMatrix BusinessWorks Plug-in for Database
Version: 7.2
OS: All Supported Operating Systems
==================
Resolution
Normally, the TIBCO ActiveMatrix BusinessWorks Plug-in for Database(ADB adapter) will close all the created connections when it stops. But sometimes there could be chances that the TIBCO ActiveMatrix BusinessWorks Plug-in for Database(ADB adapter) lost connections to the DB. For instance, the network issue may happen or TIBCO ActiveMatrix BusinessWorks Plug-in for Database(ADB adapter) instance is not stopped correctly. In such cases, the adapter may be lost the control to the connections, and the inactive connections might be caused by this kind of issues.
From the TIBCO ActiveMatrix BusinessWorks Plug-in for Database(ADB adapter) perspective, the adapter could not close the inactive sessions. It will need to close those inactive sessions manually from the DB side.