CODEWITHSUNDEEP
jdbcapache-kafkasapapache-kafka-connectconfluent-platform
Sano
Sano

Reputation: 539

Kafka JDBC Connector SAP can't read table with name containing @ "Error Illegal initial character: @"

I am using JDBC connector to connect to SAP and read tables. Some of the tables have a name with @ at beginning and JDBC return me this error:

Illegal initial character: @

This is my connector configuration:

{
  "name": "sap-jdbc",
  "config": {
    "name": "sap-jdbc",
    "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector",
    "tasks.max": "10",
    "topic.prefix": "sap_",
    "table.whitelist": "DB.@MYTABLE",
    "connection.url": "jdbc:sap://server:30015/",
    "connection.user": "user",
    "connection.password": "password",
    "retention.ms": "86400000",
    "mode": "bulk",
    "poll.interval.ms": "86400000",
    
  },
}

I tried this configuratons without result

"table.whitelist": "\"DB\".\"@MYTABLE\"",
"table.whitelist": "DB.\"@MYTABLE\"",
"table.whitelist": "DB.'@MYTABLE'",
"table.whitelist": "DB.\\@MYTABLE",

Did anyone solve this?

Upvotes: 0

Views: 161

Answers (0)

Related Questions