[GitHub] [rocketmq-externals] gripson opened a new issue #549: [rocketmq-connect-jdbc] Possible enhancements record

[GitBox <gi...@apache.org>]

gripson opened a new issue #549: [rocketmq-connect-jdbc] Possible enhancements record
URL: https://github.com/apache/rocketmq-externals/issues/549
 
 
   
   The issue tracker is **ONLY** used for bug report and feature request.
    
   Any question or RocketMQ proposal please use our [mailing lists](http://rocketmq.apache.org/about/contact/).
   **FEATURE REQUEST**
   This is a recorder for issues I've met when deploying rocketmq-connect-runtime, and there are not many core-related or performance enhancements I can observe now, so I'll just put some simple enhancements as candidates.
    
    * [ ]  Update  Restful API template README.md file of jdbc connector. for example, Source connector Restful config:
   ```
   http://${runtime-ip}:${runtime-port}/connectors/${rocketmq-jdbc-source-connector-name}?config={"source-rocketmq":"NameSrv-addr:9876","source-cluster":"${rocketmqTopic-topicRoute-cluster-value}","connector-class":"org.apache.rocketmq.connect.jdbc.connector.JdbcSourceConnector","dbUrl":"${source-db-ip}",dbPort”:"${source-db-port}",dbUsername":"${source-db-username}","dbPassword”:"${source-db-password}","rocketmqTopic":"jdbcTopic","mode":"bulk","whiteDataBase":{"${source-db-name}":{"${source-table-name}":{"${source-column-name}":"${source-column-value}"}}},"source-record-converter":"org.apache.rocketmq.connect.runtime.converter.JsonConverter"}
   ```
   
   Since jdbc connector only can work successfully successfully when rocketmqTopic and topicNames are as same as ${source-table-name} of whiteDataBase, and there is same name database and tabke in target DBMS. 
   
   * [ ]  Issue of sending/receiving many messages than expectation: it produces duplicate data in target database, even there is only one row data in source database table. Test environment is both of source and target DBMS are MySQL.  
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services

[GitHub] [rocketmq-externals] imaffe commented on issue #549: [rocketmq-connect-jdbc] Possible enhancements recorder

[GitBox <gi...@apache.org>]

imaffe commented on issue #549: [rocketmq-connect-jdbc] Possible enhancements recorder
URL: https://github.com/apache/rocketmq-externals/issues/549#issuecomment-611355066
 
 
   I can help with the "fetch topic list error" problem, feels like it would help me understand the codebase better :)

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services