[CAMEL-18427] Camel Debezium with Postgres on Spring Boot doesn't work

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.13.0, 3.18.1
• Fix Version/s: 3.18.3, 3.19.0
• Component/s: camel-debezium

Environment

Jdk 17

Windows 10

Spring boot

• Estimated Complexity: Unknown
• Regression: Regression

Language

java

• Assignee: Claus Ibsen
• Reporter: michael elbaz
• Created: 24/Aug/22 10:20
• Updated: 01/Dec/22 13:18
• Resolved: 06/Sep/22 07:33

Description

From camel 3.13.0 Camel Debezium simply not working is work perfectly with camel older than 3.13.0

(related to this ticket i think https://issues.apache.org/jira/browse/CAMEL-17135)

here the code

    @Override
    public void configure() throws Exception {
        String DATABASE_READER = "debezium-postgres:localhost?"
                + "databaseHostname=localhost"
                + "&databasePort=5432"
                + "&databaseUser=postgres"
                + "&databasePassword=test"
                + "&databaseDbname=test"
                + "&databaseServerName=localhost"
                + "&schemaWhitelist=public"
                + "&tableWhitelist=public.*"
                + "&offsetStorageFileName=/tmp/offset-file-1.dat"
                + "&offsetFlushIntervalMs=10000"
                + "&pluginName=pgoutput";
        from(DATABASE_READER)
                .routeId("debeziumPGRoute")
                .log("Response : ${body}");
    }

I check this changelog

the pom file

<dependency>
    <groupId>org.apache.camel</groupId>
    <artifactId>camel-debezium-postgres</artifactId>
</dependency>
<dependency>
    <groupId>org.apache.camel.springboot</groupId>
    <artifactId>camel-debezium-postgres-starter</artifactId>
</dependency>

Issue Links

• relates to: CAMEL-17135 camel-debezium-mongodb-starter does not pupulate values from application.properties