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.

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.