Hi there,

I have been struggling with this for the day, and I wonder if I can get some help. Thanks very much in advance!

I have a table with a BINARY_DOUBLE column on an Oracle 11g. In my Java POJO, the corresponding field has java.lang.Double type. When I try to persist Double.NaN using Hibernate, I got the following error:

09 Sep 2014 16:36:58,687 WARN SqlExceptionHelper []: SQL Error: 17001, SQLState: 99999
09 Sep 2014 16:36:58,687 ERROR SqlExceptionHelper []: Internal Error: Overflow Exception trying to bind NaN

I am using Hibernate Commons Annotations {4.0.4.Final}, Hibernate Validator 4.3.1.Final.

The same operation works if I use OraclePreparedStatement in JDBC:

String sql2 = "insert into TEST2 values(13, 'JDBC NaN Double', ?)";
OraclePreparedStatement preparedStmt = (OraclePreparedStatement) conn.prepareStatement(sql2);
preparedStmt.setBinaryDouble(1, Double.NaN);
preparedStmt.executeUpdate();

I apologize if this question had been asked and answered many times before. Thanks in advance for any hint.

Puze Yang