topic Re: Character Varying[] in Talend Studio

Character Varying[]

Anonymous — Fri, 22 Aug 2014 14:30:37 GMT

I am attempting to insert rows into a Postgres table that has a column defined as a character varying array. I am trying to use a tMap component but there does not seem to be a suitable data type to map to a column of this type. I have tried using a tJavaRow and built a java String[] and that didn't work either.
I have searched extensively and have found no information regarding this. Has anyone successfully done this before?
Thanks in advance,
T

Re: Character Varying[]

Anonymous — Fri, 22 Aug 2014 14:40:05 GMT

Hi ,
Use "String" data type for character varying.
Thanks,
Kumar

Re: Character Varying[]

Anonymous — Fri, 22 Aug 2014 16:15:34 GMT

It is a character varying array though not a simple character varying field.
{"This ,"Is", "the","data"} not
"This is the data"

Re: Character Varying[]

Anonymous — Fri, 22 Aug 2014 16:47:01 GMT

hi,
try to add varchar[] in window -> preferences -> talend -> specific setting -> metadata of talend type
drom java type to db type & db type to java type for varchar [].(i've done it for json type for postgres without problem)
but still the way to propagate String[] type in Talend flow ... no idea right now !
regards
laurent

Re: Character Varying[]

Anonymous — Fri, 22 Aug 2014 16:50:49 GMT

.... perhaps using list type to propagate data & list.toArray before insert in DB ....