Hi All,
here is the confusioning Problem I am facing now: in the code I have an Java object TestObject with field Double value, I tried to set up Double.MAX_VALUE to the field then persist the object to Oracle DB with Hibernate.

How ever I got the exception :
2016-10-18 11:20:00,159 WARN [main] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: SQL Error: 17001, SQLState: 99999
2016-10-18 11:20:00,160 ERROR [main] org.hibernate.engine.jdbc.spi.SqlExceptionHelper: Interner Fehler: Overflow Exception trying to bind -1.7976931348623157E+308


After that I tried to change the type in entity object instead of Double to Decimal, but still get the same exception.
In the Oracle DB the field is with Type: BINARY_DOUBLE

Any suggestion on this will be welcomed!

thanks!

The maximum allowed value in a BINARY_DOUBLE is:



while the Java Double.MAX_VALUE seems to be higher:



Now, what business use case do you have that you need to store such a high value?

thanks for your quick reply, but I have an unlucky try: still have the exception. and further more I reduce the value to 1.7E+308 still get this exception.

Make sure that the database column type is `BINARY_DOUBLE`. Open an Oracle SQL console and check the maximum value that you can set using plain SQL.