If I have 2 tOracleConnection to connect to a source DB and a target DB tRunJob----onSubJobError--->tDie----If(order:1)-->tOracleClose_1 -----If(order:2)-->tOracleClose_2 Is this a good way to making sure both connections are closed when the job Die? Should I use onComponentOK on the tDie? Thanks.
Hi
The tDie component is used to shut down the job itself.
You might create job like this.
tRunJob----onSubJobError----If(order:1)-->tOracleClose_1
-----If(order:2)-->tOracleClose_2
Remember not to check "Die on child error" on tRunJob.
Regards,
Pedro
I have an issue i.e i am returning value from a stored procedure and depending upon that value i have to trigger the mail, Y =trigger,N=do not trigger,how to do that through runif trigger,procedure is returning proper values(Y/N). I am connecting toraclesp component with runif to tsendmail but no results ,please guide.
I have an issue i.e i am returning value from a stored procedure and depending upon that value i have to trigger the mail, Y =trigger,N=do not trigger,how to do that through runif trigger,procedure is returning proper values(Y/N). I am connecting toraclesp component with runif to tsendmail but no results ,please guide.
According to your request description, the job design looks like:
tOracleSP--main--tJavaRow--runIf-->tSendMail
on tJavaRow:
if(input_row.value.equals("Y")){ //value is the column name on tOracleSP, it stores the return value of SP)
globalMap.put("isSend", true);
}
if(input_row.value.equals("N")){
globalMap.put("isSend",false);
}
set the condition of runIf as:
(Boolean)globalMap.get("isSend")
Thanks for the reply Shong,but now the error is "Exception in component tJavaRow_1 java.lang.NullPointerException..."
the flow is oralceSp ->(row)->tjavarow->(if)->tsendmail,now depending on if condition the send mail is to be executed.code in javarow is what you gave above and if(row) also what you have provided,reason i found was that the if(row) condition is executed before and tjavarow afterwards,i also saw this in code that get values is before put value hence the error,how to resolve this,please guide.
Hi
It is a NullPointerException here, do you always have a return value "Y" or "N"? Do it return null? If so, try this code on tJavaRow:
if(input_row.value.equals("N")||input_row.value==null){
globalMap.put("isSend",false);
}else{
globalMap.put("isSend", true);
}
Best regards
Shong
