asked on

Getting Exponential values when insertinbg to database

I am using JSP deployed on Tomcat with Oracle 8i as database. My problem is when i insert a large value(say 10 digits) using JSP in my database it gets inserted as something like 4.8E9
I am usin Double datatype in JSP and the width of column in Oracle is also defined as NUMBER(20,2).

searlas

What are you using to view the Oracle values? Have you tried reading the values back out of Oracle using JDBC?
Basic question, is this actually a problem, or is it just the appearance of the number that concerns you?

jarasa

Try using Float.
Javier

kennethxu

follow what other experts have suggested. if you have problem on displaying value in web page, then your might also want to look into java.text.DecimalFormat

anna_1980

ASKER

>>What are you using to view the Oracle values? Have you tried reading the values back out of Oracle using JDBC?
Basic question, is this actually a problem, or is it just the appearance of the number that concerns you?

--Yes, I am using JDBC and fetching the values back using ResultSet.
This is indeed a problem because users don't like it that way.

>>Try using Float.

--Tried that.Infact I started with using Float but then switched to Double thinking it may solve the problem.

ASKER CERTIFIED SOLUTION

kennethxu

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

jarasa

Can you post you code to see if is something starnge on it?
Javier

anna_1980

ASKER

Thanks everyone for helping

searlas

Gotta acknowledge kennethxu's expreience here; avoiding the trap of taking the problem description as gospel, seeing through it, and solving the actual problem... (presentation of numbers on screen, NOT in the database)

jarasa

Doesn't he got the Points??

:c)

Javier

P.D.: I agree Searlas.

kennethxu

you guys are making fun on me :-)
I would like to pass some points but just afraid somebody in the forum will again starts crying. Missing those days that can enjoy a peaceful forum with you guys.

jarasa

Hmm as I see it, points mean nothing here* , well is good that EE has given us unlimited points to ask I appeciate that even while I don't ask much, but what I really miss is a place to talk and get to know each other a bit better.

I really enjoy helping ppl here and that's becose we can make a laugh from time to time :c))

Javier

* To tell the truth I like to see my name on the list :cP