ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Larry Meadors" <larry.mead...@gmail.com>
Subject Re: iBATIS : Exponential value issue
Date Sat, 20 Sep 2008 13:32:25 GMT
I'd like to see the SQL statement, too...how do you jam a number like
that (0.0000000000030000) into a field with 8 decimal places (number

I'd also be curious as to the "Why?", but that's a secondary question. ;-)


On Sat, Sep 20, 2008 at 3:58 AM, Kai Grabfelder <nospam@kinokai.de> wrote:
> Hi,
> which (exact) version of iBATIS are you using? Which (exact) version of the
> Oracle driver are you using? Which java version are you using? Were you
> using exactly the same driver and java version when you did your comparison
> between ibatis and plain jdbc?
> I'm asking all this stuff because I had a lot of troubles with oracle
> drivers depending on the java version.
> Regards
> Kai
> --- Original Nachricht ---
> Absender: girish.korkod@wipro.com
> Datum: 20.09.2008 06:37
>> Hello,
>>  We have an issue when we store expontential value in oracle database
>> using iBATIS. When we store a value of 0E-16(which could be
>> 0.0000000000030000) using iBATIS it is stored as 16 in database instead of
>> 0(zero). When we store the same value using sql insert directly it is
>> storing the value correctly(zero).
>>  Precision of big decimal in application is 16.
>> Precision in database for this column is 8(column type is number 22,8).
>> JDBC mapping for this column in iBATIS SQL MAP is DECIMAL.
>>  iBATIS version : 2.3
>> Oracle 10G
>>  Please advise on what could be the possible issue and solution.  Thank
>> you in advance.
>>  Regards,
>> Girish
>> Please do not print this email unless it is absolutely necessary.
>> The information contained in this electronic message and any attachments
>> to this message are intended for the exclusive use of the addressee(s) and
>> may contain proprietary, confidential or privileged information. If you are
>> not the intended recipient, you should not disseminate, distribute or copy
>> this e-mail. Please notify the sender immediately and destroy all copies of
>> this message and any attachments.
>> WARNING: Computer viruses can be transmitted via email. The recipient
>> should check this email and any attachments for the presence of viruses. The
>> company accepts no liability for any damage caused by any virus transmitted
>> by this email.
>> www.wipro.com

View raw message