datax(oraclereader-mysqlwriter)测试用例

小鱼儿 2022-02-26 01:04 395阅读 0赞

# 做了两个测试： #

## 第一个测试没有报错，但是没有取到数据； ##

## 第二次测试成功。 ##

### 测试一的json文件如下： ###

{
        "job": {
            "content": [
                {
                    "reader": {
                        "name": "oraclereader",
                        "parameter": {
                            "column": ["*"],
                            "splitPk": "id",
                            "connection": [
                                {
                                    "jdbcUrl": ["jdbc:oracle:thin:@192.168.192.100:1521:orclwx"],
                                    "table": ["t1"]
                                }
                            ],
                            "password": "1234",
                            "username": "wangxin"
                        }
                    },
                    "writer": {
                        "name": "mysqlwriter",
                        "parameter": {
                            "column": ["*"],
                            "connection": [
                                {
                                    "jdbcUrl": "jdbc:mysql://192.168.192.10:3360/test?allowPublicKeyRetrieval=true",
                                    "table": ["t1"]
                                }
                            ],
                            "password": "123123",
                            "username": "root",
                            "writeMode": "insert"
                        }
                    }
                }
            ],
            "setting": {
                "speed": {
                    "channel": "2"
                }
            }
        }
    }

### 测试二的json文件如下： ###

{
        "job": {
            "content": [
                {
                    "reader": {
                        "name": "oraclereader",
                        "parameter": {
                            "column": ["*"],
                            "splitPk": "id",
                            "connection": [
                                {
                                    "jdbcUrl": ["jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.192.100)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=orclwx.us.oracle.com)(INSTANCE_NAME=orclwx)))"],
                                    "table": ["t1"]
                                }
                            ],
                            "password": "1234",
                            "username": "wangxin"
                        }
                    },
                    "writer": {
                        "name": "mysqlwriter",
                        "parameter": {
                            "column": ["*"],
                            "connection": [
                                {
                                    "jdbcUrl": "jdbc:mysql://192.168.192.10:3360/test?allowPublicKeyRetrieval=true",
                                    "table": ["t1"]
                                }
                            ],
                            "password": "123123",
                            "username": "root",
                            "writeMode": "insert"
                        }
                    }
                }
            ],
            "setting": {
                "speed": {
                    "channel": "2"
                }
            }
        }
    }

oracle/mysql reader/writer 参数在

[https://github.com/alibaba/DataX][https_github.com_alibaba_DataX]

都有。唯一需要注意的就是json文件格式。

[https_github.com_alibaba_DataX]: https://github.com/alibaba/DataX