[Bug][Module Name] Ask for question

[luxiaodong12]

Search before asking

• [ ] I had searched in the issues and found no similar question.

• [ ] I had googled my question but i didn't get any help.

• [ ] I had read the documentation: ChunJun doc but it didn't help me.

Description

一、问题：Mysql 同步数据到Oracle数据库中的时候，MySQL(源端) Time 字段类型同步到Oracle（目标端） 字段类型 number产生脏数据。 二、报错： 三、脚本 CREATE TABLE xd_mysql_sources_table ( BIGINT_COL STRING, CHAR_COL STRING, VARCHAR_COL STRING, TINYTEXT_COL STRING, TEXT_COL STRING, MEDIUMTEXT_COL STRING, LONGTEXT_COL STRING, TINYINT_COL STRING, SMALLINT_COL STRING, MEDIUMINT_COL STRING, INT_COL STRING, INTEGER_COL STRING, FLOAT_COL STRING, DOUBLE_COL STRING, DECIMAL_COL STRING, TIME_COL STRING, YEAR_COL STRING, DATE_COL STRING, DATETIME_COL STRING, TIMESTAMP_COL STRING, JSON_COL STRING, BLOB_COL STRING, LONGBLOB_COL STRING, TINYBLOB_COL STRING, MEDIUMBLOB_COL STRING, BINARY_COL STRING, VARBINARY_COL STRING, BIT_COL STRING, NUMERIC_COL STRING, ENUM_COL STRING, REAL_COL STRING, POLYGON_COL STRING, SET_COL STRING, MULTIPOLYGON_COL STRING, GEOMETRY_COL STRING, GEOMETRYCOLLECTION_COL STRING, POINT_COL STRING, MULTIPOINT_COL STRING, LINESTRING_COL STRING, MULTILINESTRING_COL STRING ) WITH ( 'table-name' = 'xd_mysql_sources_table', 'connector' = 'mysql-x', 'url' = 'jdbc:mysql://:/xd_datatype_maping?serverTimezone=UTC', 'username' = 'root', 'password' = 'mysql@123' );

CREATE TABLE xd_mysql_to_oracle ( BIGINT_COL STRING, CHAR_COL STRING, VARCHAR_COL STRING, TINYTEXT_COL STRING, TEXT_COL STRING, MEDIUMTEXT_COL STRING, LONGTEXT_COL STRING, TINYINT_COL STRING, SMALLINT_COL STRING, MEDIUMINT_COL STRING, INT_COL STRING, INTEGER_COL STRING, FLOAT_COL STRING, DOUBLE_COL STRING, DECIMAL_COL STRING, TIME_COL STRING, YEAR_COL STRING, DATE_COL STRING, DATETIME_COL STRING, TIMESTAMP_COL STRING, JSON_COL STRING, BLOB_COL STRING, LONGBLOB_COL STRING, TINYBLOB_COL STRING, MEDIUMBLOB_COL STRING, BINARY_COL STRING, VARBINARY_COL STRING, BIT_COL STRING, NUMERIC_COL STRING, ENUM_COL STRING, REAL_COL STRING, POLYGON_COL STRING, SET_COL STRING, MULTIPOLYGON_COL STRING, GEOMETRY_COL STRING, GEOMETRYCOLLECTION_COL STRING, POINT_COL STRING, MULTIPOINT_COL STRING, LINESTRING_COL STRING, MULTILINESTRING_COL STRING ) WITH ( 'connector' = 'oracle-x', 'schema' = 'BI', 'url' = 'jdbc:oracle:thin:@::helowin', 'table-name' = '', 'username' = '', 'password' = '**', 'scan.fetch-size' = '2', 'scan.query-timeout' = '10' ); INSERT INTO xd_mysql_to_oracle select * from xd_mysql_sources_table;

Code of Conduct

• [X] I agree to follow this project's Code of Conduct

[ll076110]

它的具体错误是什么呢，你的图中看不出