java.sql.SQLException

There are no available Samebug tips for this exception. Do you have an idea how to solve this issue? A short tip would help users who saw this issue last week.

  • GitHub comment 944#247921465
    via GitHub by zouguobing
    ,
  • MySQL lock table size Exception
    via by Unknown author,
  • On attempted import of a word document with some very long section headings the following error appears in the log: 2014-11-18 10:14:04,948 ERROR [ajp-bio-127.0.0.1-15279-exec-637] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session -- url: /confluence/pages/worddav/doimportword.action | page: 18189078 | userName: xxxxx | referer: https://srv.example.com/confluence/pages/worddav/importword.action | action: doimportword 2014-11-18 10:14:05,015 ERROR [ajp-bio-127.0.0.1-15279-exec-637] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action -- url: /confluence/pages/worddav/doimportword.action | userName: xxxxx | referer: https://srv.example.com/confluence/pages/worddav/importword.action org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#19038545]; uncategorized SQLException for SQL []; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255) ; nested exception is java.sql.SQLException: ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) -- This looks to me like the import function allows one character more than the length the database field was configured for. Perhaps this is an unaccounted-for terminator such as a linefeed.
    via by Michael Ionescu,
  • On attempted import of a word document with some very long section headings the following error appears in the log: 2014-11-18 10:14:04,948 ERROR [ajp-bio-127.0.0.1-15279-exec-637] [sf.hibernate.impl.SessionImpl] execute Could not synchronize database state with session -- url: /confluence/pages/worddav/doimportword.action | page: 18189078 | userName: xxxxx | referer: https://srv.example.com/confluence/pages/worddav/importword.action | action: doimportword 2014-11-18 10:14:05,015 ERROR [ajp-bio-127.0.0.1-15279-exec-637] [atlassian.confluence.servlet.ConfluenceServletDispatcher] sendError Could not execute action -- url: /confluence/pages/worddav/doimportword.action | userName: xxxxx | referer: https://srv.example.com/confluence/pages/worddav/importword.action org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not insert: [com.atlassian.confluence.links.OutgoingLink#19038545]; uncategorized SQLException for SQL []; SQL state [72000]; error code [12899]; ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255) ; nested exception is java.sql.SQLException: ORA-12899: value too large for column "DBUCONFLP01"."LINKS"."DESTPAGETITLE" (actual: 256, maximum: 255) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83) at org.springframework.orm.hibernate.HibernateAccessor.convertJdbcAccessException(HibernateAccessor.java:364) -- This looks to me like the import function allows one character more than the length the database field was configured for. Perhaps this is an unaccounted-for terminator such as a linefeed.
    via by Michael Ionescu,
  • mybatis-user - sqlKind = UNINITIALIZED
    via by Unknown author,
    • java.sql.SQLException: connection holder is null at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)[spring-jdbc-3.2.13.RELEASE.jar:3.2.13.RELEASE]

    Users with the same issue

    PizPiz
    6 times, last one,
    kidkid
    1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    Unknown visitor
    Unknown visitor1 times, last one,
    qavidqavid
    1 times, last one,
    3 more bugmates