Defines the configuration parameters for the JDBC connection.
The expression used to obtain the value used to calculate parameters. Default is
empty, so parameters are calculated from the payload.
The enricher expression used to enrich the current message with the result
of the SQL processing.
Indicates how the message processor handles transactions.
Indicates the minimum amount of time in seconds before the JDBC driver attempts to cancel a running statement. No timeout is used by default.
Selects data from a database.
Indicates if result sets must be returned as an iterator or as a list of maps.
Indicates how many rows to fetch from the database when rows are read from a resultSet. This property is required when streaming is true; in that case a default value (10) is used.
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.
Updates data in a database.
Indicates whether or not a bulk update is requested. When true, payload is required to be a
collection and a bulk update executes for each item in the collection.
Deletes data from a database.
Inserts data into a database.
Indicates whether or not a bulk update is requested. When true, payload is required to be a
collection and a bulk update executes for each item in the collection.
Enables execution of DDL queries against a database.
Updates data in a database.
The location of a file to load. The file can point to a resource on the classpath or on a disk.
Executes a SQL statement in a database.
Indicates if result sets must be returned as an iterator or as list of maps.
Indicates how many rows to fetch from the database when rows are read from a resultSet. This property is required when streaming is true; in that case a default value (10) is used.
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.
The type of action the transaction should take, one of the following:
ALWAYS_JOIN - Always expects a transaction to be in progress when a message is received. If there is no
transaction, an exception is thrown.
JOIN_IF_POSSIBLE - Join the current transaction if one is available. Otherwise, no transaction is
created.
NOT_SUPPORTED - Execute outside any existent transaction.
Identifies the query so that other elements can reference it.
Defines a SQL query that can contain inline parameters definitions.
Location of a file that defines a query in a separate file, useful when the queries are too complex. The file can point to a resource on the classpath or on a disk.
The name of the output parameter.
Parameter type name.
The name of the output parameter.
The value of the parameter.
Parameter type name.
The name of the input parameter.
The value of the parameter.
Parameter type name.
The name of the template input parameter.
The default value of the parameter.
Parameter type name.
The name of the input parameter.
The default value of the parameter.
Data types for the fields and parameters.
Indicates when to make auto-generated keys available for retrieval.
Comma-separated list of column indexes that indicates which auto-generated keys to make
available for retrieval.
Comma separated list of column names that indicates which auto-generated keys should be made
available for retrieval.
Placeholder for database configuration elements.
Identifies the database configuration so other elements can reference it.
Reference to a JDBC DataSource object. This object is typically created using Spring. When
using XA transactions, an XADataSource object must be provided.
URL used to connect to the database. Supports MEL expressions.
Indicates whether or not the created datasource has to support XA transactions. Default is
false.
Fully-qualified name of the database driver class. Supports MEL expressions.
Maximum time in seconds that this data source will wait while attempting to connect to a
database. A value of zero specifies that the timeout is the default system timeout if there
is one; otherwise, it specifies that there is no timeout.
The transaction isolation level to set on the driver when connecting the database.
Specifies a list of custom key-value connectionProperties for the config. Supports MEL expressions.
Specifies non-standard custom data types.
Name of the data type used by the JDBC driver.
Type identifier used by the JDBC driver.
Indicates which Java class must be used to map the DB type.
Provides a way to configure database connection pooling.
Maximum number of connections a pool maintains at any given time.
Minimum number of connections a pool maintains at any given time.
Determines how many connections at a time to try to acquire when the pool is exhausted.
Determines how many statements are cached per pooled connection. Defaults to 0, meaning statement caching is disabled.
The number of milliseconds a client calling getConnection() waits for a connection to be checked-in or acquired when the pool is exhausted. Zero means wait indefinitely.
Provides a way to define a JDBC configuration for any DB vendor.
The user that is used for authentication against the database. Supports MEL expressions.
The password that is used for authentication against the database. Supports MEL expressions.
Configures just the host part of the JDBC URL (and leaves the rest of the default JDBC URL untouched). Supports MEL expressions.
Configures just the port part of the JDBC URL (and leaves the rest of the default JDBC URL untouched).
Configures just the instance part of the JDBC URL (and leaves the rest of the default JDBC URL untouched). Supports MEL expressions.
The name of the database. Must be configured unless a full JDBC URL is configured.
Supports MEL expressions.
Configures just the host part of the JDBC URL (and leaves the rest of the default
JDBC URL untouched). Supports MEL expressions.
Configures just the port part of the JDBC URL (and leaves the rest of the default
JDBC URL untouched).