datax达梦数据库

Oracle转达梦数据库

• 失败案例：

{
	"job": {
		"setting": {
			"speed": {
				"byte": 1048576
			},
			"errorLimit": {
				"record": 0,
				"percentage": 0.02
			}
		},
		"content": [{
			"reader": {
				"name": "oraclereader",
				"parameter": {
					"username": "username",
					"password": "password",
					"connection": [{
						"jdbcUrl": ["jdbc:oracle:thin:@[host]:port:orcl"],
						"querySql":["select * from tableName"]
					}]
				}
			},
			"writer": {
				"name": "rdbmswriter",
				"parameter": {
					"connection": [{
						"jdbcUrl": "jdbc:dm://localhost:5236/XXX",
						"table": ["tableName"]
					}],
					"username": "username",
					"password": "password",
					"table": "tableName",
					"column": ["column1", "column2", "column3"]
				}
			}
		}]
	}
}

报错信息：

经多次测试和分析

错误原因：在tableName前没有添加库名前缀

纠正：将涉及达梦数据库tableName的前面全加上库名前缀“XXX”即可成功执行。

• 成功案例：

{
	"job": {
		"setting": {
			"speed": {
				"byte": 1048576
			},
			"errorLimit": {
				"record": 0,
				"percentage": 0.02
			}
		},
		"content": [{
			"reader": {
				"name": "oraclereader",
				"parameter": {
					"username": "username",
					"password": "password",
					"connection": [{
						"jdbcUrl": ["jdbc:oracle:thin:@[host]:port:orcl"],
						"querySql":["select * from XXX.tableName"]
					}]
				}
			},
			"writer": {
				"name": "rdbmswriter",
				"parameter": {
					"connection": [{
						"jdbcUrl": "jdbc:dm://localhost:5236/XXX",
						"table": ["XXX.tableName"]
					}],
					"username": "username",
					"password": "password",
					"table": "tableName",
					"column": ["column1", "column2", "column3"]
				}
			}
		}]
	}
}

注意：以上代码涉及username、password、库名、表名均已替换，请换成自己的库表名称再做尝试。

读者在使用的时候最好使用datax官网的reader和writer数据库模板。

原创不易，侵权必究。