| Name | Type | Description | Default Value | Required |
|---|---|---|---|---|
| Configuration | String | The name of the configuration to use | x | |
| Transactional Action | Enumeration, one of: ALWAYS_JOIN JOIN_IF_POSSIBLE NOT_SUPPORTED |
The type of join action that operations can take regarding transactions | JOIN_IF_POSSIBLE |
|
| Streaming Strategy | Repeatable In Memory Iterable Repeatable File Store Iterable non-repeatable-iterable |
Configure to use repeatable streams | ||
| Query Timeout | Number | Indicates the minimum amount of time before the JDBC driver attempts to cancel a running statement. By default, no timeout is used. | 0 |
|
| Query Timeout Unit | Enumeration, one of: NANOSECONDS MICROSECONDS MILLISECONDS SECONDS MINUTES HOURS DAYS |
A time unit that qualifies the #queryTimeout. Values specified in nanoseconds, microseconds, or milliseconds are rounded to seconds. |
SECONDS |
|
| Fetch Size | Number | Indicates how many rows to fetch from the database when rows are read from a ResultSet. | 10 | |
| Max Rows | Number | The maximum number of rows that any ResultSet object generated by this message processor can contain. If the limit is exceeded, the excess rows are silently dropped. | ||
| SQL Query Text | String | The text of the SQL query to execute | x | |
| Parameter Types | Array of Parameter Type | Enables you to optionally specify the type of one or more of the parameters in the query. If provided, you're not required to reference all of the parameters; but you cannot reference a parameter that is not present in the input values. | ||
| Input Parameters | Object | A map in which keys are the name of an input parameter to be set on the JDBC prepared statement. Each parameter should be referenced in the SQL text using a colon prefix (for example: where id = :myParamName). The map's values will contain the actual assignation for each parameter. | ||
| Target Variable | String | Name of the variable in which to store the operation's output | ||
| Target Value | String | Expression that evaluates the operation's output. The expression outcome is stored in the target variable. | #[payload] |
|
| Reconnection Strategy | Reconnect Reconnect Forever |
A retry strategy in case of connectivity errors. | ||
| #### Output | ||||
| Type | Object | |||
| ---- | ----- |