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.
jdbc-ee
JDBC-EE 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 creates the command executor for the read SQL statement.
The factory that creates the command executor for the acknowledge SQL statement.
The factory that creates the retry policies which decide if a SQL
statements must be re executed in case of errors.
Converts a {{List}} of {{Map}} objects to XML. The Map List is the same as what you get
from using the default ResultSetHandler. The XML schema format is provided in the documentation.
Converts XML to a {{List}} of {{Map}} objects. The Map List is the same as what you get
from using the default ResultSetHandler. The XML schema format is provided in the documentation.
Looks up the last {{Map}} from a {{List}} of {{Map}} objects, and then looks up a particular
entry in that {{Map}}. The key used for lookup is set on the idField property. Since Maps are equivalent
to database records, the purpose of this transformer in a JDBC context is to find the last record ID
in a batch.
Name of the key (database column) that
identifies the ID column.
Converts a {{List}} of {{Map}} objects to a CSV file. The Map List is the same as what you get
from using the default ResultSetHandler.
Converts a CSV file to a {{List}} of {{Map}} objects. The Map List is the same as what you get
from using the default ResultSetHandler.
Delimiter used in CSV file. Default is
comma.
Name of the "mapping file" used to describe
the CSV file. See http://flatpack.sourceforge.net for
details.
Whether to ignore the first record. If the
first record is a header, you should ignore it.
The character used to escape text that
contains the delimiter.
Transforms a {{java.sql.ResultSet}} to a {{List}} of {{Map}} objects just like the
default ResultSetHandler. Useful with Oracle stored procedures that return cursors (ResultSets).
Retry policy that defines how Mule should retry if a receive/request/dispatch operation fails.