When using the service name in the Oracle JDBC connection string for the TIBCO CDC Plugin, the plugin will throw the following error at runtime.

2025-02-21T13:38:09,391 ERROR [CM Configuration Updater (Update: pid=bw.resource.jdbc.a5d7cebf-aeca-4b4a-b76e-39be2b698d31)] com.tibco.bw.thor.runtime.model.Constituent - TIBCO-BW-CORE-500304: Failed to start BW Application [Test_CDC:1.0] due to an activity error.
<CausedBy> com.tibco.bw.core.runtime.ActivityStartException: TIBCO-BW-CORE-500412: Failed to start the ProcessStarter activity [CDC-DB] in process [test_cdc.module.Process], module [Test_CDC.module] due to unexpected activity lifecycle error.
<CausedBy> java.lang.ArrayIndexOutOfBoundsException: Index 2 out of bounds for length 2

To use jdbc:oracle:thin:@<machine_name>:<port>/<service_name> format for the JDBC connection URL, the value can be set to database.url module property. This allows the CDC plugin to utilize the specified database.url from the module property at runtime.

Please follow the steps below to implement the workaround:

Step1: Add the following module property in the application:
com.tibco.bw.palette.cdc.additionalDbProperties = database.url=jdbc:oracle:thin:@<hostname>:<port>/<service_name>

step2: In the JDBC Shared Resource, specify the Database URL  in the format: jdbc:oracle:thin:@<machine_name>:<port>/<service_name>, and then click Test Connection. Once the connection test is successful, proceed to configure the CDC Listener activity.

step3: Once all configurations are complete, make sure to change the Database URL to use the format jdbc:oracle:thin:@<machine_name>:<port>:<instance_name> in JDBC Connection Shared Resource and test the application. During runtime, the application will utilize the connection URL specified in the database.url property.

Support for Service Name in Oracle JDBC Connection String for TIBCO ActiveMatrix BusinessWorks™ Plug-in for Change Data Capture