Advanced
The Advanced tab has the following fields:
Field |
Global Var? |
Description |
Override Transaction Behavior |
Yes |
Overrides the default behavior of a transaction group. If this activity is in a transaction group, the activity is normally committed or rolled back with the other transactional activities. If this check box is selected, this activity is not part of the transaction group and is committed when it completes. Checking this option uses a separate database connection to perform the activity and commit the SQL statement. |
Interpret Empty String as Null |
No |
Specifies how empty strings in the activity’s input elements should be handled. When the field is checked, nulls are sent to the database where empty strings are supplied. When the field is unchecked, empty strings are treated as zero-length strings. Whether you use this field or not, you can still use XPath to set input elements explicitly to null. Note: Many databases treat empty strings and nulls as the same, so this field does not affect how the database interprets empty strings.
|
Batch Update |
No |
Checking this field signifies you want to perform multiple statements by supplying an array of records as input to the activity where each record matches the prepared parameters for the statement. The statements are performed in one batch at the end of the activity’s execution. This field is only meaningful if there are prepared parameters in the SQL statement (see Prepared Parameters). If this field is not checked, the expected input is the list of prepared parameters for the statement (no array of records). Some database drivers may not support batch updates. A JDBCSQLException is thrown if the database driver does not support batch updates. |