search

confluentinc / kafka-connect-jdbc

Kafka Connect connector for JDBC-compatible databases
Other
21 stars 960 forks source link

Kafka JDBC Oracle connector failed #818

Open ghost opened 4 years ago

ghost commented 4 years ago

Hi all,

I've create an Oracle JDBC connector with kafka jdbc connector, but when i create a new connector, i received this message error.

Can anybody help me for this case, pls?

I am using Kafka-connect 5.0.0, Oracle 11.2.0.4 and ojdbc8.jar.

My configuration to Oracle is:

{
"name":"source_oracle_jdbc_source_source", "config":{
"connector.class":"io.confluent.connect.jdbc.JdbcSourceConnector", "tasks.max": 1, "connection.url":"jdbc:oracle:thin:@192.168.1.39:49161:xe", "connection.user": "system", "connection.password": "oracle", "schema.pattern": "HR", "table.whitelist" : "TBL_PERSON", "topic.prefix": "jdbcsource", "table.types": "VIEW", "mode":"incrementing", "incrementing.column.name": "id", "validate.non.null": false } }

Thank you.

ghost commented 4 years ago
Screen Shot 2020-03-19 at 08 17 22

Here is the error message!

gharris1727 commented 4 years ago

@KhoaNguyenDang121292 There's a hardcoded 10-second timeout for listing tables in the database, and it appears that it's exceeding that timeout.

Does your database have a large number of tables?

yagiel commented 4 years ago

@gharris1727 I do have the same issue, and the schema is quite opaque. I am using custom query to poll the results, so I am wondering why do we need to get table metadata in such case? Is there a way to override this 10 second timeout? Where is it hardcoded? is it in the driver?