openjpa-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "C N Davies" <...@cndavies.com>
Subject What is a NaN?
Date Mon, 03 May 2010 16:09:52 GMT
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: <openjpa-2.0.0-r422266:935683 fatal general error>
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: <openjpa-2.0.0-r422266:935683 fatal general error>
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

 

 

 

 


Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message