Return-Path: 
 <user-java-return-10103-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 49749 invoked from network); 20 Dec 2006 20:30:51 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 20 Dec 2006 20:30:51 -0000
Received: (qmail 84147 invoked by uid 500); 20 Dec 2006 20:30:54 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 84112 invoked by uid 500); 20 Dec 2006 20:30:53 -0000
Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:user-java-help@ibatis.apache.org>
List-Unsubscribe: <mailto:user-java-unsubscribe@ibatis.apache.org>
List-Post: <mailto:user-java@ibatis.apache.org>
List-Id: <user-java.ibatis.apache.org>
Reply-To: user-java@ibatis.apache.org
Delivered-To: mailing list user-java@ibatis.apache.org
Received: (qmail 84074 invoked by uid 99); 20 Dec 2006 20:30:52 -0000
Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 20 Dec 2006 12:30:52 -0800
X-ASF-Spam-Status: No, hits=4.8 required=10.0
	tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,HTML_MESSAGE
X-Spam-Check-By: apache.org
Received-SPF: pass (herse.apache.org: local policy)
Received: from [66.196.100.230] (HELO web58901.mail.re1.yahoo.com)
 (66.196.100.230)
    by apache.org (qpsmtpd/0.29) with SMTP; Wed, 20 Dec 2006 12:30:40 -0800
Received: (qmail 29136 invoked by uid 60001); 20 Dec 2006 20:30:19 -0000
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=Message-ID:Received:Date:From:Subject:To:MIME-Version:Content-Type;
  b=mwb7RiSP4IttcW/jwm4mUHeFthTaVJQHAerbmxfVK/Y8VvjSDg8v5VhnzXA63Q46GdX7GYpAbPzrO6phL+r9r7+kKaGj5Goq2La07I1LlFmjXvLIc7ul6I2ocrzyic927ik/GH4MCughvHQ8j3wun9mDfMaZmAEsnXNfCnv2Chc=
  ;
Message-ID: <20061220203019.29134.qmail@web58901.mail.re1.yahoo.com>
Received: from [68.238.72.110] by web58901.mail.re1.yahoo.com via HTTP;
 Wed, 20 Dec 2006 12:30:19 PST
Date: Wed, 20 Dec 2006 12:30:19 -0800 (PST)
From: Tegan Clark <tegan.clark@yahoo.com>
Subject: mode="INOUT" with custom type handler
To: user-java@ibatis.apache.org
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary="0-778986590-1166646619=:25915"
X-Virus-Checked: Checked by ClamAV on apache.org

--0-778986590-1166646619=:25915
Content-Type: text/plain; charset=ascii
Content-Transfer-Encoding: quoted-printable

Hi Group,=0A=0AI've successfully implemented a custom type handler to handl=
e an Oracle custom type.  All works just fine as long as my custom type is =
registered as mode=3D"IN".  In Oracle it's actually an INOUT.  As soon as i=
 change the mode to INOUT in my map I get a "Invalid column type" from iBAT=
IS when it types to map the parameters.  My type handler never gets called,=
 so the problems not in there (I think).=0A=0AHere's the snippet of the map=
:=0A=0A    <parameterMap id=3D"listErrorByClientSummaryParameters" class=3D=
"java.util.Map">=0A        <parameter property=3D"report.dateRange" javaTyp=
e=3D"com.sc.domain.report.DateRange" jdbcType=3D"DATERANGETYPE" mode=3D"INO=
UT"/>=0A=0AAnd the registration in the config:=0A=0A   =0A <typeHandler jav=
aType=3D"com.sc.domain.report.DateRange" jdbcType=3D"DATERANGETYPE" callbac=
k=3D"com.sc.dal.reportBuilder.ibatis.typeHandler.DateRangeTypeHandler" />=
=0A=0AChanging to INOUT throws me:=0A=0A The error occurred in com/sc/dal/r=
eportBuilder/ibatis/errorLogSummaryReport-map.xml.  =0A The error occurred =
while executing query procedure.  =0A Check the {call all_error_pkg.listErr=
orByClientSummary()}.  =0A Check the output parameters (register output par=
ameters failed).  =0A Cause: java.sql.SQLException: Invalid column type; ne=
sted exception is com.ibatis.common.jdbc.exception.NestedSQLException:   =
=0A The error occurred in com/aptare/sc/dal/reportBuilder/ibatis/errorLogSu=
mmaryReport-map.xml.  =0A The error occurred while executing query procedur=
e.  =0A Check the {call all_error_pkg.listErrorByClientSummary()}.  =0A Che=
ck the output parameters (register=0A output parameters failed).  =0A Cause=
: java.sql.SQLException: Invalid column type=0A=0AI read Oracle can throw t=
his if you set a null on a column that doesn't have a type set, but I'm pre=
tty sure I'm not in that boat.=0A=0AAnyone on the list had any similar expe=
riences?=0A=0AAll help greatly appreciated.=0A=0ATegan=0A=0A=0A=0A=0A =0A=
=0A=0A=0A=0A__________________________________________________=0ADo You Yah=
oo!?=0ATired of spam?  Yahoo! Mail has the best spam protection around =0Ah=
ttp://mail.yahoo.com 
--0-778986590-1166646619=:25915
Content-Type: text/html; charset=ascii
Content-Transfer-Encoding: quoted-printable

<html><head><style type=3D"text/css"><!-- DIV {margin:0px;} --></style></he=
ad><body><div style=3D"font-family:times new roman, new york, times, serif;=
font-size:12pt"><div style=3D"font-family: times new roman,new york,times,s=
erif; font-size: 12pt;"><div style=3D"font-family: times new roman,new york=
,times,serif; font-size: 12pt;">Hi Group,<br><div style=3D"font-family: tim=
es new roman,new york,times,serif; font-size: 12pt;"><div><br>I've successf=
ully implemented a custom type handler to handle an Oracle custom type.&nbs=
p; All works just fine as long as my custom type is registered as mode=3D"I=
N".&nbsp; In Oracle it's actually an INOUT.&nbsp; As soon as i change the m=
ode to INOUT in my map I get a "Invalid column type" from iBATIS when it ty=
pes to map the parameters.&nbsp; My type handler never gets called, so the =
problems not in there (I think).<br><br>Here's the snippet of the map:<br><=
br>&nbsp;&nbsp;&nbsp; &lt;parameterMap id=3D"listErrorByClientSummaryParame=
ters"
 class=3D"java.util.Map"&gt;<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
&lt;parameter property=3D"report.dateRange" javaType=3D"com.sc.domain.repor=
t.DateRange" jdbcType=3D"DATERANGETYPE" mode=3D"INOUT"/&gt;<br><br>And the =
registration in the config:<br><br>&nbsp;&nbsp;&nbsp;=0A &lt;typeHandler ja=
vaType=3D"com.sc.domain.report.DateRange" jdbcType=3D"DATERANGETYPE" callba=
ck=3D"com.sc.dal.reportBuilder.ibatis.typeHandler.DateRangeTypeHandler" /&g=
t;<br><br>Changing to INOUT throws me:<br><br>&nbsp;The error occurred in c=
om/sc/dal/reportBuilder/ibatis/errorLogSummaryReport-map.xml.&nbsp; <br>&nb=
sp;The error occurred while executing query procedure.&nbsp; <br>&nbsp;Chec=
k the {call all_error_pkg.listErrorByClientSummary()}.&nbsp; <br>&nbsp;Chec=
k the output parameters (register output parameters failed).&nbsp; <br>&nbs=
p;Cause: java.sql.SQLException: Invalid column type; nested exception is co=
m.ibatis.common.jdbc.exception.NestedSQLException:&nbsp;&nbsp; <br>&nbsp;Th=
e error occurred in com/aptare/sc/dal/reportBuilder/ibatis/errorLogSummaryR=
eport-map.xml.&nbsp; <br>&nbsp;The error occurred while executing query pro=
cedure.&nbsp; <br>&nbsp;Check the {call all_error_pkg.listErrorByClientSumm=
ary()}.&nbsp; <br>&nbsp;Check the output parameters (register=0A output par=
ameters failed).&nbsp; <br>&nbsp;Cause: java.sql.SQLException: Invalid colu=
mn type<br><br>I read Oracle can throw this if you set a null on a column t=
hat doesn't have a type set, but I'm pretty sure I'm not in that boat.<br><=
br>Anyone on the list had any similar experiences?<br><br>All help greatly =
appreciated.<br><br>Tegan<br></div></div><br><br> </div><br></div></div><br=
>__________________________________________________<br>Do You Yahoo!?<br>Ti=
red of spam?  Yahoo! Mail has the best spam protection around <br>http://ma=
il.yahoo.com </body></html>
--0-778986590-1166646619=:25915--