The JDBC transport allows data to be retrieved from and written to any database that supports a JDBC driver. It also supports invoking stored precedures. JDBCJDBC Transport The JDBC connector is used to configure the shared behavior for JDBC endpoints that reference the connector. DataSources, Queries, and Polling Intervals are some of the key properties configured on the JDBC connector. The factory that determines the execution strategy based on the SQL provided.Defines a set of queries. Each query has a key and a value (SQL statement). Queries are later referenced by key. The delay in milliseconds that will be used during two subsequent polls to the database. This is only applied to queries configured on inbound endpoints. Reference to the JDBC DataSource object. This object is typically created using Spring. When using XA transactions, an XADataSource object must be provided. Reference to the QueryRunner object, which is the object that actually runs the Query. This object is typically created using Spring. Default is org.apache.commons.dbutils.QueryRunner. Reference to the ResultSetHandler object, which is the object that determines which java.sql.ResultSet gets handled. This object is typically created using Spring. Default is org.apache.commons.dbutils.handlers.MapListHandler, which steps through the ResultSet and stores records as Map objects on a List. Whether each database record should be received in a separate transaction. If false, there will be a single transaction for the entire result set. Default is true. The timeout in seconds that will be used as a query timeout for the SQL statement Receives or fetches data from a database. You can reference SQL select statements or call stored procedures on inbound endpoints. Statements on the inbound endpoint get invoked periodically according to the pollingInterval. Statements that contain an insert, update, or delete are not allowed. The timeout in seconds that will be used as a query timeout for the SQL statement You can reference any SQL statement or call a stored procedure on outbound endpoints. Statements on the outbound endpoint get invoked synchronously. SQL select statements or stored procedures may return output that is handled by the ResultSetHandler and then attached to the message as the payload. The timeout in seconds that will be used as a query timeout for the SQL statement The timeout in seconds that will be used as a query timeout for the SQL statement Assigns a name (key) to a query (value). Queries are then referenced by key, such as jdbc://myQuery for ]]>The key of the query to use.The delay in milliseconds that will be used during two subsequent polls to the database. Standard Mule transaction configuration. See [Transaction Management] for usage details. Override the default SqlStatementStrategyFactory. Determines the execution strategy based on the SQL provided. The reference to the jdbcConnector The name of the store The key for the insert query in the connector The key for the select query in the connector The key for the delete query in the connector