com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'lastActive' at row 1 Error Code: 0 Call: INSERT INTO session (endTime, idPlanTarifar, lastActive, sessionNumber, startTime, userid) VALUES (?, ?, ?, ?, ?, ?) bind => [6 parameters bound] Query: InsertObjectQuery(edevize.jpa.entities.Session[ idSesiune=null ])

tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    JPA Exception "Internal Exception: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value"

    Stack Overflow | 10 months ago | Robert Andrei Damian
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'lastActive' at row 1 Error Code: 0 Call: INSERT INTO session (endTime, idPlanTarifar, lastActive, sessionNumber, startTime, userid) VALUES (?, ?, ?, ?, ?, ?) bind => [6 parameters bound] Query: InsertObjectQuery(edevize.jpa.entities.Session[ idSesiune=null ])

    Root Cause Analysis

    1. com.mysql.jdbc.MysqlDataTruncation

      Data truncation: Incorrect datetime value: '' for column 'lastActive' at row 1 Error Code: 0 Call: INSERT INTO session (endTime, idPlanTarifar, lastActive, sessionNumber, startTime, userid) VALUES (?, ?, ?, ?, ?, ?) bind => [6 parameters bound] Query: InsertObjectQuery(edevize.jpa.entities.Session[ idSesiune=null ])

      at org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit()
    2. EclipseLink (non-OSGi)
      EntityTransactionImpl.commit
      1. org.eclipse.persistence.internal.jpa.transaction.EntityTransactionImpl.commit(EntityTransactionImpl.java:157)
      1 frame
    3. edevize.tomcat.server
      PostSessionServlet.doPost
      1. edevize.tomcat.server.PostSessionServlet.doPost(PostSessionServlet.java:64)
      1 frame
    4. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:648)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:729)
      2 frames
    5. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:230)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      2 frames
    6. Tomcat WS
      WsFilter.doFilter
      1. org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)
      1 frame
    7. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:192)
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:165)
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:108)
      5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:522)
      6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)
      7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79)
      8. org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620)
      9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)
      10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:349)
      10 frames
    8. Grizzly HTTP
      SocketProcessorBase.run
      1. org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:1110)
      2. org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)
      3. org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:785)
      4. org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1425)
      5. org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)
      5 frames
    9. Java RT
      ThreadPoolExecutor$Worker.run
      1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
      2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
      2 frames
    10. Tomcat Util
      TaskThread$WrappingRunnable.run
      1. org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
      1 frame
    11. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)
      1 frame