topic Re: Null pointer exception while passing variable from Main job to Joblet in Talend Studio

Null pointer exception while passing variable from Main job to Joblet

BA621858188 — Thu, 09 Mar 2023 04:46:57 GMT

Hi All,

I am facing an issue while passing the main job variable to Joblet.

Joblet design -

tprejob --> tdbconnection

Input (taking from the main job) ---> tjava (to store the input in context) ---> tdbrow (calling procedure) ---> (obsubjobok) ---> Triggeroutput

Main job design -

Fixedflowinput(which is having variable that will pass as Input to Joblet) ---> calling above joblet---> onsubjobok ---> tjava(to print msg)

Issue-

I am creating one variable name and "abc" as value, in tfixedflowinput of main job and that I need to pass in Store procedure in joblet but am facing an error as "Null pointer exception". It is not able to pass that variable to joblet.

Can anyone help me on this?

using variable in joblet as below:

context.name=input_row.name;

can anyone help me on this?

Re: Null pointer exception while passing variable from Main job to Joblet

Anonymous — Thu, 09 Mar 2023 07:49:12 GMT

using tJavaRow replace of tJava in joblet.

Regards

Shong

Re: Null pointer exception while passing variable from Main job to Joblet

BA621858188 — Thu, 09 Mar 2023 09:13:48 GMT

@Shicong Hong

I am using tjavarow only in my joblet. it was typo by mistake.

Re: Null pointer exception while passing variable from Main job to Joblet

Anonymous — Fri, 10 Mar 2023 02:19:01 GMT

I am not able to reproduce the issue. You need to do more testing or debug the java code of Job to find out where the NPE was thrown, for example, print the value of context variable on tJavaRow, if you have the expected value, means the value was passed correctly from main job.

context.name=input_row.name;

System.out.println(context.name);

Re: Null pointer exception while passing variable from Main job to Joblet

BA621858188 — Fri, 10 Mar 2023 02:33:19 GMT

@Shicong Hong ,

I have used different method and issue is solved now.