Oracle9i: NUMBER fields being set to scientific number

[Busty Sinclair]

Hi
During insertion of a row, I am having a problem with 2 fields: fieldA and fieldB,
both are type NUMBER and are set programmatically as double,
fieldA is programmatically set to 99.0 while fieldB is set to 1.0
both are being set to the same scientific no in the DB which changes upon each insertion , e.g 1E-29
Whats really wierd is fieldC which is also set programmatically to 99.0, is a double and a NUMBER in the DB is set fine.
fieldC precedes the other 2 in the SQL stmt.
The oracle trace output shows that the container has passed on the correct values to the driver.
I tried the explicit setting of the field type in jbosscmp-jdbc but it didn't help.
I can insert through TOAD successfully, it appears to be the driver but I'm using the latest one.
I am using Oracle 9i with driver ojdbc14.jar, JBoss3.0.6
Any help would be GREATLY appreciated!

[Mark Spritzler]

Just out of curiosity, have your tried the Oracle thin driver. You can download it at Oracle's OTN website.
Here is the URL. You will need a username and password for OTN.
http://otn.oracle.com/software/tech/java/sqlj_jdbc/content.html
Mark

[Busty Sinclair]

Hi Mark
I am using an Oracle thin driver, I'll try the OCI one though to see if it affects my prob.
thanks for your reply,
B.

[SJ Adnams]

i've posted somehting on jdbc...

[Mark Spritzler]

Originally posted by Simon Lee:
i've posted somehting on jdbc...

So then this thread is a cross post. Busty, please refrain from cross posting. Cross posting is posting the same question in more than one forum. Try posting in just one forum, if it is the incorrect forum, then a Bartender will move it to a more appropriate forum for you.
Thanks.
Mark
[ August 27, 2003: Message edited by: Mark Spritzler ]

[Cindy Glass]

Please continue the conversation here.