Parameters

Name	Type	Description	Default Value	Required
Configuration	String	The name of the configuration to use		x
SQL Query Text	String	The text of the SQL query to execute		x
Transactional Action	Enumeration, one of: ALWAYS_JOIN JOIN_IF_POSSIBLE NOT_SUPPORTED	The type of joining action that operations can take regarding transactions	JOIN_IF_POSSIBLE
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