topic Re: [resolved] Calling Talend Job in Java class and pass context variable value in Talend Studio

[resolved] Calling Talend Job in Java class and pass context variable value

Anonymous — Sat, 16 Nov 2024 11:57:30 GMT

Hi, I have created a Talend Job for reading 2 CSV files and save to 2 database tables based on context variable value. The CSV headers and Table column are same. Only difference is values. So I thought of creating Talend Job.
My CSV files are "inv_ppl1.csv" and "inv_ppl2.csv"
Database tables are "inv_ppl1_flat" and "inv_ppl2_flat"
Context variable is "people" with values "ppl1 and "ppl2" . When I run the Job in Talend it is working fine.

I exported the Job as Zip file as specified in
https://help.talend.com/search/all?query=Calling+a+Talend+Job+from+an+external+Java+application&content-lang=en
I unzipped it. I created a Java project in eclipse. with main method. After that I have added all the JARs to the project. I copied the folder containing properties file. But the directory contains ppl1.prperties and ppl2.properties files only. There is no default.properties file link mentioned in the above link. (I am using TOS for Data Integration... Not Enterprise)
I edited my main method for context variable like in the link

import talenddemo.flatfiletodb_0_1.flatfiletodb; 
public class TalendExample {
  
/**
* @param args
*/
public static void main(String[] args) {
flatfiletodb talendJob = new flatfiletodb();
int nb_line=2;
String name="ppl2";
String [] context=new String[] {"--context_param nb_line=" nb_line,"--context_param name=" name};
talendJob.runJob(context);
}
}

But it is not working for me. "ppl1" is the default one. so it is reading from first file and saving to its corresponding table. I have passed "ppl2",
But its not working.

Re: [resolved] Calling Talend Job in Java class and pass context variable value

Anonymous — Tue, 30 Jul 2013 08:22:01 GMT

Hi
I think "ppl1" and "ppl2" are two context names in your case, and "ppl1" is the default context, if you want to change the default context, try this code:

String [] context=new String[] {"--context=ppl2 --context_param nb_line="+nb_line,"--context_param name="+name};

Shong

Re: [resolved] Calling Talend Job in Java class and pass context variable value

Anonymous — Tue, 30 Jul 2013 08:33:17 GMT

I tried the following

int nb_line=2;
String name="ppl2";
String [] context=new String[] {"--context="+name+" --context_param nb_line="+nb_line,"--context_param name="+name};

And I am getting following error

Could not find the context ppl2 --context_param nb_line=2
/home/sujay/talend/FlatFiles/null/inv_null.csv (No such file or directory)

Both context variable name and its value are smae. For ppl1 its value is ppl1, same like ppl2 also. And what does that nbline means? Why do we need to give that?
EDIT
My main() method is in

src/com/talenddemoj/demojob

And context files are in

src/talenddemojob/flatfiletodb_0_1/contexts

Re: [resolved] Calling Talend Job in Java class and pass context variable value

Anonymous — Tue, 30 Jul 2013 09:05:24 GMT

Hi
nb_line is just a context variable in the tutorial, if you don't have a context variable called nb_line, remove it from your code. A screenshot of the context variables of your job will be helpful for us to understand your problem.
Shong

Re: [resolved] Calling Talend Job in Java class and pass context variable value

Anonymous — Tue, 30 Jul 2013 09:23:04 GMT

Thanks. It is working now
I removed context_parm nb_line

String name="ppl2";
tring [] context=new String[] {"--context="+name,"--context_param name="+name};

Re: [resolved] Calling Talend Job in Java class and pass context variable value

Anonymous — Tue, 30 Jul 2013 09:36:42 GMT

Thanks. It is working now
I removed context_parm nb_line
String name="ppl2";
tring [] context=new String[] {"--context="+name,"--context_param name="+name};

Cool, glad to see you get it working now.
Shong