Issue connecting Kafka with JDBC driver of interbase

[Bommu03]

Hi Team, I am facing a problem in creating connector for interbase database using interclient.jar driver . I have placed the .jar file in right folder as per my docker configuration. The path to .jar file is

/etc/kafka-connect/jars".

I am using linux system.I have downloaded interclient from the link https://www.dbschema.com/interbase-jdbc-driver.html.

The POST command for connector configuration is as curl -X POST -H "Content-Type: application/json" --data "{ \"name\": \"ib_connector\",\"config\": { \"connector.class\": \"io.confluent.connect.jdbc.JdbcSourceConnector\", \"tasks.max\": 1,\"connection.url\": \"jdbc:interbase://remoteip:3050/TEST2.gdb?user=SYSDBA&password=masterkey\",\"mode\": \"timestamp+incrementing\", \"incrementing.column.name\": \"id\",\"timestamp.column.name\": \"modified\", \"topic.prefix\": \"test-interbase-\", \"poll.interval.ms\": 1000 } }" http://localhost:8083/connectors.

The error message i am getting is as follows.

{"error_code":400,"message":"Connector configuration is invalid and contains the following 2 error(s):\nInvalid value java.sql.SQLException: No suitable driver found for jdbc:interbase://remoteip:3050/TEST2?user=SYSDBA&password=masterkey for configuration Couldn't open connection to jdbc:interbase://remoteip:3050/TEST2?user=SYSDBA&password=masterkey\nInvalid value java.sql.SQLException: No suitable driver found for jdbc:interbase://remoteip:3050/TEST2?user=SYSDBA&password=masterkey.

The docker-compose file is configured as

`version: '3.7' services: zookeeper: image: confluentinc/cp-zookeeper:${CONFLUENT_VERSION} networks:

• kafka environment: ZOOKEEPER_CLIENT_PORT: 2181 ZOOKEEPER_TICK_TIME: 2000 KAFKA_JMX_PORT: 39999

  kafka: image: confluentinc/cp-kafka:${CONFLUENT_VERSION} depends_on:

• zookeeper ports:
• 9092:9092 networks:

• kafka environment: KAFKA_BROKER_ID: 1 KAFKA_ZOOKEEPER_CONNECT: zookeeper:2181 KAFKA_ADVERTISED_LISTENERS: PLAINTEXT://kafka:9092 KAFKA_OFFSETS_TOPIC_REPLICATION_FACTOR: 1 KAFKA_GROUP_INITIAL_REBALANCE_DELAY_MS: 0 KAFKA_JMX_PORT: 49999

  schema-registry: image: confluentinc/cp-schema-registry:${CONFLUENT_VERSION} depends_on:

• zookeeper
• kafka networks:

• kafka environment: SCHEMA_REGISTRY_KAFKASTORE_CONNECTION_URL: zookeeper:2181 SCHEMA_REGISTRY_HOST_NAME: schema-registry

  connect: image: confluentinc/cp-kafka-connect:${CONFLUENT_VERSION} depends_on:

• zookeeper
• kafka
• schema-registry ports:
• 8083:8083 networks:

• kafka volumes:

  • ${KAFKA_CONNECT_JARS_PATH}:/etc/kafka-connect/jars environment: CONNECT_BOOTSTRAP_SERVERS: 'kafka:9092' CONNECT_REST_ADVERTISED_HOST_NAME: connect CONNECT_REST_PORT: 8083 CONNECT_GROUP_ID: compose-connect-group CONNECT_CONFIG_STORAGE_TOPIC: docker-connect-configs CONNECT_CONFIG_STORAGE_REPLICATION_FACTOR: 1 CONNECT_OFFSET_FLUSH_INTERVAL_MS: 10000 CONNECT_OFFSET_STORAGE_TOPIC: docker-connect-offsets CONNECT_OFFSET_STORAGE_REPLICATION_FACTOR: 1 CONNECT_STATUS_STORAGE_TOPIC: docker-connect-status CONNECT_STATUS_STORAGE_REPLICATION_FACTOR: 1 CONNECT_KEY_CONVERTER: io.confluent.connect.avro.AvroConverter CONNECT_KEY_CONVERTER_SCHEMA_REGISTRY_URL: 'http://schema-registry:8081' CONNECT_VALUE_CONVERTER: io.confluent.connect.avro.AvroConverter CONNECT_VALUE_CONVERTER_SCHEMA_REGISTRY_URL: 'http://schema-registry:8081' CONNECT_INTERNAL_KEY_CONVERTER: org.apache.kafka.connect.json.JsonConverter CONNECT_INTERNAL_VALUE_CONVERTER: org.apache.kafka.connect.json.JsonConverter CONNECT_ZOOKEEPER_CONNECT: 'zookeeper:2181' CONNECT_PLUGIN_PATH: '/usr/share/java,/etc/kafka-connect/jars'

  elasticsearch: image: docker.elastic.co/elasticsearch/elasticsearch:6.5.2 volumes:

• ./elasticsearch/config/elasticsearch.yml:/usr/share/elasticsearch/config/elasticsearch.yml:ro ports:
• "9200:9200"
• "9300:9300" environment: ES_JAVA_OPTS: "-Xmx256m -Xms256m" networks:

• kafka

  kibana: image: docker.elastic.co/kibana/kibana:6.5.2 volumes:

• ./kibana/config/:/usr/share/kibana/config:ro ports:
• "5601:5601" networks:
• kafka depends_on:

• elasticsearch

  kafka-manager: image: sheepkiller/kafka-manager:${KAFKA_MANAGER_VERSION} depends_on:

• zookeeper ports:
• 9000:9000 networks:
• kafka environment: ZK_HOSTS: 'zookeeper:2181'

networks: kafka: driver: bridge ` What could be the issue in this. Please help.

[OneCricketeer]

As mentioned on Stackoverflow, this will be difficult to test and verify as working without the ability to freely install interbase itself...

At the very least, I was able put the JAR next to all my others, and used jdbc:interbase://..., and was expecting a network exception, for example, but no... When I switch back to another URL for another driver, I do get its driver found and timeout exceptions since I don't have its database running, so I know the Connector path is correct.

Personally, I would suggest debugging the problem outside of Docker first to reduce the issue space