db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Hong Ji" <hongco...@gmail.com>
Subject java.sql.SQLDataException: The resulting value is outside the range for the data type DOUBLE.
Date Sun, 27 Jan 2008 01:12:48 GMT
When inserting a record with a DOUBLE field and value Double.MAX_VALUE, it
generates the exception \:

java.sql.SQLDataException: The resulting value is outside the range for the
data type DOUBLE.
        at org.apache.derby.impl.jdbc.SQLExceptionFactory40.getSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Unknown
Source)
        at
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedResultSet.noStateChangeException(Unknown
Source)
        at org.apache.derby.impl.jdbc.EmbedPreparedStatement.setDouble(Unknown
Source)
        ...

Not all the DOUBLE fields fail with value Double.MAX_VALUE.

I googled it and similar issue was mentioned years. Not sure, if it is still
a bug?
We are using Derby 10.3.1.4.

Regards,
Hong

Mime
View raw message