db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Suavi Ali Demir <dem...@yahoo.com>
Subject Re: Double.NaN in table?
Date Wed, 19 Dec 2007 05:05:44 GMT
Can you make your column nullable and insert null instead of Nan?

David <dholliday@TheSolutionWorks.com> wrote:
  For an application I am writing I need to store doubles in a table. I 
thought I could use the DOUBLE type when creating the columns in my tables. 
Unfortunately the insert fails when the value of the double is Double.NaN. 
We use NaN a lot in our analysis. Is there a way to make this work, or 
should we just convert everything to a string?
We are using Java 6.x with JavaDB (Derby). Our tables are around 8,000 rows 
(200,000 rows in the future) by 15 columns.

Performance is not much of an issue in this part of our system, we are only 
using the database so that we can be flexible with our filtering of this 

Any ideas?

Thanks in advance,


I am new to database programming.

Never miss a thing.   Make Yahoo your homepage.
View raw message