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 ])

  1. 0

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

    Stack Overflow | 4 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 ])
  2. 0

    Hibernate 5 + Java 8 LocalDateTime

    Stack Overflow | 1 year ago | Asaak
    org.hibernate.exception.DataException: could not execute statement
  3. 0

    insert null for DATETIME Field through PrepareStatement using jdbc

    Stack Overflow | 2 years ago | Rajesh Hatwar
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: 'NULL' for column 'dob' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: 'null' for column '_°Ù¶ÈÖªµÀ

    baidu.com | 1 year ago
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: 'null' for column 'newsDate' at row 1
  6. 0

    Re: [eclipselink-dev] Build Failed - EclipseLink Bootstrap Automated Bui

    eclipse.org | 4 months ago
    com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'F_NAME' at row 1 Error Code: 0 Call: INSERT INTO CMP3_EMPLOYEE (EMP_ID, GENDER, L_NAME, PAY_SCALE, ROOM_NUM, STATUS, VERSION, F_NAME, START_DATE, END_DATE, START_TIME, END_TIME, START_OVERTIME, END_OVERTIME, FORMER_COMPANY, FORMER_START_DATE, FORMER_END_DATE, DEPT_ID, ADDR_ID, MANAGER_EMP_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [32852, null, null, null, 0, null, 1, firstName_maxfieldLength_0000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, null, null, null, null, null, null, null, null, null, null, null, null] Query: InsertObjectQuery(Employee: 32852) [EL Info]: 2008.10.16 12:54:40.728--ServerSession(135923738)--EclipseLink, version: Eclipse Persistence Services - 1.1.0 (Build 20081016) [EL Severe]: 2008.10.16 12:54:40.810--ServerSession(135923738)--Local Exception Stack: [junit] Exception [EclipseLink-0] (Eclipse Persistence Services - 1.1.0 (Build 20081016)): org.eclipse.persistence.exceptions.IntegrityException Descriptor Exceptions: [junit] --------------------------------------------------------- [junit] Exception [EclipseLink-48] (Eclipse Persistence Services - 1.1.0 (Build 20081016)): org.eclipse.persistence.exceptions.DescriptorException Exception Description: Multiple writable mappings exist for the field [WRONGANNOTATION.F_NAME]. Only one may be defined as writable, all others must be specified read-only. Mapping: org.eclipse.persistence.mappings.DirectToFieldMapping[firstName-->WRONGANNOTATION.F_NAME] Descriptor: RelationalDescriptor(org.eclipse.persistence.testing.models.jpa.validationfailed.WrongAnnotation --> [DatabaseTable(WRONGANNOTATION)]) [junit] Runtime Exceptions: [junit] --------------------------------------------------------- [junit] at org.eclipse.persistence.internal.sessions.DatabaseSessionImpl.initializeDescriptors(DatabaseSessionImpl.java:475)

    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. 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