topic Re: CDC by tsetGlobalVar in Talend Studio

CDC by tsetGlobalVar

Anonymous — Sat, 16 Nov 2024 07:32:46 GMT

Hi everyone

i want to ask a question to you i know it is simple but i am a beginner

i want to create a job to capture cdc from oracle database on column name updated_date but when i run the job i encountered an error such as screen shot

Re: CDC by tsetGlobalVar

Anonymous — Tue, 02 Oct 2018 11:22:03 GMT

Hi,

it seems to be a problem in your sql request.

Stéphane

Re: CDC by tsetGlobalVar

Anonymous — Tue, 02 Oct 2018 12:22:35 GMT

this is my query is there anything wrong

"select * from table1 where updated_date>TO_DATE("+"'"+globalMap.get("myKey").toString()+"'"+",'yyyy-MM-dd hh24:mi:ss')"

Re: CDC by tsetGlobalVar

Anonymous — Tue, 02 Oct 2018 12:54:26 GMT

i found the the mistake i changed the tmap_2 component to tconverttype because when i check the myKey paramters via tjavaRow myKey value was equal to "Sat Aug 31 03:47:09 EEST 2013"

when i changed the tmap2 component to tconvertype and date to string everything is fine now