I'm looking for log successes and errors after using a tDBRow (see screenshot).
The problem is that during the first iteration, errors and successes are both not null (next iteration are ok).
Here is the code of the first tJava :
if (errors == null) {
System.out.println("################## Success");
}
System.out.println("---------------" + (String) globalMap.get("currentTableToFlush"));
System.out.println(errors == null ? "Errors is null" : "Errors is not null");
System.out.println(successes == null ? "Successes is null" : "Successes is not null");
of the second one :
if (errors != null) {
System.out.println("################## Error");
}
and the result ("null" database name is volontary used to generate an error) :
############## DELETE FROM null.wrk_import
---------------wrk_import
Errors is not null
Successes is not null
################## Error
############## DELETE FROM null.wrk_deviationexplanation
---------------wrk_deviationexplanation
Errors is not null
Successes is null
################## Error
############## DELETE FROM null.wrk_projectimprovment
---------------wrk_projectimprovment
Errors is not null
Successes is null
################## Error
One more question : is there a way to use a computed parameter in tWarn priority ?
What is the success message in the first iteration? Did you try using a tDBOutput component instead? You could also keep a counter and just handle the first row specially.
I don't think you can set the priority in a tWarn with a variable.
