Documentation Gaps on Adding MySQL to SI in Capturing MySQL Inserts via CDC for APIM 4.2.0

[piyumaldk]

In the Capture MySQL Inserts via CDC section in the doc,

It was mentioned that we have to download mysql-connector-java-5.1.45-bin.jar and add that to the /lib path. [1]

This is in the "Before you begin" section as the step 2.

But even though we follow this in 4.2, this leads to the below error.

ERROR {io.siddhi.core.stream.input.source.Source} - Error on 'SweetProductionStream'. Connection to the database lost. Error while connecting at Source 'cdc' at 'insertSweetProductionStream'. Will retry in '5 sec'. (Encoded)

So in 4.2, in order to fix this, we have to follow below 3 steps instead of step 2.

1. Go to Tools > Extension installer
2. Search "Change Data Capture - MySQL" and install it
3. Restart the SI Tooling

_Note that adding the mysql-connector-java-5.1.45-bin.jar to the /lib is not needed now._

[1]. https://apim.docs.wso2.com/en/4.2.0/use-cases/examples/streaming-examples/cdc-with-listening-mode/#!:~:text=Copy%20the%20mysql%2Dconnector%2Djava%2D5.1.45%2Dbin.jar%20JAR%20and%20place%20it%20in%20the%20%3CSI_TOOLING_HOME%3E/lib%20directory.

[piyumaldk]

Please not that Creating an ETL Application via SI Tooling [1] also containing above doc issue at the "Before you begin" section. Please fix that also.

[1]. https://apim.docs.wso2.com/en/4.2.0/use-cases/streaming-tutorials/creating-etl-application-via-tooling/