Output

The output for the activity is dependent upon the output parameters of the database procedure.

Output Item

Datatype

Description

outputSet

complex

The output of the database procedure. The datatype contained in this element varies depending upon what the database procedure returns.

unknownResultSets

complex

The output of the database procedure may return other result sets. These result sets are returned in this output item as an XML string. Create a Schema resource to describe these result sets, then use the Parse XML activity to parse the XML based on the schema. You can then use the parsed output in subsequent activities.

For a more detailed description of this procedure, see TIBCO ActiveMatrix BusinessWorks™ Release Notes.

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.JDBCCallActivity 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.