Bird
Raised Fist0

You configured a Kafka JDBC source connector but it is not importing any data. Which of the following is the most likely cause?

medium📝 Debug Q14 of Q15
Kafka - Connect
You configured a Kafka JDBC source connector but it is not importing any data. Which of the following is the most likely cause?
AThe Kafka topic name is missing in the connector config
BThe JDBC URL is incorrect or unreachable
CThe connector class is set to ElasticsearchSinkConnector
DThe S3 bucket name is not specified
Step-by-Step Solution
Solution:
  1. Step 1: Check connectivity issues

    If the JDBC URL is wrong or unreachable, the connector cannot read data from the database.
  2. Step 2: Evaluate other options

    The Kafka topic name is missing in the connector config would cause errors but usually the connector won't start; The connector class is set to ElasticsearchSinkConnector is wrong connector type; The S3 bucket name is not specified is unrelated to JDBC source.
  3. Final Answer:

    The JDBC URL is incorrect or unreachable -> Option B
  4. Quick Check:

    Bad JDBC URL = no data import [OK]
Quick Trick: Always verify JDBC URL connectivity first [OK]
Common Mistakes:
MISTAKES
  • Confusing connector class for source vs sink
  • Ignoring missing topic config errors
  • Checking unrelated S3 settings for JDBC issues

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More Kafka Quizzes