Output

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

Output Item

Datatype

Description

JavaConnectionAccessor

Java Object

A Java object reference to a JavaConnectionAccessor object. This object can be passed as input to a Java activity where custom Java code can use the connection to perform database operations.

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