topic Stop job from automatically converting a string to an integer in Talend Studio

Stop job from automatically converting a string to an integer

Anonymous — Mon, 23 Mar 2020 11:09:19 GMT

I am building a job and want to query a database. I am reading a delimited file containing IDs and timestamps. The schema for the database (PostgreSQL 9.6) and the delimited file are set to varchar/string for the IDs and timestamps for the dates.

When I try to query the database using the ID from the delimited file, I get the following error message:

org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying = integer

How can I prevent the job from automatically converting the string to an integer since the strings will only contain integer values but changing the type in the database itself is not possible.

Re: Stop job from automatically converting a string to an integer

TRF — Mon, 23 Mar 2020 11:22:00 GMT

Share your component settings

Re: Stop job from automatically converting a string to an integer

Anonymous — Mon, 23 Mar 2020 12:44:58 GMT

Sorry, here they are. Contains the job export with metadata for the database and delimited file as well as the sql for creating the database and the delimited file itself.

export.zip