ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Clinton Begin <clinton.be...@gmail.com>
Subject Re: IBatis 3.0 beta 10 + annotations + stored procedures
Date Thu, 25 Mar 2010 03:17:20 GMT
Oh.... I didn't even notice, but your parameter is a String, which is
immutable.  You'd have to pass the parameter in as a Map or a POJO. Since
Java doesn't support pass by reference, or out parameters, or mutable
strings, there's no way around this.

Clinton

On Wed, Mar 24, 2010 at 9:15 PM, Clinton Begin <clinton.begin@gmail.com>wrote:

> You have to tell iBATIS that it's a proc, and set the statement type to
> CALLABLE and set the parameter to an output parameter, as follows:
>
> @Select(" ibatis3select(#{Currency*,mode=OUT*}) ")
> *@Options(statementType = StatementType.CALLABLE)*
> Integer selectACurrencyBatis3(String sCurrency );
>
> Most procs will probably run without it, but for any proc specific
> variables, like out parameters, you have to do this.
>
> Clinton
>
>
>
> On Wed, Mar 24, 2010 at 4:03 AM, Arpon <the_philosopher@mail.inet.hr>wrote:
>
>>
>> Does anyone have an example of calling stored procedures with IN and OUT
>> parameters without IBatis Map files (by using Annotations).
>> Sending parameter to procedure works well, but can't return parameter...
>>
>> I am using IBatis3 beta 10...
>>
>> Interface:
>> @Select(" ibatis3select(#{Currency}) ")
>> Integer selectACurrencyBatis3(String sCurrency );
>>
>> Some DAO:
>> Integer ret = ((ACurrencyObjDuro)
>> pomDuro).selectACurrencyBatis3(sCurrency);
>>
>> Cheers,
>> Arpon
>> --
>> View this message in context:
>> http://old.nabble.com/IBatis-3.0-beta-10-%2B-annotations-%2B-stored-procedures-tp28012821p28012821.html
>> Sent from the iBATIS - User - Java mailing list archive at Nabble.com.
>>
>>
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: user-java-unsubscribe@ibatis.apache.org
>> For additional commands, e-mail: user-java-help@ibatis.apache.org
>>
>>
>

Mime
View raw message