File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Object Relational Mapping and the fly likes MySQL, Hibernate, and allowNanAndInf Flag Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "MySQL, Hibernate, and allowNanAndInf Flag" Watch "MySQL, Hibernate, and allowNanAndInf Flag" New topic
Author

MySQL, Hibernate, and allowNanAndInf Flag

David Salosky
Greenhorn

Joined: Dec 20, 2011
Posts: 1
I have a java webapp using Hibernate backed by a MySQL database. I have a pojo that has a Double member variable which sometimes has a value of NaN (not a number). When I try to save the 'NaN' value to the database, I receive the following error message:



I googled my problem for a while and found that there is a MySQL connection string parameter called 'allowNanAndInf' which tells MySQL ConnectorJ to permit NaN in a double column. I added this parameter to my JDBC connection string, but the problem continued.

Does anyone have any other suggestions about how to save a 'NaN' value into a MySQL table using hibernate?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: MySQL, Hibernate, and allowNanAndInf Flag
 
Similar Threads
Solution for problems occured during mediation process configuration in jbilling
hibernate many to one question
Where are my sessions stored?
Could not execute batch Update Error in Project
EJB3:->Connection error occured