Giter VIP home page Giter VIP logo

Comments (2)

kevinpthorne avatar kevinpthorne commented on July 28, 2024 1

I believe I'm currently dealing with this...

{
  "name": "my-jdbc-connector",
  "config": {
    "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector",
    "tasks.max": "1",
    "connection.url": "jdbc:sqlserver://xxx/xxx",
    "connection.user": "xxx",
    "connection.password": "xxx",
    "mode": "incrementing",
    "incrementing.column.name": "id",
    "topic.prefix": "jdbc-",
    "name": "my-jdbc-connector",
    "table.whitelist": "dbo.xxx",
  }
}
$ confluent load my-jdbc-connector -d my-config.json
[...]
Missing 'name' property from connectors properties file.

I would only guess that it's a JDBC driver error? (As SQL Server driver does not come stock) Still investigating here.

Update: Turns out it was that pesky extra , at the end of the table.whitelist entry. Proper error codes are shown now.

from confluent-cli.

rmoff avatar rmoff commented on July 28, 2024

Related to the above - if I have malformed JSON, the error is

Missing 'name' property from connectors properties file.

But name is present - it's just the config elsewhere is screwy (in this case a split-line _comment).

{
  "name": "jdbc_source_mysql_foo_01",
  "config": {
  "_comment": "
  ",
  "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector",
  "_comment": "",
  "key.converter": "io.confluent.connect.avro.AvroConverter",
  "_comment": "",
  "key.converter.schema.registry.url": "http://localhost:8081",
  "_comment": "",
  "value.converter": "io.confluent.connect.avro.AvroConverter",
  "_comment": "",
  "value.converter.schema.registry.url": "http://localhost:8081",
  "_comment": "",
  "connection.url": "jdbc:mysql://localhost:3306/demo?user=rmoff&password=pw",
  "_comment": "",
  "table.whitelist": "foo",
  "_comment": "",
  "mode": "incrementing",
  "_comment": "",
  "validate.non.null": "false",
  "_comment": "",
  "incrementing.column.name": "c1",
  "_comment": "",
  "topic.prefix": "mysql2-"
  }
}

from confluent-cli.

Related Issues (20)

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.