I am trying to connect to Oracle database with debezium OracleConnector, but i am getting below error
java.lang.RuntimeException: Failed to resolve Oracle database version
at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:163)
at io.debezium.connector.oracle.OracleConnection.<init>(OracleConnection.java:75)
at io.debezium.connector.oracle.OracleConnector.validateConnection(OracleConnector.java:74)
at io.debezium.connector.common.RelationalBaseSourceConnector.validate(RelationalBaseSourceConnector.java:52)
at org.apache.kafka.connect.runtime.AbstractHerder.validateConnectorConfig(AbstractHerder.java:400)
at org.apache.kafka.connect.runtime.AbstractHerder.lambda$validateConnectorConfig$2(AbstractHerder.java:351)
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at java.lang.Thread.run(Thread.java:748)
Caused by: java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@xxxxxx
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:208)
at io.debezium.jdbc.JdbcConnection.lambda$patternBasedFactory$0(JdbcConnection.java:185)
at io.debezium.jdbc.JdbcConnection$ConnectionFactoryDecorator.connect(JdbcConnection.java:122)
at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:891)
at io.debezium.jdbc.JdbcConnection.connection(JdbcConnection.java:886)
at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:639)
at io.debezium.jdbc.JdbcConnection.queryAndMap(JdbcConnection.java:513)
at io.debezium.connector.oracle.OracleConnection.resolveOracleDatabaseVersion(OracleConnection.java:133)
I have tried placing ojdbc8.jar and also tried with ojdbc10.jar to connector libs but nothing working, i could able to connect to the database from my system with any database client but while trying to connect through connector getting issues.
**Please find my configuration using below**
{
"name": "oracle-connector",
"config": {
"connector.class": "io.debezium.connector.oracle.OracleConnector",
"database.hostname": "xxx",
"database.port":"1521",
"database.user": "xxx",
"database.password": "xxx",
"
database.server.id": "184054",
"
database.server.name": "oracle",
"database.dbname": "xxx",
"
database.pdb.name": "",
"database.include.list":"xxx",
"
database.out.server.name":"test.game",
"include.schema.changes": "true",
"database.history.kafka.bootstrap.servers": "localhost:9092",
"database.history.kafka.topic": "test.game",
"tasks.max" : "1"
}
}
Can any one help me on resolving this issue.