Skip to main content
krishnav9816
krishnav9816
December 3, 2022
Question

error in process model Data truncated for column

  • December 3, 2022
  • 1 reply
  • 0 views

An error occurred while trying to write to the entity "StudentEducationDetails" [id=d95007c3-ee01-472a-b90c-0dbf8570a6e0@5696, type=StudentEducationDetails (id=4074)] (data store: StudentBasicInformation). Details: javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: could not execute statement: org.hibernate.exception.JDBCConnectionException: could not execute statement: java.sql.SQLTransientConnectionException: (conn=468975) Data truncated for column 'StartYear' at row 1: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Data truncated for column 'StartYear' at row 1: java.sql.SQLException: Data truncated for column 'StartYear' at row 1 Data: TypedValue[it=4074,v={<null>,<null>,Jabar,B.tech,2017-11-01,2021-12-07,90,1,2022-11-28 04:30:00.0,NRT}]

    1 reply

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    December 3, 2022

    Do you try to store the start year as a string? I do not see any year like value in your data. I suggest to change the data type to integer and then only write the year part of the date into that field.

    Terms & ConditionsAccessibility statement