[CAMEL-3066] Result is empty after calling a stored procedure

• Type: Improvement
• Status: Closed
• Priority: Minor
• Resolution: Not A Problem
• Affects Version/s: 2.4.0
• Fix Version/s: 2.5.0
• Component/s: camel-ibatis

Environment

Windows, eclipse, oracle

• Assignee: Claus Ibsen
• Reporter: Ramon van den Hoven
• Created: 20/Aug/10 14:37
• Updated: 24/Apr/11 09:57
• Resolved: 19/Sep/10 08:47

Description

When calling a stored procedure in the following form

{call lsuser.liq_vortex.LIQ_VORTEX_ALL_STRUCT(?,?,?,?,?)}

where the last ? is an OUT param, the result is null.

See for comments in the following function in the IbatisProducer class
Look for the NOTE:

private void doQueryForObject(Exchange exchange) throws Exception {
SqlMapClient client = endpoint.getSqlMapClient();

Object result;
Object in = exchange.getIn().getBody();
if (in != null) {
if (LOG.isTraceEnabled())

{ LOG.trace("QueryForObject: " + in + " using statement: " + statement); }

result = client.queryForObject(statement, in);
NOTE: The in parameter has the resultset, in my case a HashMap, isn't it always a Map?
should be something like:
result = in.get(outParameterKey)

} else {
if (LOG.isTraceEnabled())

{ LOG.trace("QueryForObject using statement: " + statement); }

result = client.queryForObject(statement);
}

doProcessResult(exchange, result);
}