topic Error While loading data in uuid column in postgresql in Talend Studio

Error While loading data in uuid column in postgresql

vidya821 — Sat, 16 Nov 2024 03:44:03 GMT

Hi All,

Am getting below error while loading data in uuid column in postgresql,

Batch entry 0 INSERT INTO "community" ("occupation_company","occupation_description") VALUES (,,) was aborted. Call getNextException to see the cause.
caused by: ERROR: invalid input syntax for type uuid: ""

Note: The column occupation_company and occupation_description is read as Object data type in talend and is uuid data type in DB

can anyone please let me know how to handle the same.

Thanks

Re: Error While loading data in uuid column in postgresql

Anonymous — Tue, 07 Jan 2020 09:13:23 GMT

Hello,

The input schema value (Object or String) is not of UUID type?

Have you tried to use tMap to do the conversion to see if it works?

The input value should be converted into UUID type using functions such as java.util.UUID.fromString(...) :

java.util.UUID.fromString(row1.myInputColumn)

if InputColumn schema is already of type String

java.util.UUID.fromString(row1.myInputColumn.toString())

if InputColumn schema is of type Object

Let us know if it works.

Best regards

Sabrina