Java Mailing List Archive

http://www.junlu.com/

Home » user-cs.ibatis »

Arithmetic operation resulted in an overflow.

Carmichael, Scott

2010-03-29


Author LoginPost Reply
I have an issue where I get the error "Arithmetic operation resulted in an overflow." when using Oracle 11g.
It happens when a number is too big for the result type.
I know I could use ROUND or TRUNC or even TO_CHAR, but the query is using PIVOT and don't have access to the columns.
 
I've found the Oracle Data Adapter has a SafeMapping option, but don't know how I would go about using it with Ibatis.
Any Ideas?
 
http://download-uk.oracle.com/docs/cd/B19306_01/win.102/b14307/featSafeType.htm#i1008428
 
Regards,
Scott Carmichael






 


This e-mail and files transmitted with it are privileged and confidential information intended for the use of the addressee. The confidentiality and/or privilege in this e-mail is not waived, lost or destroyed if it has been transmitted to you in error. If you received this e-mail in error you must (a) not disseminate, copy or take any action in reliance on it; (b) please notify the Department of Agriculture and Food, WA immediately by return e-mail to the sender; (c) please delete the original e-mail. Department of Agriculture and Food WA

©2008 junlu.com - Jax Systems, LLC, U.S.A.