Have you tried setting the scale of your new BigDecimal(BigInteger.ZERO) ? Something like:
BigDecimal value = new BigDecimal(BigInteger.ZERO); value.setScale(8, new MathContext(19, RoundingMode.HALF_UP)); where the MathContext sets the precision of your BigDecimals... -----Ursprüngliche Nachricht----- Von: pedro [mailto:[email protected]] Gesendet: Dienstag, 8. September 2009 10:09 An: [email protected] Betreff: The resulting value is outside the range for the data type DECIMAL/NUMERIC(4,4). Hi all i have this error on insert but i don't understand why because i insert almost 4 decimals BigDecimal. My java code : [code] PreparedStatement preparedStatement = null; ListinoVO listinoVO = (ListinoVO) voInterface; String insQry = "INSERT INTO " + getTableName() + " (CODCLI,CODPRO,SCONTPERC,SCONTOEURO) "; insQry += "VALUES (?,?,?,?)"; try { preparedStatement = conn.prepareStatement(insQry); preparedStatement.setLong(1, listinoVO.getCliente().getCodCli().longValue()); preparedStatement.setLong(2, listinoVO.getProdotto().getCodPro().longValue()); // Se no si porta dietro n cifre e Derby(DB) va in errore BigDecimal sconto = listinoVO.getScontoEuro().setScale(4,BigDecimal.ROUND_HALF_EVEN); preparedStatement.setBigDecimal(3, new BigDecimal(BigInteger.ZERO)); preparedStatement.setBigDecimal(4, sconto); int result = preparedStatement.executeUpdate(); [/code] My table [code] COLUMN_NAME |TYPE_NAME|DEC&|NUM&|COLUM&|COLUMN_DEF|CHAR_OCTE&|IS_NULL& ------------------------------------------------------------------------------ CODCLI |NUMERIC |0 |10 |12 |NULL |NULL |NO CODPRO |NUMERIC |0 |10 |12 |NULL |NULL |NO SCONTPERC |NUMERIC |0 |10 |3 |NULL |NULL |YES SCONTOEURO |NUMERIC |4 |10 |4 |NULL |NULL |YES [/code] I try and i found that the problem is SCONTOEURO but i'm sure, because i debug by eclipse, that the value is with 4 decimals. Any idea ? -- View this message in context: http://www.nabble.com/The-resulting-value-is-outside-the-range-for-the-data-type-DECIMAL-NUMERIC%284%2C4%29.-tp25341647p25341647.html Sent from the Apache Derby Users mailing list archive at Nabble.com.
