Output

The output for the activity is the following:

Output Item

Datatype

Description

noOfUpdates

integer

The number of updates performed by the statement specified on the Configuration tab.

This element can also return -2 that indicates, in the event of a batch update, that the updates were successful, but it is unknown how many updates were performed.

Elapsed Time

long

This field displays the time taken for the execution of the activity in milliseconds.

This is an optional element that appears only when the property java.property.bw.activity.output.stats.elapsedTime.JDBCUpdateActivity is set to true in designer.tra. For run-time, set the property to true in the bwengine.tra file. By default, the property is set to false.

If set in the design-time, this property must be carried forward to the run-time; else it can cause run-time errors.

Enabling this property causes additional performance overhead. Hence, it is recommended that you use this property only when this information is to be consumed by some other ActiveMatrix BusinessWorks activity. Also, it is recommended that this property be used only in a non-production environment as a diagnostic tool and the property be turned off at run-time.

You can turn off the property and not calculate the elapsed time at run-time by setting the property java.property.bw.activity.output.stats.elapsedTime.turnoff in the bwengine.tra file. However, note that setting this property turns off the calculation of elapsed time at run-time for all the JDBC activities.