Return-Path: 
 <user-java-return-8980-apmail-ibatis-user-java-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-user-java-archive@www.apache.org
Received: (qmail 87722 invoked from network); 13 Sep 2006 13:53:28 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 13 Sep 2006 13:53:28 -0000
Received: (qmail 57743 invoked by uid 500); 13 Sep 2006 13:53:27 -0000
Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org
Received: (qmail 57477 invoked by uid 500); 13 Sep 2006 13:53:26 -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 57466 invoked by uid 99); 13 Sep 2006 13:53:26 -0000
Received: from idunn.apache.osuosl.org (HELO idunn.apache.osuosl.org)
 (140.211.166.84)
    by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 13 Sep 2006 06:53:26 -0700
Authentication-Results: idunn.apache.osuosl.org
 smtp.mail=Christian.Poitras@ircm.qc.ca; spf=permerror
X-ASF-Spam-Status: No,
 hits=1.6 required=5.0 tests=DNS_FROM_RFC_BOGUSMX,FORGED_RCVD_HELO,HTML_40_50,HTML_MESSAGE
Received-SPF: error (idunn.apache.osuosl.org: domain ircm.qc.ca from
 207.162.51.5 cause and error)
Received: from ([207.162.51.5:20002] helo=pandore.ircm.priv)
	by idunn.apache.osuosl.org (ecelerity 2.1 r(10620)) with ESMTP
	id A7/34-09463-36D08054 for <user-java@ibatis.apache.org>;
 Wed, 13 Sep 2006 06:53:40 -0700
X-MimeOLE: Produced By Microsoft Exchange V6.5
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----_=_NextPart_001_01C6D73B.F82A6D6C"
Subject: RE: How to pass a parameter with DECIMAL data type
Date: Wed, 13 Sep 2006 09:53:19 -0400
Message-ID: <5820E7E2A928DB46824297946AC2024A9A5FC7@pandore.ircm.priv>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: How to pass a parameter with DECIMAL data type
Thread-Index: AcbWrlz/WaRVxqq+Qh+YiDN6taMr9AAjVSNw
From: "Poitras Christian" <Christian.Poitras@ircm.qc.ca>
To: <user-java@ibatis.apache.org>
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

This is a multi-part message in MIME format.

------_=_NextPart_001_01C6D73B.F82A6D6C
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

If your passing a double to iBATIS, it won't truncate it to DECIMAL(5,2)
before calling the procedure.
You should truncate the data yourself to 2 decimals in the procedure or
in the sql.
=20
Christian


________________________________

From: Brad Balmer [mailto:bbalmer@peapod.com]=20
Sent: Tuesday, 12 September 2006 16:59
To: user-java@ibatis.apache.org
Subject: Re: How to pass a parameter with DECIMAL data type


If you are using MySQL 5, could this be an issue using strict sql mode?



Cs2000xli@cs.com wrote:=20

	I am passing a parameter for DECIMAL(5, 2) to a stored
procedure. I have the following parameterMap.
	<parameterMap id=3D"getInfoMap" class=3D"map" >
	  <parameter property=3D"dollarAmount" jdbcType=3D"DECIMAL"
javaType=3D"java.math.BigDecimal" mode=3D"IN"/>
	</parameterMap>
	<procedure id=3D"getInfo" parameterMap=3D"getInfoMap">
	      {call sp_getInfo(?)}
	</procedure>
=09
	When I call the stored procedure using DAO object, I got the
following error sql error with the cause.
=09
	--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation:
Data truncated for column 'dollarAmount' at row 1
=09
	What did I do wrong?
=09
	Thanks!
=09
	Xiao.
=09
=09


--=20

___________________________
Brad Balmer
Application Architect
Peapod, Inc.
847-583-6306

This email may contain confidential or legally privileged information
that is intended only for the individual or entity named as the
recipient. If you are not the intended recipient, you are hereby
notified that any disclosure, copying, distribution, or reliance upon
the contents of this email is strictly prohibited. If you have received
this email in error, please contact the sender so that proper delivery
can be arranged, and then please delete this message. Thank you.

------_=_NextPart_001_01C6D73B.F82A6D6C
Content-Type: text/html;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =
charset=3Dus-ascii">
<META content=3D"MSHTML 6.00.2900.2963" name=3DGENERATOR></HEAD>
<BODY text=3D#000000 bgColor=3D#ffffff>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D850205113-13092006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>If your passing a double to iBATIS, it won't =
truncate it=20
to&nbsp;DECIMAL(5,2) before calling the procedure.</FONT></SPAN></DIV>
<DIV dir=3Dltr align=3Dleft><SPAN class=3D850205113-13092006><FONT =
face=3DArial=20
color=3D#0000ff size=3D2>You should truncate the data yourself to 2 =
decimals in the=20
procedure or in the sql.</FONT></SPAN></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D850205113-13092006>Christian</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2></FONT><BR></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr align=3Dleft>
<HR tabIndex=3D-1>
<FONT face=3DTahoma size=3D2><B>From:</B> Brad Balmer =
[mailto:bbalmer@peapod.com]=20
<BR><B>Sent:</B> Tuesday, 12 September 2006 16:59<BR><B>To:</B>=20
user-java@ibatis.apache.org<BR><B>Subject:</B> Re: How to pass a =
parameter with=20
DECIMAL data type<BR></FONT><BR></DIV>
<DIV></DIV>If you are using MySQL 5, could this be an issue using <CODE=20
class=3Dliteral>strict</CODE> sql mode?<BR><BR><BR><BR><A=20
class=3Dmoz-txt-link-abbreviated=20
href=3D"mailto:Cs2000xli@cs.com">Cs2000xli@cs.com</A> wrote:=20
<BLOCKQUOTE cite=3Dmidc40.278ac8b.3238769e@cs.com type=3D"cite"><FONT=20
  face=3Darial,helvetica><FONT lang=3D0 face=3DArial size=3D2 =
family=3D"SANSSERIF"=20
  ptsize=3D"10">I am passing a parameter for DECIMAL(5, 2) to a stored =
procedure.=20
  I have the following parameterMap.<BR>&lt;parameterMap =
id=3D"getInfoMap"=20
  class=3D"map" &gt;<BR>&nbsp; &lt;parameter property=3D"dollarAmount"=20
  jdbcType=3D"DECIMAL" javaType=3D"java.math.BigDecimal"=20
  mode=3D"IN"/&gt;<BR>&lt;/parameterMap&gt;<BR>&lt;procedure =
id=3D"getInfo"=20
  parameterMap=3D"getInfoMap"&gt;<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
{call=20
  sp_getInfo(?)}<BR>&lt;/procedure&gt;<BR><BR>When I call the stored =
procedure=20
  using DAO object, I got the following error sql error with the=20
  cause.<BR><BR>--- Cause: com.mysql.jdbc.MysqlDataTruncation: Data =
truncation:=20
  Data truncated for column 'dollarAmount' at row 1<BR><BR>What did I do =

  =
wrong?<BR><BR>Thanks!<BR><BR>Xiao.<BR><BR></FONT></FONT></BLOCKQUOTE><BR>=
<PRE class=3Dmoz-signature cols=3D"72">--=20

___________________________
Brad Balmer
Application Architect
Peapod, Inc.
847-583-6306

This email may contain confidential or legally privileged information =
that is intended only for the individual or entity named as the =
recipient. If you are not the intended recipient, you are hereby =
notified that any disclosure, copying, distribution, or reliance upon =
the contents of this email is strictly prohibited. If you have received =
this email in error, please contact the sender so that proper delivery =
can be arranged, and then please delete this message. Thank =
you.</PRE></BODY></HTML>

------_=_NextPart_001_01C6D73B.F82A6D6C--