Error While loading data in uuid column in postgresql

[vidya821]

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

[Anonymous · Accepted solution]

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