wso2 / wso2/docs-apim

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

Open
#6,832 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

API-M 4.2.0
Dominant language
CSS
Stars
99
Forks
708
Avg merge
1d 7h
Merged PRs (30d)
22

Description

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 <SI_TOOLING_HOME>/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
    image
  2. Search "Change Data Capture - MySQL" and install it
    image
  3. Restart the SI Tooling

Note that adding the mysql-connector-java-5.1.45-bin.jar to the <SI_TOOLING_HOME>/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.

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Open the linked “Capture MySQL Inserts via CDC” documentation for APIM 4.2.0 and inspect its “Before you begin” section, especially step 2. Replace the outdated JAR-copy instruction with the three Extension installer steps described in the issue, and remove the note that the JAR is required. Done means the instructions match the working 4.2.0 setup.

Written by the indexing model from the issue text.

Assessment

Tech stack
mysql
Domain
databases, documentation
Issue type
Documentation
Difficulty
1/5
Estimated time
1-3 hours
Activity status
Stale
Clarity
Clearly specified
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.