Re: Oracle10 jdbc and BigDecimals

From: Mike Kienenberger (mkienen..laska.net)
Date: Mon Feb 14 2005 - 16:17:51 EST

  • Next message: Jamie Orchard-Hays: "tapestry examples"

    Tim Mumford <Tim.Mumfor..ntero.com> wrote:
    > 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'.

    Better to find out about it here rather than in my production application :)



    This archive was generated by hypermail 2.0.0 : Mon Feb 14 2005 - 16:17:19 EST