Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

rdbms 不支持读取db2 xml #2111

Open
vinlee19 opened this issue Apr 29, 2024 · 0 comments
Open

rdbms 不支持读取db2 xml #2111

vinlee19 opened this issue Apr 29, 2024 · 0 comments

Comments

@vinlee19
Copy link

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant