Re: How to pass a parameter with DECIMAL data type

[Brad Balmer]

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.