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

GitHub | andris155 | 9 months ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    MyPet Premium 2.2.0 MySQL error

    GitHub | 9 months ago | andris155
    java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value
  2. 0

    MyPet v2.0.9 premium java.sql.SQLException

    GitHub | 11 months ago | andris155
    java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value
  3. 0

    talend convert string to int

    Stack Overflow | 2 years ago | aminos
    java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Mohammed got this error while testing Cartagene deployed on Onyx 1.1.0. Unfortunately I wasn't able to reproduce to crash so far. 2009-03-25 15:28:57,578 - INFO - $MenuItemSelectionBehavior - linkPageClass = HomePage, pageClass = HomePage 2009-03-25 15:28:57,578 - INFO - $MenuItemSelectionBehavior - linkPageClass = ParticipantSearchPage, pageClass = HomePage 2009-03-25 15:29:04,609 - WARN - .panel.StageSelectionPanel - Wrong status for stage HipsWaist 2009-03-25 15:29:04,609 - WARN - apache.wicket.Localizer - Tried to retrieve a localized string for a component that has not yet been added to the page. This can sometimes lead to an invalid or no localized resource returned. Make sure you are not calling Component#getString() inside your Component's constructor. Offending component: [MarkupContainer [Component id = stage-list]] 2009-03-25 15:30:09,890 - INFO - hibernate.type.DoubleType - could not bind value 'NaN' to parameter: 5; 'NaN' is not a valid numeric or approximate numeric value 2009-03-25 15:30:09,890 - WARN - util.JDBCExceptionReporter - SQL Error: 0, SQLState: S1009 2009-03-25 15:30:09,890 - ERROR - util.JDBCExceptionReporter - 'NaN' is not a valid numeric or approximate numeric value 2009-03-25 15:30:09,890 - ERROR - tractFlushingEventListener - Could not synchronize database state with session org.hibernate.exception.GenericJDBCException: could not update: [org.obiba.onyx.jade.core.domain.run.InstrumentRunValue#53] at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103) at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91) at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2430) at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2312) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2612) at org.hibernate.action.EntityUpdateAction.execute(EntityUpdateAction.java:96) at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:279) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:263) at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:168) at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298) at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27) at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000) at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:338) at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:106) at org.springframework.orm.hibernate3.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:655) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:732) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:701) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:321) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:116) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204) at $Proxy63.computeOutputParameters(Unknown Source) at sun.reflect.GeneratedMethodAccessor179.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source) at java.lang.reflect.Method.invoke(Unknown Source) at org.apache.wicket.proxy.LazyInitProxyFactory$JdkHandler.invoke(LazyInitProxyFactory.java:416) at org.apache.wicket.proxy.$Proxy62.computeOutputParameters(Unknown Source) at org.obiba.onyx.jade.core.wicket.wizard.OutputParametersStep.onStepOutNext(OutputParametersStep.java:80) at org.obiba.onyx.wicket.wizard.WizardForm.gotoNext(WizardForm.java:265) at org.obiba.onyx.wicket.wizard.WizardForm.onNextSubmit(WizardForm.java:189) at org.obiba.onyx.wicket.wizard.WizardForm$1.onSubmit(WizardForm.java:91) at org.apache.wicket.ajax.markup.html.form.AjaxButton$1.onSubmit(AjaxButton.java:86) at org.apache.wicket.ajax.form.AjaxFormSubmitBehavior.onEvent(AjaxFormSubmitBehavior.java:128) at org.apache.wicket.ajax.AjaxEventBehavior.respond(AjaxEventBehavior.java:163) at org.apache.wicket.ajax.AbstractDefaultAjaxBehavior.onRequest(AbstractDefaultAjaxBehavior.java:297) at org.apache.wicket.request.target.component.listener.BehaviorRequestTarget.processEvents(BehaviorRequestTarget.java:100) at org.apache.wicket.request.AbstractRequestCycleProcessor.processEvents(AbstractRequestCycleProcessor.java:91) at org.apache.wicket.RequestCycle.processEventsAndRespond(RequestCycle.java:1175) at org.apache.wicket.RequestCycle.step(RequestCycle.java:1252) at org.apache.wicket.RequestCycle.steps(RequestCycle.java:1353) at org.apache.wicket.RequestCycle.request(RequestCycle.java:493) at org.apache.wicket.protocol.http.WicketFilter.doGet(WicketFilter.java:355) at org.apache.wicket.protocol.http.WicketFilter.doFilter(WicketFilter.java:200) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286) at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:857) at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:565) at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1509) at java.lang.Thread.run(Unknown Source) Caused by: java.sql.SQLException: 'NaN' is not a valid numeric or approximate numeric value at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:926) at com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3214) at org.apache.commons.dbcp.DelegatingPreparedStatement.setDouble(DelegatingPreparedStatement.java:126) at org.hibernate.type.DoubleType.set(DoubleType.java:36) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:136) at org.hibernate.type.NullableType.nullSafeSet(NullableType.java:107) at org.hibernate.persister.entity.AbstractEntityPersister.dehydrate(AbstractEntityPersister.java:2002) at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:2376)

    JIRA | 8 years ago | Martin Boulanger
    org.hibernate.exception.GenericJDBCException: could not update: [org.obiba.onyx.jade.core.domain.run.InstrumentRunValue#53]
  6. 0

    How to use JDBC prepareStatement to insert Geometry data?

    Stack Overflow | 2 years ago | Leo Liu
    java.sql.SQLException: Parameter index out of range (2 > number of parameters, which is 1).

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. java.sql.SQLException

      'NaN' is not a valid numeric or approximate numeric value

      at com.mysql.jdbc.SQLError.createSQLException()
    2. MySQL jdbc
      PreparedStatement.setDouble
      1. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:959)
      2. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898)
      3. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887)
      4. com.mysql.jdbc.SQLError.createSQLException(SQLError.java:862)
      5. com.mysql.jdbc.PreparedStatement.setDouble(PreparedStatement.java:3252)
      5 frames
    3. de.Keyle.MyPet
      MySqlRepository$9.run
      1. de.Keyle.MyPet.util.hikari.pool.HikariProxyPreparedStatement.setDouble(HikariProxyPreparedStatement.java)
      2. de.Keyle.MyPet.repository.types.MySqlRepository$9.run(MySqlRepository.java:971)
      2 frames
    4. org.bukkit.craftbukkit
      CraftAsyncTask.run
      1. org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftTask.run(CraftTask.java:58)
      2. org.bukkit.craftbukkit.v1_10_R1.scheduler.CraftAsyncTask.run(CraftAsyncTask.java:53)
      2 frames
    5. com.destroystokyo.paper
      ServerSchedulerReportingWrapper.run
      1. com.destroystokyo.paper.ServerSchedulerReportingWrapper.run(ServerSchedulerReportingWrapper.java:22)
      1 frame
    6. Java RT
      Thread.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      3. java.lang.Thread.run(Unknown Source)
      3 frames