You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@rocketmq.apache.org by GitBox <gi...@apache.org> on 2022/08/24 14:07:44 UTC
[GitHub] [rocketmq-connect] Oliverwqcwrw opened a new issue, #284: The Jdbc Connector configuration is incorrect
Oliverwqcwrw opened a new issue, #284:
URL: https://github.com/apache/rocketmq-connect/issues/284
**BUG REPORT**
1. Please describe the issue you observed:
- What did you do (The steps to reproduce)?
The README of the JDBC Connector is incorrect
>
* **jdbc-source-connector** 启动
```
POST http://${runtime-ip}:${runtime-port}/connectors/${rocketmq-jdbc-source-connector-name}
{
"connector-class":"org.apache.rocketmq.connect.jdbc.connector.JdbcSourceConnector",
"max-task":"2",
"connection.url":"jdbc:mysql://XXXXXXXXX:3306",
"connection.user":"*****",
"connection.password":"*****",
"table.whitelist":"db.table",
"mode": "incrementing",
"incrementing.column.name":"id",
"timestamp.initial": -1,
"source-record-converter":"org.apache.rocketmq.connect.runtime.converter.JsonConverter"
}
```
* **jdbc-sink-connector** 启动
```
POST http://${runtime-ip}:${runtime-port}/connectors/${rocketmq-jdbc-sink-connector-name}
{
"connector-class":"org.apache.rocketmq.connect.jdbc.connector.JdbcSinkConnector",
"max-task":"2",
"connect-topicname":"connect-topicname-jdbc-02",
"connection.url":"jdbc:mysql://*****:3306/{dbname}",
"connection.user":"******",
"connection.password":"******",
"pk.fields":"id",
"pk.mode":"record_value",
"insert.mode":"UPSERT",
"source-record-converter":"org.apache.rocketmq.connect.runtime.converter.JsonConverter"
}
- What is expected to see?
>
jdbc-source-connector** 启动
```
POST http://${runtime-ip}:${runtime-port}/connectors/${rocketmq-jdbc-source-connector-name}
{
"connector-class":"org.apache.rocketmq.connect.jdbc.connector.JdbcSourceConnector",
"max-task":"2",
"connection.url":"jdbc:mysql://XXXXXXXXX:3306/{sourceDbName}",
"connection.user":"*****",
"connection.password":"*****",
"table.whitelist":"db.table",
"mode": "incrementing",
"incrementing.column.name":"id",
"timestamp.initial": -1,
"connect-topicname":"targetTopic",
"key-converter":"org.apache.rocketmq.connect.runtime.converter.record.json.JsonConverter",
"value-converter":"org.apache.rocketmq.connect.runtime.converter.record.json.JsonConverter"
}
```
* **jdbc-sink-connector** 启动
```
POST http://${runtime-ip}:${runtime-port}/connectors/${rocketmq-jdbc-sink-connector-name}
{
"connector-class":"org.apache.rocketmq.connect.jdbc.connector.JdbcSinkConnector",
"max-task":"2",
"connect-topicname":"targetTopic",
"connection.url":"jdbc:mysql://*****:3306/{sinkDbName}",
"connection.user":"******",
"connection.password":"******",
"pk.fields":"id",
"pk.mode":"record_value",
"insert.mode":"UPSERT",
"key-converter":"org.apache.rocketmq.connect.runtime.converter.record.json.JsonConverter",
"value-converter":"org.apache.rocketmq.connect.runtime.converter.record.json.JsonConverter"
}
- What did you see instead?
2. Please tell us about your environment:
3. Other information (e.g. detailed explanation, logs, related issues, suggestions on how to fix, etc):
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@rocketmq.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [rocketmq-connect] duhenglucky closed issue #284: The Jdbc Connector configuration is incorrect In README
Posted by GitBox <gi...@apache.org>.
duhenglucky closed issue #284: The Jdbc Connector configuration is incorrect In README
URL: https://github.com/apache/rocketmq-connect/issues/284
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: dev-unsubscribe@rocketmq.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org