[
https://issues.apache.org/activemq/browse/CAMEL-3066?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=61502#action_61502
]
Claus Ibsen commented on CAMEL-3066:
------------------------------------
Ramon, thanks for reporting back.
How do you map the last parameter as OUT? How do you tell iBatis that it's an
OUT parameter?
> Result is empty after calling a stored procedure
> ------------------------------------------------
>
> Key: CAMEL-3066
> URL: https://issues.apache.org/activemq/browse/CAMEL-3066
> Project: Apache Camel
> Issue Type: Bug
> Components: camel-ibatis
> Affects Versions: 2.4.0
> Environment: Windows, eclipse, oracle
> Reporter: Ramon van den Hoven
>
> 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);
> }
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
