java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via GitHub by andris155
, 1 year ago
'NaN' is not a valid numeric or approximate numeric value
via Stack Overflow by p3ace
, 5 months ago
via GitHub by andris155
, 1 year ago
'NaN' is not a valid numeric or approximate numeric value
via Stack Overflow by aminos
, 2 years ago
'NaN' is not a valid numeric or approximate numeric value
via Stack Overflow by sorin penteleiciuc
, 10 months ago
The connection property 'failOverReadOnly' only accepts values of the form: 'true', 'false', 'yes' or 'no'. The value 'false,address=(type=master)(protocol=tcp)(host=localhost)(port=3306)(user=test)(password=test)/dbname2?failOverReadOnly=false' is not in this set.
via oodlestechnologies.com by Unknown author, 1 year ago
Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3252)
at de.Keyle.MyPet.util.hikari.pool.HikariProxyPreparedStatement.setDouble(HikariProxyPreparedStatement.java)
at de.Keyle.MyPet.repository.types.MySqlRepository$9.run(MySqlRepository.java:971)
at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:58)
at org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
at com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
at java.lang.Thread.run(Unknown Source)

Users with the same issue

Once, 1 day ago
5 times, 2 days ago
Once, 5 days ago
4 times, 1 week ago
77 times, 2 weeks ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.