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

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

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

  1. Illegal initial character: @

这是我的连接器配置

  1. {
  2. "name": "sap-jdbc",
  3. "config": {
  4. "name": "sap-jdbc",
  5. "connector.class": "io.confluent.connect.jdbc.JdbcSourceConnector",
  6. "tasks.max": "10",
  7. "topic.prefix": "sap_",
  8. "table.whitelist": "DB.@MYTABLE",
  9. "connection.url": "jdbc:sap://server:30015/",
  10. "connection.user": "user",
  11. "connection.password": "password",
  12. "retention.ms": "86400000",
  13. "mode": "bulk",
  14. "poll.interval.ms": "86400000",
  15. },
  16. }

我试过这个但没有结果

  1. "table.whitelist": "\"DB\".\"@MYTABLE\"",
  2. "table.whitelist": "DB.\"@MYTABLE\"",
  3. "table.whitelist": "DB.'@MYTABLE'",
  4. "table.whitelist": "DB.\\@MYTABLE",

有人解决了吗?

暂无答案!

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

相关问题