The Debezium Oracle connector has this error [SQLException: No suitable driver found] in kafka OCP4 configuration.
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.