receiver name not detected

[msillence]

• It was my bad, I journaled my files with a journal that was not in the *LIB => I Just updated my file and now it detects everythings :open_mouth:

--> for this constraint, do you think that you'll be able to update it ? I'm not a big java developper but I scrolled through the code and saw this on this page I think that maybe it's where the problem is. I use a query to get journal info https://gist.github.com/andymalo43/16231be5805866b523abe3271409a0e5 I hope this can help you :)

have a great day

And again : Thank you very much for your work :)

Originally posted by @andymalo43 in https://github.com/jhc-systems/debezium-connector-ibmi/issues/40#issuecomment-1556699739

[msillence]

@andymalo43 thanks for the update, it's great to hear you have it working now and the ccsid is also working

I feel this update about the receiver name and the change request belongs to a seperate issue - which I've cretaed.

The proposed SQL runs very slowly on our iseries so I'm not so keen on that solution. I propose I add a new configuration parameter for the journal receiver so you can set it to something that isn't detected with the existing mechanism.

Does that sound OK to you?

[andymalo43]

Hi @msillence, If I well understand, you think to put a parameter for the lib of the journal of the table to track cdc ? I think it'ld be a killer feature for your connector :D

[msillence]

OK I think we can get the journal for a table using QDBRTVFD - if you have an include list this will now detect the journal correctly and also fail if the list spans more than one journal (you would need more than one connector configured one for each journal)

https://github.com/jhc-systems/debezium-connector-ibmi/pull/55

[msillence]

fixed in release silllencem/debezium-connector-ibmi:2.2.1.Final_1.9.20