alibaba
Communications link failure
datax编译后进行mysql到mysql的数据同步测试，报这个错误：
2022-01-12 13:28:51.723 [job-0] WARN DBUtil - test connection of [jdbc:mysql://localhost:3306/source_datax] failed, for Code:[MYSQLErrCode-02], Description:[数据库服务的IP地址或者Port错误，请检查填写的IP地址和Port或者联系DBA确认IP地址和Port是否正确。如果是同步中心用户请联系DBA确认idb上录入的IP和PORT信息和数据库的当前实际信息是一致的]. - 具体错误信息为：com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
非编译的datax进行数据时不会报这个错误
对应的json文件内容为：
{
"job": {
"setting": {
"speed": {
"channel": 3,
"byte": 1048576
},
"errorLimit": {
"record": 0,
"percentage": 0.02
}
},
"content": [
{
"reader": {
"name": "mysqlreader",
"parameter": {
"username": "root",
"password": "123456",
"column": [
"id",
"name",
"sex"
],
"splitPk": "",
"connection": [
{
"table": [
"data"
],
"jdbcUrl": [
"jdbc:mysql://localhost:3306/source_datax"
]
}
]
}
},
"writer": {
"name": "mysqlwriter",
"parameter": {
"writeMode": "update",
"username": "root",
"password": "123456",
"column": [
"id",
"name1",
"sex1"
],
"connection": [
{
"table": [
"data1"
],
"jdbcUrl": "jdbc:mysql://localhost:3306/datax"
}
]
}
}
}
]
}
}
