RE: Oracle10 jdbc and BigDecimals

From: Tim Mumford (Tim.Mumfor..ntero.com)
Date: Mon Feb 14 2005 - 15:39:05 EST

Next message: Mike Kienenberger: "Re: Oracle10 jdbc and BigDecimals"

Previous message: Mike Kienenberger: "Re: Cayenne and Jython"
Maybe in reply to: Tim Mumford: "Oracle10 jdbc and BigDecimals"
Next in thread: Mike Kienenberger: "Re: Oracle10 jdbc and BigDecimals"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

I apologize for what turns out to be off topic. Further debugging
revealed that the behaviour is due to the driver (Oracle JDBC Driver
version - 10.1.0.3.) not handling the very small (including zero)
BigDecimals that use exponential notation. For example, a BigDecimal
divide(divisor, scale, rounding_mode) produced '0E-8' where '8' was the
scale. The preparedstatement ultimately inserted this value as '8'
rather than '0'.

Next message: Mike Kienenberger: "Re: Oracle10 jdbc and BigDecimals"
Previous message: Mike Kienenberger: "Re: Cayenne and Jython"
Maybe in reply to: Tim Mumford: "Oracle10 jdbc and BigDecimals"
Next in thread: Mike Kienenberger: "Re: Oracle10 jdbc and BigDecimals"
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

This archive was generated by hypermail 2.0.0 : Mon Feb 14 2005 - 15:36:48 EST