alibaba / DataX

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

rdbms 不支持读取db2 xml #2111

Open vinlee19 opened 2 months ago

vinlee19 commented 2 months ago

When using DataX to load data from DB2 to Doris, I encounter the following errors:

{"exception":"Code:[DBUtilErrorCode-12], Description:[不支持的数据库类型. 请注意查看 DataX 已经支持的数据库类型以及数据库版本.].  - 您的配置文件中的列配置信息有误. 因为DataX 不支持数据库读取这种字段类型. 字段名:[DESCRIPTION], 字段名称:[2009], 字段Java类型:[com.ibm.db2.jcc.DB2Xml]. 请尝试使用数据库函数将其转换datax支持的类型 或者不同步该字段 .","record":[{"byteSize":10,"index":0,"rawData":"100-100-01","type":5},{"byteSize":26,"index":1,"rawData":"Snow Shovel, Basic 22 inch","type":5},{"byteSize":4,"index":2,"rawData":"9.99","type":4},{"byteSize":4,"index":3,"rawData":"7.25","type":4},{"byteSize":8,"index":4,"rawData":1100793600000,"type":7},{"byteSize":8,"index":5,"rawData":1103385600000,"type":7}],"type":"reader"}

Perhaps we can consider adding support for reading XML types from DB2.