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

GitHub | andris155 | 5 months ago
  1. 0

    MyPet Premium 2.2.0 MySQL error

    GitHub | 5 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 | 7 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 | 1 year 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 | 1 year 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