alibaba / DataX

DataX是阿里云DataWorks数据集成的开源版本。
Other
15.77k stars 5.4k forks source link

oracle迁移到oracle数据 #2049

Open yy73 opened 8 months ago

yy73 commented 8 months ago

读可以正常读取,但写出现问题

yy73 commented 8 months ago

出现问题 java.lang.ClassCastException: class java.lang.String cannot be cast to class java.util.List (java.lang.String and java.util.List are in module java.base of loader 'bootstrap')

yy73 commented 8 months ago

{ "job": { "setting": { "speed": { "channel":1 }, "errorLimit": { "record": 0, "percentage": 0.02 } }, "content": [ { "reader": { "name": "oraclereader", "parameter": { "username": "1234", "password": "12312412", "column": [ "id","create_by", "update_by", "account_id", "name", "age", "sex", "email", "education_max", "job_title", "post", "phone", "unit", "college", "platform_type", "platform_name", "subject_type", "subject_name", "sa_nationality", "sa_unit", "visit_s", "visit_e", "exchange_program", "summarize", "pic", "apply_year", "apply_materials_result", "apply_materials_time", "apply_materials_opinion", "review_result", "review_time", "review_opinion", "files", "serial_number", "source", "card_no", "title_category", "access_category" ], "connection": [ { "table": [ "BURSE_BASIC_INFO" ], "jdbcUrl": ["jdbc:oracle:thin:@1234123:1521:abc"] } ] } }, "writer": { "name": "oraclewriter", "parameter": { "username": "111", "password":"111", "batchSize": 1000, "column": ["id", "create_by", "update_by", "account_id", "name", "age", "sex", "email", "education_max", "job_title", "post", "phone", "unit", "college", "platform_type", "platform_name", "subject_type", "subject_name", "sa_nationality", "sa_unit", "visit_s", "visit_e", "exchange_program", "summarize", "pic", "apply_year", "apply_materials_result", "apply_materials_time", "apply_materials_opinion", "review_result", "review_time", "review_opinion", "files", "serial_number", "source", "card_no", "title_category", "access_category"], "preSql": "", "connection": [ { "jdbcUrl": "jdbc:oracle:thin:@1234444:1521:123412", "table": ["burse_basic_info"] } ], } } } ] } }