kafka jdbc连接器sap无法读取带有@“error invaligal initial character:@”的表

zu0ti5jz  于 2021-06-07  发布在  Kafka
关注(0)|答案(0)|浏览(216)

我使用jdbc连接器连接到sap和reat表。有些代码在开头有@,jdbc会返回这个错误

Illegal initial character: @

这是我的连接器配置

{
  "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",

  },
}

我试过这个但没有结果

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

有人解决了吗?

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题