sql endpoint

SQL Endpoint. Endpoint URI should contain valid SQL statement, but instead of question marks (that are parameter placeholders), sharp signs should be used. This is because in camel question mark has other meaning.

Name	Type	Description
allowNamedParameters	boolean
alwaysPopulateStatement	boolean
batch	boolean	Enables or disables batch mode
dataSource	javax.sql.DataSource	Sets the DataSource to use to communicate with the database.
dataSourceRef	java.lang.String	Sets the reference to a DataSource to lookup from the registry, to use for communicating with the database.
maxMessagesPerPoll	int	Sets the maximum number of messages to poll
noop	boolean
onConsume	java.lang.String
onConsumeBatchComplete	java.lang.String
onConsumeFailed	java.lang.String
outputClass	java.lang.String
outputHeader	java.lang.String	Store the query result in a header instead of the message body. By default, outputHeader == null and the query result is stored in the message body, any existing content in the message body is discarded. If outputHeader is set, the value is used as the name of the header to store the query result and the original message body is preserved.
outputType	org.apache.camel.component.sql.SqlOutputType
parametersCount	int
prepareStatementStrategy	org.apache.camel.component.sql.SqlPrepareStatementStrategy
processingStrategy	org.apache.camel.component.sql.SqlProcessingStrategy
separator	char

sql consumer

Name	Type	Description
breakBatchOnConsumeFail	boolean	Sets whether to break batch if onConsume failed.
expectedUpdateCount	int	Sets an expected update count to validate when using onConsume. @param expectedUpdateCount typically set this value to `1` to expect 1 row updated.
onConsume	java.lang.String	Sets a SQL to execute when the row has been successfully processed.
onConsumeBatchComplete	java.lang.String
onConsumeFailed	java.lang.String	Sets a SQL to execute when the row failed being processed.
routeEmptyResultSet	boolean	Sets whether empty resultset should be allowed to be sent to the next hop. defaults to false. So the empty resultset will be filtered out.
useIterator	boolean	Sets how resultset should be delivered to route. Indicates delivery as either a list or individual object. defaults to true.