Dec 23rd, 2008, 10:56 PM
StoredProc class exec method fails - BigDecimal to Decimal -values more than 5 digits
I have a DTO that has an attribute salary defined as BigDecimal, I have a db2 database that has a column defined as Decimal(11,2). I set a datatype Types.Decimal and set the map with salary reading from dto. When we pass more than 5 digits(example: 100000), the call fails to update returning db2 SQLCODE: -302, SQLSTATE: 22003, SQLERRMC: null. But, when I execute the stored procedure directly it updates the data with no problems. And when I call the same method with a 5 digit value (99999) which is just 1 number less than my previous value, it updates successfuly.
I have checked the limits both for BigDecimal in Java, Decimal in DB2 database and if the mapping is right from BigDecimal to Decimal, they all seem to be right. I am not sure if I am missing something here. Some of you might have seen this issue, Please share your ideas.
Thanks in advance - BlueSky
Tags for this Thread