问题:
按照模板改写后,就是报连接不上数据库
原因一:DataX使用的mysql驱动包
解决:
1.替换 datax\plugin\reader\mysqlreader\libs\mysql-connector-java-5.1.34.jar 为mysql-connector-java-8.0.18.jar
下载地址:https://cdn.mysql.com//Downloads/Connector-J/mysql-connector-java-8.0.18.zip
原因二:job文件改写错误
正确示例如下:(注意表名,数据名修改为你定义的名字,jdbc问号后的参数必须带,不然可能报错)
{
"job": {
"setting": {
"speed": {
"channel": 3
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "mysql",
"column": [
"id",
"name"
],
"connection": [
{
"table": ["表名"],
"jdbcUrl": ["jdbc:mysql://127.0.0.1:3306/数据库名?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8"]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "insert",
"username": "root",
"password": "mysql",
"column": [
"id",
"name"
],
"session": [],
"connection": [
{
"jdbcUrl": "jdbc:mysql://127.0.0.1:3306/数据库名?useUnicode=true&characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8",
"table": ["表名"]
}
]
}
}
}
]
}
}