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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > 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 > >
