Insert error with JDBC insert and PGSQL
I have a pipeline that reads from Oracle and writes to PGSQL. When inserting to PGSQL, I get this error
Batch entry 0 insert into “pg_temp”.“crmi002b_ut_pprs001” (“end_date”, “opportunity_type”, “s...
Forum Discussion
Hi @sathishmadavali,
After CSV parser add mapper and with ternary operator check/map if the field is empty. If it is then add null if not pass the field.
Example:
$fieldName == “” ? null : $fieldName
BR,
Pero M.
