From derby-user-return-8248-apmail-db-derby-user-archive=db.apache.org@db.apache.org Wed Dec 19 04:15:45 2007 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 86806 invoked from network); 19 Dec 2007 04:15:45 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Dec 2007 04:15:45 -0000 Received: (qmail 42113 invoked by uid 500); 19 Dec 2007 04:15:33 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 42010 invoked by uid 500); 19 Dec 2007 04:15:33 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 41998 invoked by uid 99); 19 Dec 2007 04:15:33 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 18 Dec 2007 20:15:33 -0800 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of gcaddu-derby-user@m.gmane.org designates 80.91.229.2 as permitted sender) Received: from [80.91.229.2] (HELO ciao.gmane.org) (80.91.229.2) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 19 Dec 2007 04:15:21 +0000 Received: from root by ciao.gmane.org with local (Exim 4.43) id 1J4qKk-0001k1-DT for derby-user@db.apache.org; Wed, 19 Dec 2007 04:15:02 +0000 Received: from c-75-67-239-110.hsd1.nh.comcast.net ([75.67.239.110]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 19 Dec 2007 04:15:02 +0000 Received: from dholliday by c-75-67-239-110.hsd1.nh.comcast.net with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Wed, 19 Dec 2007 04:15:02 +0000 X-Injected-Via-Gmane: http://gmane.org/ To: derby-user@db.apache.org From: "David" Subject: Double.NaN in table? Date: Tue, 18 Dec 2007 22:23:56 -0500 Lines: 24 Message-ID: X-Complaints-To: usenet@ger.gmane.org X-Gmane-NNTP-Posting-Host: c-75-67-239-110.hsd1.nh.comcast.net X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 X-RFC2646: Format=Flowed; Original Sender: news X-Virus-Checked: Checked by ClamAV on apache.org 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 data. Any ideas? Thanks in advance, -David I am new to database programming.