使用SqlServer reader,PostgreSQL writer 在处理bit数据类型里转换成Boolean了,比较原sqlServer里的bit类型为0转换成flase; insert时报错了。
2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] 2020-04-21 13:27:33.139 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select [EID],... from eStatus 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] ] jdbcUrl:[jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test]. 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] 2020-04-21 13:27:33.676 [0-0-0-writer] WARN CommonRdbmsWriter$Task - 回滚此次写入, 采用每次写入一行方式提交. 因为:Batch entry 0 INSERT INTO e_status ("EID","xx","xx","isReJoin","isPrac",...) VALUES('477'::int4,'2010-05-10 00:00:00.000000 +08:00'::timestamp,NULL::numeric,'false'::int2,'false'::int2,NULL::int4,NULL::timestamp,NULL::timestamp,'false'::int2,'6'::int4,'2010-11-09 00:00:00.000000 +08:00'::timestamp,'2010-11-10 00:00:00.000000 +08:00'::timestamp,'3'::int4,'14'::int4,'1'::int4,'2'::int4,'2'::varchar,'2018-05-10 00:00:00.000000 +08:00'::timestamp,NULL::int4,NULL::timestamp,'false'::int2,NULL::timestamp,NULL::int4,NULL::int4,'false'::int2,'2018-06-21 00:00:00.000000 +08:00'::timestamp,NULL::varchar,NULL::numeric,'4'::int4,NULL::int4,'0'::int4,NULL::int4,NULL::timestamp,NULL::timestamp,NULL::timestamp,NULL::int4,NULL::int4,NULL::int4) was aborted. Call getNextException to see the cause. 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] 2020-04-21 13:27:33.683 [0-0-0-writer] ERROR StdoutPluginCollector - 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "false"
使用SqlServer reader,PostgreSQL writer 在处理bit数据类型里转换成Boolean了,比较原sqlServer里的bit类型为0转换成flase; insert时报错了。
2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] 2020-04-21 13:27:33.139 [0-0-0-reader] INFO CommonRdbmsReader$Task - Begin to read record by Sql: [select [EID],... from eStatus 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] ] jdbcUrl:[jdbc:sqlserver://127.0.0.1:1433;DatabaseName=test]. 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] 2020-04-21 13:27:33.676 [0-0-0-writer] WARN CommonRdbmsWriter$Task - 回滚此次写入, 采用每次写入一行方式提交. 因为:Batch entry 0 INSERT INTO e_status ("EID","xx","xx","isReJoin","isPrac",...) VALUES('477'::int4,'2010-05-10 00:00:00.000000 +08:00'::timestamp,NULL::numeric,'false'::int2,'false'::int2,NULL::int4,NULL::timestamp,NULL::timestamp,'false'::int2,'6'::int4,'2010-11-09 00:00:00.000000 +08:00'::timestamp,'2010-11-10 00:00:00.000000 +08:00'::timestamp,'3'::int4,'14'::int4,'1'::int4,'2'::int4,'2'::varchar,'2018-05-10 00:00:00.000000 +08:00'::timestamp,NULL::int4,NULL::timestamp,'false'::int2,NULL::timestamp,NULL::int4,NULL::int4,'false'::int2,'2018-06-21 00:00:00.000000 +08:00'::timestamp,NULL::varchar,NULL::numeric,'4'::int4,NULL::int4,'0'::int4,NULL::int4,NULL::timestamp,NULL::timestamp,NULL::timestamp,NULL::int4,NULL::int4,NULL::int4) was aborted. Call getNextException to see the cause. 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] 2020-04-21 13:27:33.683 [0-0-0-writer] ERROR StdoutPluginCollector - 2020-04-21 13:27:33 [ExecutorJobHandler.reader-134] org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: "false"