META-INF.mule-jdbc.xsd Maven / Gradle / Ivy
Go to download
Show more of this group Show more artifacts with this name
Show all versions of mule-transport-jdbc Show documentation
Show all versions of mule-transport-jdbc Show documentation
A Mule transport for JDBC connectivity.
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.
JDBC
JDBC 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 delay in milliseconds that will be used during two subsequent polls to the database.
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 delay in milliseconds that will be used during two subsequent polls to the database.
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.
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
Identifies the pool so that the connector can reference it.
The JDBC URL that is used for connecting the database.
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.
The user that is used for authentication against the database.
The password that is used for authentication against the database.
The user that is used for authentication against the database.
The password that is used for authentication against the database.
Allows to configure just the host part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the port part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the instance part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
The name of the database. Must be configured unless a full JDBC URL is configured.
Allows to configure just the host part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the port part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
The name of the database. Must be configured unless a full JDBC URL is configured.
Allows to configure just the host part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the port part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
The name of the database. Must be configured unless a full JDBC URL is configured.
If true, the database will be created upon first access to the database. See the derby documentation.
Allows to configure just the host part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the port part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the database part of the JDBC URL (and leave the rest of the default JDBC URL untouched). When no server/port are defined, database points to a native component and requires native libraries.
Allows to configure just the host part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the port part of the JDBC URL (and leave the rest of the default JDBC URL untouched).
Allows to configure just the instance part of the JDBC URL (and leave the rest of the default JDBC URL untouched). If not specified, the default instance is used
© 2015 - 2025 Weber Informatics LLC | Privacy Policy