The Debezium Oracle connector has this error [SQLException: No suitable driver found] in kafka OCP4 configuration.

Solution Verified - Updated -

Issue

  • The customer is experiencing an error 'java.sql.SQLException: No suitable driver found for jdbc driver with the Debizium Oracle connector along with Kafka configuration.
schema.history.internal.producer.sasl.jaas.config=********, database.include.list=dbo.TABLE1, schema.history.internal.producer.sasl.mechanism=SCRAM-SHA-512, schema.history.internal.consumer.security.protocol=SASL_PLAINTEXT} with user '[database.user,null,[],[],true]' (io.debezium.connector.oracle.OracleConnector) [pool-12-thread-94]
java.lang.RuntimeException: Failed to resolve Oracle database version
    at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:170)
    at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:80)
    at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:75)
    at io.debezium.connector.oracle.OracleConnector.validateConnection(OracleConnector.java:74)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@hostname:1521/DBZIUMUSER
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:702)
    at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189)

Environment

  • Kafka
    • Operator RH Integration
    • AMQ Streams 2.3.X.
  • Debezium
    • Operator RH Integration
    • AMQ Streams 2.3.x (We create kafka connect an kafka connector, files shared).
  • Oracle Database
    • 19c.

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content