Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (athena.apache.org: domain of larry.meadors@gmail.com
 designates 209.85.128.184 as permitted sender)
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=gamma;
        h=message-id:date:from:reply-to:to:subject:in-reply-to:mime-version
         :content-type:content-transfer-encoding:content-disposition
         :references;
        b=EerZjOOgL43CPj+GMp/Eu/sQImGej+wUpKNwougBC8VzlEXFEM0lqGrjAvxdbpNlen
         u5F1CMrM5MN+fRZsmQmzaFXgdXmdfb+EUbMUklVBldzZSXe8ytoEXVjaWV8CEMWvy4Jw
         INYO9k7OX8p05as6kBdo6tsplOfuSWZZs4la8=
Message-ID: <a10a823c0809200632k5ee96837n4e85027e853996f5@mail.gmail.com>
Date: Sat, 20 Sep 2008 07:32:25 -0600
From: "Larry Meadors" <larry.meadors@gmail.com>
Reply-To: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: iBATIS : Exponential value issue
In-Reply-To: <48D4C940.6060009@kinokai.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: 
 <OFC40BE2F6.8E597B9B-ONC12574CA.000B3EA1-C12574CA.000B3EA1@ch.ibm.com>
	 <C94A49F6B410A047A7EEE7FA6635DA3503699C07@BLR-EC-MBX08.wipro.com>
	 <48D4C940.6060009@kinokai.de>

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
22,8)?

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

Larry


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
>
>