Sending Mail with tSendMail with tJava Condition

[tmiles-vfpng]

I would like to trigger an email when the sql executed returns null rows. However, triggering the email from tJava is proving troublesome. Talend Data Integration Talend Studio 

[tmiles-vfpng · Accepted solution]

Solved the issue. Refer to the java code. 

// Process rows

while (input_row != null) 

{

    if (input_row.TRNCNT > 1) 

    {

    System.out.println("Systems OK!");

        context.rowsProcessed = true;

        return;

    }

return;

}

// Check if any rows were processed

if (!context.rowsProcessed) 

{

System.out.println("No Transactions");

    globalMap.put("sendEmail", false);

    return;

}