The error occurs "Connection lost. Trying to reconnect.." for DB connection while deploying TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database v8.0.0 on DOCKER Image.
book
Article ID: KB0076221
calendar_today
Updated On:
Products
Versions
TIBCO ActiveMatrix BusinessWorks Plug-in for Database
8.x
Description
In the TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database project, configure the JDBC URL using module property and then create a project EAR While deploying TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database v8.x EAR on DOCKER Image, below error could be occurred for DB Connection:
" INFO [Framework Event Dispatcher: Equinox Container: b0d85f97-5aff-0017-1df2-ad9f5dcc8872] c.t.b.p.a.r.d.ADBEventSource - TIBCO-BW-PALETTE-ADBPLUGIN-300002: Connection lost. Trying to reconnect.."
Environment
Product: TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database
Version:8.0.0
Product: TIBCO ActiveMatrix BusinessWorks™ Container Edition
Version:2.3.0
OS: All Supported Operating Systems
Resolution
To resolve above error, have two solutions: 1. To resolve the above error, add HostName's associated IP Address instead of hostname in the JDBC URL in the TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database project on BWCE Studio. OLD JDBC URL: jdbc:tibcosoftwareinc:oracle://<HostName>:<PortNumber>;ServiceName=<ServiceName> Required JDB URL : jdbc:tibcosoftwareinc:oracle://<IP Address>:<PortNumber>;ServiceName=<ServiceName> Then Recreate an EAR and re-deploy the same EAR on Docker.
2. Using the hostname in JDBC URL, need to add the hostname in Docker host file. For that execute the below command while deploying the EAR file
docker run -it --add-host <MACHINE NAME>:<IP ADDRESS> <DOCKER IMAGE NAME> ex: docker run -it --add-host mdapora2dcl71-scan.wind.root.it:10.0.0.1 dummyimage*
Executing the above command successfully able to deploy the EAR file using the hostname in the JDBC URL for TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database project.
Issue/Introduction
Use HostName's associated IP Address instead of hostname in JDBC URL in the TIBCO ActiveMatrix BusinessWorks™ Plug-in for Database project on BWCE Studio.