ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Giovanni Cuccu" <giovanni.cu...@gmail.com>
Subject Re: INOUT and Typehandler
Date Wed, 16 Jul 2008 19:33:56 GMT
Hi,
    IIRC it's not possible to map custom out oracle parameters in
iBatis. I did the investigation in the 2.3.0 code, the fix was not too
hard. I'll try to create an issue in Jira and attach a patch, but I
can't promise anything.
Giovanni

On Wed, Jul 16, 2008 at 7:04 PM, Sundar Sankar <fatboysuns@gmail.com> wrote:
> Hi All,
>           I am using Typehandler for Oracle user defined databases. The
> typehandler seems to be invoked when the mode is "IN" and never called when
> the mode is "INOUT". I saw a post mentioning a similar issue
>
> http://www.mail-archive.com/user-java@ibatis.apache.org/msg07216.html
>
> I tried Larry's suggestion of changing jdbcType to "Struct" and running the
> proc. The Typehandler still doesnt seem to get called. Is there something
> wrong I am doing.
>
> =========
> My Configs
> =========
>
> 1. In SQLMap Config
>
> <!--originally -->
>
> <typeHandler callback="myTypehandler" javaType="myTypehandlerModel"
> jdbcType="ORACLEDATABASEUSERDEFINEDTYPENAME"  />
>
> <!-- Changed to -->
>
> <typeHandler callback="myTypehandler" javaType="myTypehandlerModel"
> jdbcType="STRUCT"  />
>
> 2.  SQLMAp File
>
> <!-- originally -->
>
> <parameter property="propertyName"
> jdbcType="ORACLEDATABASEUSERDEFINEDTYPENAME"
>             javaType="myTypehandlerModell" mode="INOUT" />
>
> <!-- Changed to -->
>
> <parameter property="propertyName" jdbcType="STRUCT"
>             javaType="myTypehandlerModell" mode="INOUT"
> typeName="ORACLEDATABASEUSERDEFINEDTYPENAME"/>
>
> What am I Doing wrong here??
>
> -Sundar
>



-- 
--------------------------------------------------------------------
"You don't know the power of dark side" - Darth Vader

Mime
View raw message