RE: How to pass a parameter with DECIMAL data type

[Poitras Christian]

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.   Christian From: Brad Balmer [mailto:[EMAIL PROTECTED] 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? [EMAIL PROTECTED] wrote: I am passing a parameter for DECIMAL(5, 2) to a stored procedure. I have the following parameterMap. <parameterMap id="getInfoMap" class="map" >   <parameter property="dollarAmount" jdbcType="DECIMAL" javaType="java.math.BigDecimal" mode="IN"/> </parameterMap> <procedure id="getInfo" parameterMap="getInfoMap">       {call sp_getInfo(?)} </procedure> When I call the stored procedure using DAO object, I got the following error sql error with the cause. --- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data truncated for column 'dollarAmount' at row 1 What did I do wrong? Thanks! Xiao. -- ___________________________ 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.