"JDBC Query" Operation

This operation allows to execute an SQL query using a JDBC driver.

General

Connection

This corresponds to the JDBC connection to use.

Parameter Definitions

This allows to manually define or (re)generate the query parameter list. Automated updating of this list can be enabled.

Column Definitions

This allows you to (re)generate the list of columns that will be output by the query. Automated updating of this list can be enabled.

Statement

This corresponds to the text of the SQL query, which may be parameterized.

Input

This allows to specify the parameter values ​​for the query.