default value for not map-able values?? (Double-Infinity)

ecologys · **Joined:** Thu Jul 10, 2008 8:20 am **Posts:** 2

Hi,

Hibernate Version: 3.2.6.ga

I have a class with few Double-values to write in the Database. With HSQLDB it works fine.

I switched now to MySQL, and I get following Error Message:

Quote:

14:10:04,184 INFO DoubleType:144 - could not bind value 'Infinity' to parameter: 13; 'Infinity' is not a valid numeric or approximate numeric value

The reason for this error is clear, the Double value is set to Infinity and hibernate is not able to map Infinity to a mysql-double.

Now my question, is there maybe a way to set a default value for not map-able values?

For example:
every times the translator receives a 'Infinity' -> map it to '100.000'.

Thx in advance

Cameron McKenzie · **Posted:** Thu Jul 10, 2008 11:01 am

Quote:

"MySQL Server can't yet handle NaN, -Inf, and Inf values in double. Using these will cause problems when trying to export and import data. We should as an intermediate solution change NaN to NULL (if possible) and -Inf and Inf to the minimum respective maximum possible double value. "

Looks like there's a setting on the MySQL/ConnectorJ datasource properties file that allows you to configure NAN settings:

Quote:

allowNanAndInf Should the driver allow NaN or +/- INF values in PreparedStatement.setDouble()? No false

ecologys · **Joined:** Thu Jul 10, 2008 8:20 am **Posts:** 2

Thanks for your help

Sorry that I posted in this forum but I was convinced that this must be a hibernate error. I didn't thought about the possiblity that MySQL is the malefactor ...

Thx again