Test Debezium with KafkaOffsetBackingStore offset storage

[jamesnetherton]

Currently all Debezium tests use the default FileOffsetBackingStore. We should test in at least one place with offsetStorage=KafkaOffsetBackingStore.

Relates to this example route.

[jomin7]

Hi,
I would like to work on this task.
Best Regards
Jomin

[jomin7]

Quick Update: Expanding Scope for GraalVM Native Mode

While working on this, I found out that KafkaOffsetBackingStore doesn't work in GraalVM native mode for any Debezium connector. A few Kafka client classes it relies on—like JmxReporter, RangeAssignor, CooperativeStickyAssignor, and some SASL handlers—aren't registered for reflection.

Because of this, I'm expanding the scope of the PR to fix it across the board:

The Fix: Added the missing Kafka client reflection registrations to the shared DebeziumSupportProcessor. This fixes native mode for all Debezium connectors.

The Tests: Adding KafkaOffsetBackingStore integration tests for both MongoDB and Postgres.

Finishing up the changes now and will push the commits shortly.