Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 49386 invoked from network); 16 Jul 2008 19:57:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 16 Jul 2008 19:57:11 -0000 Received: (qmail 8174 invoked by uid 500); 16 Jul 2008 19:57:09 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 8161 invoked by uid 500); 16 Jul 2008 19:57:09 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 8150 invoked by uid 99); 16 Jul 2008 19:57:09 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jul 2008 12:57:09 -0700 X-ASF-Spam-Status: No, hits=2.0 required=10.0 tests=HTML_MESSAGE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of fatboysuns@gmail.com designates 66.249.92.174 as permitted sender) Received: from [66.249.92.174] (HELO ug-out-1314.google.com) (66.249.92.174) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 16 Jul 2008 19:56:13 +0000 Received: by ug-out-1314.google.com with SMTP id q7so589143uge.21 for ; Wed, 16 Jul 2008 12:56:36 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:message-id:date:from:to :subject:in-reply-to:mime-version:content-type:references; bh=ellHqZCOH4YfQVv596OBFxB4fmodiJtTtdFjoVQSABc=; b=io8xAVeDCM9bozMpxkF1PILroeoRbL+FmhJPUIdldEK/4kej0OI/ON2WB+FI3gC4Ex bHFm8OS//B48/6aCpc2vVK4w6T/4WjIDQLnYsRoE5fWlp1/gsxxJLsusjwW7dXlpXFRj r799uJv5rB3+bIfyE2tX713GaoX85PeWR6vTI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=message-id:date:from:to:subject:in-reply-to:mime-version :content-type:references; b=Vp6TlfxnfFcMOS8df+ChV02YS/jjOHvRAerme7PoEAXK2B2vARpFNlEbmdHVEd0dPn e/uHZh8blZ0YTo8m86Vzow7AcBxSl428b9AORparGhtoF7d/38lIRQmMkX/YygO5y6Uo +Oq5y5WszCP70lNS06mvjD/0a36p9aOHC25rQ= Received: by 10.66.234.13 with SMTP id g13mr3414762ugh.68.1216238195187; Wed, 16 Jul 2008 12:56:35 -0700 (PDT) Received: by 10.67.123.10 with HTTP; Wed, 16 Jul 2008 12:56:35 -0700 (PDT) Message-ID: Date: Wed, 16 Jul 2008 12:56:35 -0700 From: "Sundar Sankar" To: user-java@ibatis.apache.org Subject: Re: INOUT and Typehandler In-Reply-To: <23e0d1170807161233s149a6dabg7809a44166a0ba32@mail.gmail.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_17248_14715314.1216238195164" References: <23e0d1170807161233s149a6dabg7809a44166a0ba32@mail.gmail.com> X-Virus-Checked: Checked by ClamAV on apache.org ------=_Part_17248_14715314.1216238195164 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline Hi Giovanni, Thanks for the effort. Can you let me know when the patch is in, I will download the latest and try it out. Thanks -Sundar On Wed, Jul 16, 2008 at 12:33 PM, Giovanni Cuccu wrote: > 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 > 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 > > > > > > > > > jdbcType="ORACLEDATABASEUSERDEFINEDTYPENAME" /> > > > > > > > > > jdbcType="STRUCT" /> > > > > 2. SQLMAp File > > > > > > > > > jdbcType="ORACLEDATABASEUSERDEFINEDTYPENAME" > > javaType="myTypehandlerModell" mode="INOUT" /> > > > > > > > > > javaType="myTypehandlerModell" mode="INOUT" > > typeName="ORACLEDATABASEUSERDEFINEDTYPENAME"/> > > > > What am I Doing wrong here?? > > > > -Sundar > > > > > > -- > -------------------------------------------------------------------- > "You don't know the power of dark side" - Darth Vader > ------=_Part_17248_14715314.1216238195164 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Hi Giovanni,
                Thanks for the effort. Can you let me know when the patch is in, I will download the latest and try it out.

Thanks
-Sundar

On Wed, Jul 16, 2008 at 12:33 PM, Giovanni Cuccu <giovanni.cuccu@gmail.com> wrote:
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

------=_Part_17248_14715314.1216238195164--