You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user-java@ibatis.apache.org by dbmigrator <ab...@omniscient.co.in> on 2007/09/07 15:10:29 UTC

Issue with Big number multiplication

Hi All,

I was working on an application which is running purely with DB2 8.1. Now
the requirement came to run this on Oracle10g, so I have decided to use
iBatis as a mid layer so that code base will be common for both the
platforms.

while migrating application from DB2 to iBatis I am facing a big issue
related to Functions MUTILPLY_ALT() of DB2 which i was using to avoid
Arithmetic overflow exception in case of big numbers multiplication.

Can anyone suggest me to do Big number multiplication in iBatis? 
every suggestion will be helpful for me.

Thanks
Dbmigrator
-- 
View this message in context: http://www.nabble.com/Issue-with-Big-number-multiplication-tf4401235.html#a12554931
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Issue with Big number multiplication

Posted by dbmigrator <ab...@omniscient.co.in>.
Richard,

Thanks for you reply,

I have searched about it, Oracle supports big number multiplication, but DB2
not. I am asking about a single common way to write a query in iBatis to
work with both DBs.

Any suggetions...

Thanks
Dbmigrator


Richard Yee wrote:
> 
> You need to see what functions Oracle provides. iBATIS is database 
> agnostic.
> 
> -Richard
> 
> dbmigrator wrote:
>> Hi All,
>>
>> I was working on an application which is running purely with DB2 8.1. Now
>> the requirement came to run this on Oracle10g, so I have decided to use
>> iBatis as a mid layer so that code base will be common for both the
>> platforms.
>>
>> while migrating application from DB2 to iBatis I am facing a big issue
>> related to Functions MUTILPLY_ALT() of DB2 which i was using to avoid
>> Arithmetic overflow exception in case of big numbers multiplication.
>>
>> Can anyone suggest me to do Big number multiplication in iBatis? 
>> every suggestion will be helpful for me.
>>
>> Thanks
>> Dbmigrator
>>   
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Issue-with-Big-number-multiplication-tf4401235.html#a12556975
Sent from the iBATIS - User - Java mailing list archive at Nabble.com.

Re: Issue with Big number multiplication

Posted by Richard Yee <ry...@cruzio.com>.
You need to see what functions Oracle provides. iBATIS is database 
agnostic.

-Richard

dbmigrator wrote:
> Hi All,
>
> I was working on an application which is running purely with DB2 8.1. Now
> the requirement came to run this on Oracle10g, so I have decided to use
> iBatis as a mid layer so that code base will be common for both the
> platforms.
>
> while migrating application from DB2 to iBatis I am facing a big issue
> related to Functions MUTILPLY_ALT() of DB2 which i was using to avoid
> Arithmetic overflow exception in case of big numbers multiplication.
>
> Can anyone suggest me to do Big number multiplication in iBatis? 
> every suggestion will be helpful for me.
>
> Thanks
> Dbmigrator
>