db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Thomas Nielsen <Thomas.Niel...@Sun.COM>
Subject Re: Double.NaN in table?
Date Wed, 19 Dec 2007 11:01:41 GMT
Neither the JDBC 4.0 specification[1] nor "JDBC API Tutorial and 
Reference"[2] mention handling of the NaN or INFINITE numbers at all AFAICT.

As there is no mention of how to handle *jdbc* doubles (and literals), 
it seems this then boils down to how/if the database handle the *sql* 
double (and literals).


[1] JSR-221, JDBC 4.0, 

[2] "JDBC API Tutorial and Reference, Third Edt.", Fisher, Ellis & 
Bruce, Addison-Wesley 2003.

Andrew ``Bass'' Shcheglov wrote:
> On Dec 19, 2007 12:23 PM, Thomas Nielsen <Thomas.Nielsen@sun.com> wrote:
>> Looking at the derby code on the main trunk, I see the exception is
>> intentional, as there is an explicit check for NaN values in
>> NumberDataType.normalizeDOUBLE().
>> Not sure if this is another DB2 compatability issue/limitation or not.
>> Maybe someone with deeper knowledge can give more details on this?
> This is odd,
> for Oracle, for instance, fully supports IEEE 754 (since 10g):
> http://www.oracle.com/technology/sample_code/tutorials/jdbc10g/ieeedatatypes/files/IEEEDatatypes.pdf
> http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/sql_elements003.htm

Thomas Nielsen

View raw message