topic Re: context variable in Talend Studio

context variable

_AnonymousUser — Mon, 26 Oct 2015 23:23:47 GMT

Hi,
I am working on incremental Talend Job and looking for Incremental Extract logic. I did the following steps to achieve this (DB:- Oracle)
Step1. Took Max (HEADER_ID) FROM TARGET_TABLE. (header_id datatype is Number)
Step2. Then I took tJavaRow component for to assign Step1 value context variable. My Context variable name is HEADER_ID (Datatype is BigDecimal) So the assignment syntax is as below
context.HEADER_ID=input_row.HEADER_ID;
Step3. Next I have my source extract component and have below Query.
"select C1, C2, HEADER_ID FROM SOURCE_TABLE WHERE HEADER_ID > '+context.HEADER_ID+'"
Step4. Then i have tMap
Ste5. Then i have Target Objects
I am getting Error message on Step3. like '(java.sql.SQLSyntaxErrorException: ORA-01722: invalid number ....)
It seems that there is datatype mismatch but I am not sure where to Fix.
Regards
Saket Krishna

Re: context variable

Anonymous — Tue, 27 Oct 2015 03:37:08 GMT

Hi Saket Krishna,

Can you please upload screenshots of your job settings? It will be useful for us to find out the problem.

Best regards
Sabrina

Re: context variable

Anonymous — Tue, 27 Oct 2015 18:26:25 GMT

Hi Sabrina,
Uploaded screenshots of the job. For your information I created this job to look how we can perform incremental extract logic. So focus is only on extraction not on other logic.
Regards
Saket Krishna

Re: context variable

Anonymous — Thu, 29 Oct 2015 17:45:20 GMT

Hi Sabrina,
Did you get chance to look on the screenshots attached.
Thanks
Saket Krishna

Re: context variable

Anonymous — Fri, 30 Oct 2015 08:25:07 GMT

Hi,

Can you upload again the screenshots you wanted to show, please? For some reason it didn't make it to your post.

Best regards
Sabrina

Re: context variable

Anonymous — Fri, 30 Oct 2015 17:47:35 GMT

Hi Sabrina,
Attaching screen .zip file again kindly have a look.
Thanks
Saket Krishna

Re: context variable

Anonymous — Sat, 31 Oct 2015 10:15:01 GMT

Please upload images (jpg, png o gif).

I don't find screen.zip

Best regards,

Alfonso Borre

Re: context variable

Anonymous — Mon, 02 Nov 2015 21:51:24 GMT

Hi,
Uploaded Screenshots in .png format.
Regards
Saket Krishna

Re: context variable

Anonymous — Tue, 03 Nov 2015 23:09:42 GMT

Hi,

I am not sure if there is any issue with the uploaded screenshots. Meanwhile I mentioning below the issue

I have below SQL in tOracleInput. Where Creation Date is Date column and context.CREATION_DT is the context variable defined as date datatype.

[font=Times New Roman] Select C1, C2, C3 FROM <TABLE> WHERE <TABLE>.CREATION_DATE > TO_DATE('" + context.CREATION_DT + "','dd - MM - yyyy').[/font]

But above SQL is throwing error like “ORA-01858 : a non-numeric character was found where numeric was expected"

Thanks

[size=3][font=Times New Roman] Saket Krishna [/font][/size]

Re: context variable

Anonymous — Wed, 04 Nov 2015 11:12:05 GMT

Hi,
A column defined as String and am trying to handle null by adding String function like StringHandling(TRIM(Column).equals(""). But it is giving me "Null Pointer exception" error.
Chitra.

Re: context variable

Anonymous — Thu, 05 Nov 2015 09:50:36 GMT

Hi [size=3][font=Times New Roman] Saket Krishna,[/font][/size]
[size=3][font=Times New Roman] Did you use the "date" (your context variable is a date) as part of a SQL statement in tOracleInput?[/font][/size]

Best regards
Sabrina

Re: context variable

Anonymous — Thu, 05 Nov 2015 09:58:45 GMT

Hi Chitra

An "Null Pointer Exception" will occur if your variable is null. Did you get this error in tMap component?
You need to handle the null value, for example;
row1.name==null?value if it is null:do your further processing
Best regards
Sabrina

Re: context variable

Anonymous — Thu, 05 Nov 2015 23:48:48 GMT

Hi Sabrina,
Yes My context variable is defined as Date datatype and the SQL in the tOracleInput is just as below in where condition.
Select C1, C2, C3 FROM <TABLE> WHERE <TABLE>.CREATION_DATE > TO_DATE('" + context.CREATION_DT + "','dd - MM - yyyy').
I was thinking if possible then I can share my screen with you so that you can have a close look on the code. You can reach me on skrishna@ctrworld.com
Thanks
Saket Krishna

Re: context variable

Anonymous — Fri, 06 Nov 2015 03:24:12 GMT

Hi Saket Krishna,

The sql statement should be String not date.
You can use the TalendDate.formatDate() method to format the data.

Best regards
Sabrina