topic Re: how to pass a string using tMap in Talend Studio

how to pass a string using tMap

Anonymous — Mon, 06 Mar 2017 09:59:52 GMT

Hello , i have a problem.
I'm trying to insert inside a table of a database a string that i define. I use this syntax.
In the tMap on the coloumn that i need i pass this value "my string". But the insert in the table give mi an error.
It's wrong to pass a string in this way?
Thank you

Re: how to pass a string using tMap

TRF — Mon, 06 Mar 2017 10:56:09 GMT

Hi,
Can you share the error message ans maybe the tMap?

Re: how to pass a string using tMap

Anonymous — Mon, 06 Mar 2017 11:03:27 GMT

Sure, this is the error: Exception in component tPostgresqlOutput_2
[FATAL]: output_project3_0_1.output_project - tPostgresqlOutput_2 L'operazione «batch» 92 INSERT INTO ...("coloumn1","coloumn2","coloum3","problem_coloumn","error") VALUES (300144698,20,30,,error).
I try to put the query in pgAdmin and i get this error:
ERROR: syntax error at or near ","
LINE 2: ...,"problem_coloumn","error") VALUES (300144698,20,30,,error)

Re: how to pass a string using tMap

TRF — Mon, 06 Mar 2017 11:21:29 GMT

You cannot have a double comma in the insert statement. Should looks like VALUES (300144698,20,30,NULL,error) or VALUES (300144698,20,30,'',error)
Share the tMap to see how is completed the value for "problem_coloumn" field.

Re: how to pass a string using tMap

Anonymous — Mon, 06 Mar 2017 12:10:56 GMT

how i can insert a string in the coloumn errore?

Re: how to pass a string using tMap

TRF — Mon, 06 Mar 2017 13:19:02 GMT

Having a constant (here "errore") is a way.
However, you're sharing the reject flow. Can you share the flow from which rows arrive to tPostgres compponent as it is the place where data are prepared before the database injection?