Output

The output for the activity is the following.

Output Item

Datatype

Description

resultSet

complex

The root class for the output of the JDBC Query activity. This class contains all output items for the activity.

Record

complex

The result of the database query. The contents of the Record element depends upon the columns returned by the query.

lastSubset

boolean

This element only appears when the Process In Subsets field on the Advanced tab is checked. This field is set to true when the current subset of records being processed is the last subset of records. You can use this element to create an XPath expression to determine when a Repeat Until True loop that is processing records in batches should stop processing. For example:

$JDBCQuery/resultSet/lastSubset = "true"

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