topic Re: conditional job in Talend Studio

conditional job

Anonymous — Wed, 17 Apr 2019 09:56:06 GMT

hi gays,

i work for project automation migration data from database to another .

i create 3 job

job 1 for migration data from Sql server to oracle

job 2 for migration data from oracle to oracle

i want to create a job parent for test ;

if CMD line content the context param of job 1 then run job 1

else run job 2

Re: conditional job

Anonymous — Wed, 17 Apr 2019 10:20:06 GMT

The tContextLoad needs to be used as shown in the example here ...(https://help.talend.com/reader/jomWd_GKqAmTZviwG_oxHQ/xH2TyYr_AmQnKwOYlqVCvA).

If you are passing the value to your job using the CMD line, you do not need to worry about the tContextLoad. Simply use a tJava where your tContextLoad component is and link the RunIfs from there.

Re: conditional job

Anonymous — Wed, 17 Apr 2019 10:26:13 GMT

thinks for your response

i can parse parameter database with tjava to child job ??

Re: conditional job

Anonymous — Wed, 17 Apr 2019 10:31:14 GMT

The tJava is used simply as a dummy start component. You are really just relying on the RunIf links.

Re: conditional job

Anonymous — Thu, 18 Apr 2019 09:34:45 GMT

hello,

i create the job with component tjava

java Code in tjava:

String contextsqlserver_Database;

if (contextsqlserver_Database != null){
globalMap.put("isNull", true);
}

else {
globalMap.put("isNull", false);
}

i want to test if contextsqlserver_database is parsed in cmd line with value , the job executed is job 1

the condition in run if 1

(Boolean)globalMap.get("isNull")==true

else

run job 2

the issus : contextsqlserver_database may not have been initialized

have you another solution

thanks

jobgénirique.jpg

Re: conditional job

Anonymous — Thu, 18 Apr 2019 09:42:57 GMT

How are you passing the context variable in the command-line? This seems to be the problem.

What is your requirement for passing the context variable, how are you starting the job and can you use other functionality to do this?

Re: conditional job

Anonymous — Thu, 18 Apr 2019 09:46:15 GMT

hi,

because i work for automation project and i want create a pipeline for migration data from

sqlserver-------> oracle

oracle ------> oracle

and i want to insert the command line in scriptshell

Re: conditional job

Anonymous — Thu, 18 Apr 2019 10:22:31 GMT

I understand that, but you said that you were not sure the context variable value was being passed correctly. How are you passing the context variable in the command-line?

Re: conditional job

Anonymous — Thu, 18 Apr 2019 10:47:04 GMT

i build a job and run this commande :

databaseTransfer_run --context_param contextsqlserver_Port=............. --context_param contextsqlserver_Database= ..... --context_param contextsqlserver_Schema=..... --context_param contextsqlserver_Password=....... --context_param contextsqlserver_Login=........ --context_param contextsqlserverr_Server=........ --context_param OracleConnection_Port=........ --context_param OracleConnection_Sid= ........... --context_param OracleConnection_Password= ........ --context_param OracleConnection_Login=............. --context_param OracleConnection_Server=.............--context_param OracleConnection_Schema= .................

Re: conditional job

Anonymous — Thu, 18 Apr 2019 11:27:36 GMT

OK, that looks like it should be working. The next thing to test is that the values are getting through. To do this, add some code to your tJava to print out the values of your context variables. For example,....

System.out.println("Context named Test ="+context.Test);

This will show whether the values are reaching your job.

Re: conditional job

Anonymous — Thu, 18 Apr 2019 11:33:01 GMT

I'm an idiot. Sorry. I've just noticed your logic. The context variables are not going to be null. Try creating an empty String context variable. It won't be null, it will be treated like an empty String "". That is why your logic is not working.

Re: conditional job

Anonymous — Thu, 18 Apr 2019 11:41:26 GMT

i whrite this code in tjava:

System.out.println("contextsqlserver_Database :"+context.contextsqlserver_Port);

issus : contextsqlserver_Port cannot be resolved or is not a field

i try this solution ( screenshot attached) with tloadcontext

and i insert the value of parameter in file.dat

and same problem

Sans titre1.jpg

Re: conditional job

Anonymous — Thu, 18 Apr 2019 11:46:46 GMT

That means that the context variable does not exist in the job. Check your context variables tab. A context variable must be configured in each job it is used.

Re: conditional job

Anonymous — Thu, 18 Apr 2019 11:51:32 GMT

ok thinks for your support

Re: conditional job

Anonymous — Thu, 18 Apr 2019 12:38:12 GMT

No problem 🙂