JDBC template execution parameters

You use execution parameters to create the input process script in the Preprocessing form.

For detailed descriptions of the JDBC command fields, see the table in Configure the JDBC execution command.
Note: You must use the executionParam. prefix with all variables in this table.
Table 1. JDBC execution parameters
Name Variable Type Usage
JDBC connection jdbc_connection Reference Selected JDBC connection. See Create a JDBC connection for details.
Credential fixed_credential_id Reference Name of the JDBC credential to use. For more information, see JDBC credentials.
SQL statement sql_statement String SQL statement executed by the activity.
Maximum rows maximum_rows Integer Maximum number of rows to return from the SQL statement or stored procedure.
Maximum payload size (KB) maximum_payload_size Integer Maximum allowable payload size to return from the SQL statement or stored procedure.
Connection timeout connection_timeout Integer Length of time to wait for connection to occur.
Query timeout query_timeout Integer Length of time to wait for the query to return results.
Stored procedure stored_procedure Boolean Selects whether to use a stored procedure rather than an SQL statement.
Stored procedure name stored_procedure_name String Names the stored procedure to use.
Stored procedure variables stored_procedure_variables Array of JavaScript objects Lists the variables from the selected stored procedure.