Defines a MessageStore (and MessageGroupStore) backed by a database. Reference to a data source to use to access the database. Either this or the jdbc-operations must be specified (but not both). Reference to a JdbcOperations. Either this or the data-source must be specified (but not both). Unique string to use as a partition for the data in this store, so that multiple instances can share the same database tables. The default is "DEFAULT". Prefix for the table names in the database (e.g. so that a schema can be specified, or to avoid a clash with other tables). The default is "INT_". Defines an inbound Channel Adapter for polling a database. An update query to execute when a message is polled. If the poll is in a transaction then the update will roll back if the transaction does. An update query to execute when a message is polled. If the poll is in a transaction then the update will roll back if the transaction does. The update can also be specified as a nested element. Flag to indicate whether the update query should be executed per message, or per row (in the case that a message contains multiple rows). Limits the number of rows extracted per query (otherwise all rows are extracted into the outgoing message). Channel to which polled messages will be sent. Flag to indicate that the poller should start automatically on startup (default true). Reference to a SqlParameterSourceFactory. The input is the result of the query. The default factory creates a parameter source that treats a List in a special way: the parameter name is used as an expression and projected onto the list, so for instance "update foos set status=1 where id in (:id)" will generate an in clause from the properties "id" of the input list elements. Reference to a static SqlParameterSource for the SELECT query used for polling. If that query has placeholders (e.g. "SELECT * from FOO where KEY=:key") they will be bound from this source by name. Defines an outbound Channel Adapter for updating a database. Reference to a SqlParameterSourceFactory. The input is the whole outgoing message. The default factory creates a bean property parameter source so the query can specify named parameters like :payload and :headers[foo]. Channel from which messages will be output. When a message is sent to this channel it will cause the query to be executed. Flag to indicate whether primary keys are generated by the query. Flag to indicate that the poller should start automatically on startup (default true). Specifies the order for invocation when this endpoint is connected as a subscriber to a SubscribableChannel. Defines an outbound Channel Gateway for updating a database in response to a message on the request channel and getting a response on the reply channel. The response can be created from a query supplied here, or (if keys-generated="true") can be the primary keys generated from an auto-increment, or else just a count of the number of rows affected by the update. The response is in general a case insensitive Map (or list of maps if multi-valued), unless a select query and a row-mapper is provided. If the update count is returned then the map key is "UPDATE". An update query to execute when a message is received. If this is in a transaction then the update will roll back when the transaction does. An update query to execute when a message is received. If this is in a transaction then the update will roll back when the transaction does. The update can also be specified as a nested element. When using a select query, you can set a custom limit regarding the number of rows extracted. Otherwise by default only the first row will be extracted into the outgoing message. If set to '0' all rows are extracted. Reference to a SqlParameterSourceFactory. The input is the whole outgoing message. The default factory creates a bean property parameter source so the query can specify named parameters like :payload and :headers[foo]. Reference to a SqlParameterSourceFactory. The input is the whole outgoing message. The default factory creates a bean property parameter source so the query can specify named parameters like :payload and :headers[foo]. The receiving Message Channel of this endpoint. Message Channel to which replies should be sent, after receiving the database response. Flag to indicate whether primary keys are generated by the query. If they are then they can be used as a reply payload instead of providing a select query. A single valued result is extracted before returning (the usual case), so the payload of the reply message can be a Map (column name to value) or a list of maps. Flag to indicate that the poller should start automatically on startup (default true). Specifies the order for invocation when this endpoint is connected as a subscriber to a SubscribableChannel. Reference to a data source to use to access the database. Either this or the simple-jdbc-operations must be specified (but not both). Reference to a JdbcOperations. Either this or the data-source must be specified (but not both). A select query to execute when a message is polled. In general the query can return multiple rows, because the result will be a List (of type determined by the row mapper). A select query to execute when a message is polled. In general the query can return multiple rows, because the result will be a List (of type determined by the row mapper). The query can also be specified as a nested element. Reference to a row mapper to use to convert JDBC result set rows to message payloads. Optional with default that maps result set row to a map (column name to column value). Other simple use cases can be handled with out-of-the box implementations from Spring JDBC. Others require a custom row mapper. Defines an outbound Channel Adapter for updating a database using stored procedures. Reference to a SqlParameterSourceFactory. Channel from which messages will be output. When a message is sent to this channel it will cause the query to be executed. Specifies the order for invocation when this endpoint is connected as a subscriber to a SubscribableChannel. Indicates whether this procedure's return value should be included. Defines an Outbound Channel Gateway for updating a database using a stored procedure. The response of the stored procedure is used to populate the Message for the reply channel. Reference to a SqlParameterSourceFactory. The input is the whole outgoing message. The default factory creates a bean property parameter source so the query can specify named parameters like :payload and :headers[foo]. If "true", a SQL Function is called. In that case the "stored-procedure-name" attribute defines the name of the called function. The receiving Message Channel of this endpoint. Message Channel to which replies should be sent, after receiving the database response. Specifies the order for invocation when this endpoint is connected as a subscriber to a SubscribableChannel. Indicates the procedure's return value should be included in the results returned. Defines an inbound Channel Adapter for polling a database using a stored procedure or function. If "true", a SQL Function is called. In that case the "stored-procedure-name" attribute defines the name of the called function. Channel to which polled messages will be send. If the stored procedure or function does not return any data, the payload of the Message will be Null. Identifies the underlying Spring bean definition, which is an instance of either 'EventDrivenConsumer' or 'PollingConsumer', depending on whether the component's input channel is a 'SubscribableChannel' or 'PollableChannel'. The name of the stored procedure. If the "is-function" attribute is "true", this attributes specifies the function name. Reference to a data source to use to access the database. Flag to indicate that the poller should start automatically on startup (default true). If true, the JDBC parameter definitions for the stored procedure are not automatically derived from the underlying JDBC connection. In that case you must specify all Sql parameter definitions explicitly using the 'sql-parameter-definition' sub-element.