开发者社区> 问答> 正文

使用datax做mysql到mysql的数据迁移 报错ClassCastException

报java.lang.String cannot be cast to com.alibaba.fastjson.JSONObject错误

{ "job": { "setting": { "speed": { "channel": 1 } }, "content": [ { "reader": { "name": "streamreader", "parameter": { "username": "root", "password": "ACB42efef6pzVN", "connection": [ { "table": [ "doc_log" ], "jdbcUrl": "jdbc:mysql://localhost:4000/shop_data" } ], "column" : [ "remark", "owner_name" ],

                }
            },
            "writer": {
                "name": "mysqlwriter",
                "parameter": {
                    "username": "root",
                    "password": "ACB42efef6pzVN",
                    "column": [
						{
						    "name":"owner_name",
							"type": "STRING"
						},
						{
						    "name":"remark",
							"type":"STRING"
						}
					
                    ],
                    "connection": [
                        {
                            "jdbcUrl": 
                                "jdbc:mysql://localhost:4000/shop_data",
                            "table": [
                                "doc_log_copy1"
                            ]
                        }
                    ]
                }
            }
        }
    ]
}

}

展开
收起
游客p5i2ios2673cy 2021-02-26 17:13:41 1840 0
1 条回答
写回答
取消 提交回答
  • 个人对建模比较关注

    字段类型映射错误,检查一下源表字段和目标表字段的类型是否匹配

    2021-03-05 10:12:34
    赞同 展开评论 打赏
问答排行榜
最热
最新

相关电子书

更多
One Box: 解读事务与分析一体化数据库 HybridDB for MySQL 立即下载
One Box:解读事务与分析一体化数据库HybridDB for MySQL 立即下载
如何支撑HTAP场景-HybridDB for MySQL系统架构和技术演进 立即下载

相关镜像