Loading a Table with a Column of Type TINYINT(1) from Mysql to PostgreSQL throws ODI-1228 Error Caused by "org.postgresql.util.PSQLException: ERROR: column [COLUMN_NAME] is of type integer but expression is of type boolean"
(Doc ID 2962635.1)
Last updated on AUGUST 07, 2024
Applies to:
Data Integration Platform Cloud Classic - Version 17.3.5 and laterOracle Data Integrator - Version 12.2.1.4.0 and later
Oracle Data Integrator on Marketplace - Version 1.0.2 and later
Oracle Data Integrator Cloud Service - Version 17.1.3 and later
Information in this document applies to any platform.
Symptoms
Using Oracle Data Integrator (ODI) 12c to load a table with tinyint(1) columns from MySql to PostgreSQL, the following error occurs when inserting data into a staging table (C$):
At this time, column col3 of the data Model of test (Mysql) is not set to Type, so Type=TINYINT is set and saved.
Set the Loading Knowledge Module: to the default "LKM SQL to SQL (Built-In)".
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |