Return-Path: Delivered-To: apmail-openjpa-users-archive@minotaur.apache.org Received: (qmail 93549 invoked from network); 3 May 2010 16:10:31 -0000 Received: from unknown (HELO mail.apache.org) (140.211.11.3) by 140.211.11.9 with SMTP; 3 May 2010 16:10:31 -0000 Received: (qmail 39843 invoked by uid 500); 3 May 2010 16:10:31 -0000 Delivered-To: apmail-openjpa-users-archive@openjpa.apache.org Received: (qmail 39802 invoked by uid 500); 3 May 2010 16:10:31 -0000 Mailing-List: contact users-help@openjpa.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: users@openjpa.apache.org Delivered-To: mailing list users@openjpa.apache.org Received: (qmail 39794 invoked by uid 99); 3 May 2010 16:10:31 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 May 2010 16:10:31 +0000 X-ASF-Spam-Status: No, hits=2.9 required=10.0 tests=HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: local policy) Received: from [209.85.212.174] (HELO mail-px0-f174.google.com) (209.85.212.174) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 03 May 2010 16:10:21 +0000 Received: by pxi5 with SMTP id 5so282720pxi.33 for ; Mon, 03 May 2010 09:09:59 -0700 (PDT) Received: by 10.141.14.4 with SMTP id r4mr3564952rvi.171.1272902999446; Mon, 03 May 2010 09:09:59 -0700 (PDT) Received: from brevsnb005 (CPE-138-130-152-156.lns6.cht.bigpond.net.au [138.130.152.156]) by mx.google.com with ESMTPS id b10sm1560999rvn.15.2010.05.03.09.09.55 (version=SSLv3 cipher=RC4-MD5); Mon, 03 May 2010 09:09:57 -0700 (PDT) Reply-To: From: "C N Davies" To: Subject: What is a NaN? Date: Tue, 4 May 2010 02:09:52 +1000 Organization: C N Davies Pty Ltd Message-ID: <00cc01caeadb$12a7e190$37f7a4b0$@com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00CD_01CAEB2E.E453F190" X-Mailer: Microsoft Office Outlook 12.0 Thread-Index: Acrq2xA5C2L7wJKvQbaFTtRx8gkhxg== Content-Language: en-au X-Virus-Checked: Checked by ClamAV on apache.org ------=_NextPart_000_00CD_01CAEB2E.E453F190 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I guess it is "Not a Number", But I am not inserting anything that is not a number L If I have SQL trace switched on I can see select statements but I never seem to see update or insert queries so I can't really see what the error is in the query. Anyone have any ideas? I have processed this same data files before ! Thanks Chris Caused by: org.apache.openjpa.persistence.PersistenceException: The transaction has been rolled back. See the nested exceptions for details on the errors that occurred. at org.apache.openjpa.kernel.BrokerImpl.newFlushException(BrokerImpl.java:2302) at org.apache.openjpa.kernel.BrokerImpl.flush(BrokerImpl.java:2139) at org.apache.openjpa.kernel.BrokerImpl.flushSafe(BrokerImpl.java:2037) at org.apache.openjpa.kernel.BrokerImpl.beforeCompletion(BrokerImpl.java:1955) at org.apache.openjpa.kernel.LocalManagedRuntime.commit(LocalManagedRuntime.jav a:81) at org.apache.openjpa.kernel.BrokerImpl.commit(BrokerImpl.java:1479) at org.apache.openjpa.kernel.DelegatingBroker.commit(DelegatingBroker.java:925) at org.apache.openjpa.persistence.EntityManagerImpl.commit(EntityManagerImpl.ja va:559) ... 5 more Caused by: org.apache.openjpa.persistence.PersistenceException: 'NaN' is not a valid numeric or approximate numeric value at org.apache.openjpa.jdbc.sql.DBDictionary.narrow(DBDictionary.java:4827) at org.apache.openjpa.jdbc.sql.DBDictionary.newStoreException(DBDictionary.java :4787) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:136) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:110) at org.apache.openjpa.jdbc.sql.SQLExceptions.getStore(SQLExceptions.java:62) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedSt atementManagerImpl.java:89) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdat eManager.java:550) at org.apache.openjpa.jdbc.kernel.ConstraintUpdateManager.flush(ConstraintUpdat eManager.java:106) at org.apache.openjpa.jdbc.kernel.BatchingConstraintUpdateManager.flush(Batchin gConstraintUpdateManager.java:59) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateMan ager.java:103) at org.apache.openjpa.jdbc.kernel.AbstractUpdateManager.flush(AbstractUpdateMan ager.java:76) at org.apache.openjpa.jdbc.kernel.JDBCStoreManager.flush(JDBCStoreManager.java: 751) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManage r.java:131) at org.apache.openjpa.datacache.DataCacheStoreManager.flush(DataCacheStoreManag er.java:540) at org.apache.openjpa.kernel.DelegatingStoreManager.flush(DelegatingStoreManage r.java:131) ... 12 more Caused by: java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3252) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setDouble(Delegating PreparedStatement.java:317) at org.apache.openjpa.lib.jdbc.LoggingConnectionDecorator$LoggingConnection$Log gingPreparedStatement.setDouble(LoggingConnectionDecorator.java:1229) at org.apache.openjpa.lib.jdbc.DelegatingPreparedStatement.setDouble(Delegating PreparedStatement.java:317) at org.apache.openjpa.jdbc.sql.DBDictionary.setDouble(DBDictionary.java:1067) at org.apache.openjpa.jdbc.sql.DBDictionary.setTyped(DBDictionary.java:1243) at org.apache.openjpa.jdbc.sql.RowImpl.flush(RowImpl.java:896) at org.apache.openjpa.jdbc.sql.RowImpl.flush(RowImpl.java:856) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushAndUpdate(P reparedStatementManagerImpl.java:116) at org.apache.openjpa.jdbc.kernel.BatchingPreparedStatementManagerImpl.flushAnd Update(BatchingPreparedStatementManagerImpl.java:81) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flushInternal(Pr eparedStatementManagerImpl.java:99) at org.apache.openjpa.jdbc.kernel.PreparedStatementManagerImpl.flush(PreparedSt atementManagerImpl.java:87) ... 21 more ------=_NextPart_000_00CD_01CAEB2E.E453F190--