java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1

Atlassian JIRA | Immanuel Siagian [Atlassian] | 1 year ago
  1. 0

    h3. Summary Importing a word file with more than 255 characters in its heading will cause HibernateSystemException ERROR h3. Steps to reproduce # Create a word file with multiple headings. One of the headings contains a sentence that is more than 255 characters # Select the "Import Word Document" and select the word document that was just created # Select {{Level 3 Headings}} for {{Split by heading:}} # It will throw an ERROR h3. Expected Results Confluence should throw an INFO/WARNING saying that one of the headings contains more than 255 characters. As such, it cannot complete the import h3. Actual Results It will throw the following ERROR {noformat} Cause org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) caused by: net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:475) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) Stack Trace:[hide] org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:477) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:378) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:146) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:173) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.ja ... {noformat} h3.Workaround Modify the sentence to be less than 255 characters

    Atlassian JIRA | 1 year ago | Immanuel Siagian [Atlassian]
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1
  2. 0

    h3. Summary Importing a word file with more than 255 characters in its heading will cause HibernateSystemException ERROR h3. Steps to reproduce # Create a word file with multiple headings. One of the headings contains a sentence that is more than 255 characters # Select the "Import Word Document" and select the word document that was just created # Select {{Level 3 Headings}} for {{Split by heading:}} # It will throw an ERROR h3. Expected Results Confluence should throw an INFO/WARNING saying that one of the headings contains more than 255 characters. As such, it cannot complete the import h3. Actual Results It will throw the following ERROR {noformat} Cause org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) caused by: net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:475) caused by: net.sf.hibernate.exception.GenericJDBCException: Could not execute JDBC batch update at net.sf.hibernate.exception.ErrorCodeConverter.handledNonSpecificException(ErrorCodeConverter.java:90) caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055) caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'TITLE' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4235) Stack Trace:[hide] org.springframework.orm.hibernate.HibernateSystemException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280]; nested exception is net.sf.hibernate.HibernateException: could not insert: [com.atlassian.confluence.core.BodyContent#6488280] at org.springframework.orm.hibernate.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:597) at org.springframework.orm.hibernate.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:353) at org.springframework.orm.hibernate.HibernateTemplate.execute(HibernateTemplate.java:375) at org.springframework.orm.hibernate.HibernateTemplate.executeFind(HibernateTemplate.java:341) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:477) at com.atlassian.hibernate.HibernateObjectDao.findNamedQueryStringParams(HibernateObjectDao.java:378) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:146) at com.atlassian.confluence.pages.persistence.dao.hibernate.HibernatePageDao.getPage(HibernatePageDao.java:173) at com.atlassian.confluence.pages.persistence.dao.hibernate.CachingPageDao$1.getBySpaceAndTitle(CachingPageDao.ja ... {noformat} h3.Workaround Modify the sentence to be less than 255 characters

    Atlassian JIRA | 1 year ago | Immanuel Siagian [Atlassian]
    java.sql.BatchUpdateException: Data truncation: Data too long for column 'TITLE' at row 1
  3. 0

    How to Avoid 'Data truncated for column' in Mysql Database Using java?

    Stack Overflow | 4 years ago | Java Developer
    java.sql.BatchUpdateException: Data truncated for column 'REPEAT_DAYS' at row 1
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Updates mysql JDBC driver from 5.1.6 to 5.1.35 by aruizca · Pull Request #15 · AtlasOfLivingAustralia/ala-cas · GitHub

    github.com | 1 year ago
    org.hibernate.exception.LockAcquisitionException: Could not execute JDBC batch update
  6. 0

    Ocassional error in DB updating on backend

    GitHub | 9 months ago | jendakol
    java.sql.BatchUpdateException: Duplicate entry '1431' for key 'PRIMARY'

    1 unregistered visitors
    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.BatchUpdateException

      Data truncation: Data too long for column 'TITLE' at row 1

      at com.mysql.jdbc.PreparedStatement.executeBatchSerially()
    2. MySQL jdbc
      PreparedStatement.executeBatchSerially
      1. com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2055)
      1 frame