Result - 6.3

Talend ESB Mediation Developer Guide

EnrichVersion
6.3
EnrichProdName
Talend Data Fabric
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Open Studio for ESB
Talend Real-Time Big Data Platform
task
Design and Development
EnrichPlatform
Talend ESB

By default the result is returned in the OUT body as an ArrayList<HashMap<String, Object>> . The List object contains the list of rows and the Map objects contain each row with the String key as the column name. You can use the option outputType to control the result.

Note: This component fetches ResultSetMetaData to be able to return the column name as the key in the Map .

Message Headers

Header

Description

CamelJdbcRowCount

If the query is a SELECT, query the row count is returned in this OUT header.

CamelJdbcUpdateCount

If the query is an UPDATE, query the update count is returned in this OUT header.

CamelGeneratedKeysRows

Rows that contain the generated keys. If you insert data using SQL INSERT, setting this value to true causes the generated keys to be returned in headers.

CamelGeneratedKeys-RowCount

The number of rows in the header that contains generated keys.

CamelJdbcColumnNames

The column names from the ResultSet as a java.util.Set type.

CamelJdbcParametes

A java.util.Map which has the headers to be used if useHeadersAsParameters has been enabled.