Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Bignum or BigDecimal, which do I use?

April 26, 2017bigdecimal bignum

0

Posted

Bignum or BigDecimal, which do I use?

1 Answer

0

Posted

Bignum has been replaced by BigInteger and BigDecimal and is no longer supported by JDBC. JDK1.1 requires the use of jdbc.math.BigDecimal or jdbc.math.BigInteger for NUMERIC or DECIMAL SQL types. Please note the BigDecimal difference between the native (JDK1.1) and the 1.0.2/downloadable implementations:JDK1.1 native: BigDecimal has unlimited precision. JDK1.0.2/downloadable: BigDecimal has reduced precision, using 8 bytes to store NUMERIC or DECIMAL SQL fields, which yeilds approximately 18 digits of precision.If a field is selected that exceeds the 8 byte limitation, an ArithmeticException:Overflow will be raised.