| 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 joining action that operations can take for transactions. | JOIN_IF_POSSIBLE |
|
| SQL Query Text | String | The text of the SQL query to execute | ||
| Script Path | String | Specifies the location of a file to load. The file can point to a resource on the classpath, or on a disk. | ||
| 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 | Sets the limit for the maximum number of rows that any ResultSet object generated by this message processor can contain for the given number. If the limit is exceeded, the excess rows are silently dropped. | ||
| Target Variable | String | The name of a variable to store the operation's output | ||
| Target Value | String | An expression to evaluate against the operation's output and store the expression outcome in the target variable | #[payload] |
|
| Reconnection Strategy | Reconnect Reconnect Forever |
A retry strategy in case of connectivity errors |