java.sql.SQLException: String or binary data would be truncated.

Atlassian JIRA | Rashit A. Fakhreyev | 1 decade ago
  1. 0

    [CONF-3563] Failed to restore from backup version 1.3.2 - Atlassian JIRA

    atlassian.com | 12 months ago
    java.sql.SQLException: String or binary data would be truncated.
  2. 0

    Cause: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Stack Trace: [hide] (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Referer URL: http://ahf-web/confluence/setup/setup-restore-local.action Build Information: Uptime: 4 minutes, 53 seconds Version: 1.4.2 Build Number: 214 Server Information: Application Server: Orion/2.0.5 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 254 MB Free Memory: 18 MB Used Memory: 236 MB System Information: System Date: ???????, 14 ??? 2005 System Time: 11:31:09 System Favourite Colour: Lime Java Version: 1.4.2_08 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_08-b03 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Asia/Novosibirsk Operating System: Windows 2000 5.0 OS Architecture: x86 Request Information: URL: http://ahf-web/confluence/500page.jsp - Scheme: http - Server: ahf-web - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.servlet_name : action - javax.servlet.error.message : (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1f75107 - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /confluence/setup/setup-restore-local.action - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - localFileName = daily-backup-14???2005.zip - buildIndex = true Logging: 8 log statements generated by this request: [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] String or binary data would be truncated. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [com.atlassian.confluence.importexport.impl.BackupImporter] Error while upgrading imported data (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. Throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:31:08 NOVST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)

    Atlassian JIRA | 1 decade ago | Rashit A. Fakhreyev
    java.sql.SQLException: String or binary data would be truncated.
  3. 0

    Cause: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Stack Trace: [hide] (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. Referer URL: http://ahf-web/confluence/setup/setup-restore-local.action Build Information: Uptime: 4 minutes, 53 seconds Version: 1.4.2 Build Number: 214 Server Information: Application Server: Orion/2.0.5 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 254 MB Free Memory: 18 MB Used Memory: 236 MB System Information: System Date: ???????, 14 ??? 2005 System Time: 11:31:09 System Favourite Colour: Lime Java Version: 1.4.2_08 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_08-b03 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Asia/Novosibirsk Operating System: Windows 2000 5.0 OS Architecture: x86 Request Information: URL: http://ahf-web/confluence/500page.jsp - Scheme: http - Server: ahf-web - Port: 80 - URI: /confluence/500page.jsp - - Context Path: /confluence - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: null Attributes: - javax.servlet.error.servlet_name : action - javax.servlet.error.message : (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.exception : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1f75107 - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /confluence/setup/setup-restore-local.action - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - sessioninview.FILTERED : true - com.atlassian.core.filters.gzip.GzipFilter_already_filtered : true Parameters: - localFileName = daily-backup-14???2005.zip - buildIndex = true Logging: 8 log statements generated by this request: [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] String or binary data would be truncated. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:30:44 NOVST 2005 [com.atlassian.confluence.importexport.impl.BackupImporter] Error while upgrading imported data (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. Throwable: org.springframework.dao.DataIntegrityViolationException: (Hibernate operation): data integrity violated by SQL ''; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821) at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863) at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52) [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.util.JDBCExceptionReporter] Unspecified error returned. [ERROR] Thu Jul 14 11:30:48 NOVST 2005 [net.sf.hibernate.impl.SessionImpl] Could not synchronize database state with session [ERROR] Thu Jul 14 11:31:08 NOVST 2005 [com.opensymphony.webwork.dispatcher.ServletDispatcher] Could not execute action Throwable: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL ''; nested exception is java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. java.sql.SQLException: Violation of PRIMARY KEY constraint 'PK__os_group__690797E6'. Cannot insert duplicate key in object 'os_group'. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2261) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:463)

    Atlassian JIRA | 1 decade ago | Rashit A. Fakhreyev
    java.sql.SQLException: String or binary data would be truncated.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Insert the text into a new page: [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] and then hit Update. The following exception is generated: Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at com.mchange.v2.sql.filter.FilterPreparedStatement.executeUpdate(FilterPreparedStatement.java:71) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:386) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:316) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:179) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:72) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:148) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) Referer URL: http://sunseeker.uk.db.com/pages/editpage.action?pageId=84883 Build Information: Uptime: 18 days, 14 minutes, 43 seconds Version: 1.2 Build Number: 58 Server Information: Application Server: Apache Tomcat/4.1.29 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 208 MB Free Memory: 72 MB Used Memory: 136 MB System Information: System Date: Tuesday, 05 Oct 2004 System Time: 16:07:28 System Favourite Colour: Jet Black Java Version: 1.4.2_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_05-b04 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Europe/London Operating System: Windows 2003 5.2 OS Architecture: x86 Request Information: URL: http://sunseeker.uk.db.com/pages/doeditpage.action - Scheme: http - Server: sunseeker.uk.db.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: pageId=84883 Attributes: - com.atlassian.confluence.setup.SpringSessionInViewFilter.sessionFactory : true - javax.servlet.error.message : - javax.servlet.error.exception : java.lang.IllegalStateException: ClobStringType requires active transaction synchronization - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /pages/doeditpage.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1e01391 - atlassian.core.seraph.original.url : /pages/doeditpage.action?pageId=84883 - loginfilter.already.filtered : true - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Parameters: - selectedText = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - confirm = Update - content = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - originalVersion = 1 - sel2 = - sel1 = - parentPageTitle = - pageId = 84883

    Atlassian JIRA | 1 decade ago | Philip Harling
    java.sql.SQLException: String or binary data would be truncated.
  6. 0

    Insert the text into a new page: [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] and then hit Update. The following exception is generated: Cause: org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Stack Trace: [hide] org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. java.sql.SQLException: String or binary data would be truncated. at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392) at net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91) at net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:752) at net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710) at net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302) at net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282) at net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136) at net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290) at com.mchange.v2.sql.filter.FilterPreparedStatement.executeUpdate(FilterPreparedStatement.java:71) at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:468) at net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:442) at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:29) at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2414) at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2367) at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2236) at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61) at org.springframework.orm.hibernate.HibernateTransactionManager.doCommit(HibernateTransactionManager.java:386) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:316) at com.atlassian.confluence.util.XWorkTransactionInterceptor$1.beforeResult(XWorkTransactionInterceptor.java:124) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:179) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.DefaultWorkflowInterceptor.intercept(DefaultWorkflowInterceptor.java:55) at com.atlassian.confluence.core.ConfluenceWorkflowInterceptor.intercept(ConfluenceWorkflowInterceptor.java:33) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.atlassian.confluence.core.ConfluenceValidationInterceptor.intercept(ConfluenceValidationInterceptor.java:16) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.security.actions.PermissionCheckInterceptor.intercept(PermissionCheckInterceptor.java:40) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.pages.actions.PageAwareInterceptor.intercept(PageAwareInterceptor.java:72) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.core.ConfluenceAutowireInterceptor.intercept(ConfluenceAutowireInterceptor.java:25) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.user.actions.AuthenticatedUserInterceptor.intercept(AuthenticatedUserInterceptor.java:67) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.atlassian.confluence.util.XWorkTransactionInterceptor.intercept(XWorkTransactionInterceptor.java:133) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.interceptor.AroundInterceptor.intercept(AroundInterceptor.java:34) at com.opensymphony.xwork.DefaultActionInvocation.invoke(DefaultActionInvocation.java:163) at com.opensymphony.xwork.DefaultActionProxy.execute(DefaultActionProxy.java:115) at com.opensymphony.webwork.dispatcher.ServletDispatcher.serviceAction(ServletDispatcher.java:278) at com.opensymphony.webwork.dispatcher.ServletDispatcher.service(ServletDispatcher.java:248) at javax.servlet.http.HttpServlet.service(HttpServlet.java:853) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.opensymphony.module.sitemesh.filter.PageFilter.parsePage(PageFilter.java:145) at com.atlassian.confluence.util.profiling.ProfilingPageFilter.parsePage(ProfilingPageFilter.java:148) at com.opensymphony.module.sitemesh.filter.PageFilter.doFilter(PageFilter.java:61) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.SecurityFilter.doFilter(SecurityFilter.java:168) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.seraph.filter.LoginFilter.doFilter(LoginFilter.java:181) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.johnson.filters.JohnsonFilter.doFilter(JohnsonFilter.java:96) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.springframework.orm.hibernate.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:117) at bucket.custom.FlushingSpringSessionInViewFilter.doFilterInternal(FlushingSpringSessionInViewFilter.java:30) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:73) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.util.profiling.filters.ProfilingFilter.doFilter(ProfilingFilter.java:132) at com.atlassian.confluence.util.error.ProfilingAndErrorFilter.doFilter(ProfilingAndErrorFilter.java:26) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at com.atlassian.core.filters.AbstractEncodingFilter.doFilter(AbstractEncodingFilter.java:36) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:213) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:256) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2417) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:171) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:174) at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643) at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480) at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995) at org.apache.coyote.tomcat4.CoyoteAdapter.service(CoyoteAdapter.java:193) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:781) at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:549) at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:589) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:666) at java.lang.Thread.run(Thread.java:534) Referer URL: http://sunseeker.uk.db.com/pages/editpage.action?pageId=84883 Build Information: Uptime: 18 days, 14 minutes, 43 seconds Version: 1.2 Build Number: 58 Server Information: Application Server: Apache Tomcat/4.1.29 Servlet Version: 2.3 Database Dialect: net.sf.hibernate.dialect.SQLServerDialect Memory Information: Total Memory: 208 MB Free Memory: 72 MB Used Memory: 136 MB System Information: System Date: Tuesday, 05 Oct 2004 System Time: 16:07:28 System Favourite Colour: Jet Black Java Version: 1.4.2_05 Java Vendor: Sun Microsystems Inc. JVM Version: 1.0 JVM Vendor: Sun Microsystems Inc. JVM Implementation Version: 1.4.2_05-b04 Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition Java VM: Java HotSpot(TM) Client VM User Name: SYSTEM User Timezone: Europe/London Operating System: Windows 2003 5.2 OS Architecture: x86 Request Information: URL: http://sunseeker.uk.db.com/pages/doeditpage.action - Scheme: http - Server: sunseeker.uk.db.com - Port: 80 - URI: /500page.jsp - - Context Path: - - Servlet Path: /500page.jsp - - Path Info: null - - Query String: pageId=84883 Attributes: - com.atlassian.confluence.setup.SpringSessionInViewFilter.sessionFactory : true - javax.servlet.error.message : - javax.servlet.error.exception : java.lang.IllegalStateException: ClobStringType requires active transaction synchronization - os_securityfilter_already_filtered : true - com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true - javax.servlet.error.request_uri : /pages/doeditpage.action - javax.servlet.error.status_code : 500 - __sitemesh__filterapplied : true - javax.servlet.error.servlet_name : action - webwork.valueStack : com.opensymphony.xwork.util.OgnlValueStack@1e01391 - atlassian.core.seraph.original.url : /pages/doeditpage.action?pageId=84883 - loginfilter.already.filtered : true - javax.servlet.jsp.jspException : org.springframework.dao.DataIntegrityViolationException: (HibernateTemplate): data integrity violated by SQL 'null'; nested exception is java.sql.SQLException: String or binary data would be truncated. Parameters: - selectedText = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - confirm = Update - content = [http://epm.ge.gto.cib.intranet.db.com/pmo/pmo_event_results.jsp?program=3642&program=2030&program=4124&program=3653&program=3658&program=2029&program=2038&program=3652&projectID=0&region=0&strategic=0&milestoneType=0&milestoneStatus=0&category=12&startDate=01+Jul+2004&endDate=31+Dec+2004&groupcode=EQP] - originalVersion = 1 - sel2 = - sel1 = - parentPageTitle = - pageId = 84883

    Atlassian JIRA | 1 decade ago | Philip Harling
    java.sql.SQLException: String or binary data would be truncated.

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

      String or binary data would be truncated.

      at net.sourceforge.jtds.jdbc.SqlMessage.toSQLException()
    2. jTDS
      PreparedStatement_base.executeUpdate
      1. net.sourceforge.jtds.jdbc.SqlMessage.toSQLException(SqlMessage.java:392)
      2. net.sourceforge.jtds.jdbc.SQLWarningChain.addOrReturn(SQLWarningChain.java:91)
      3. net.sourceforge.jtds.jdbc.Tds.goToNextResult(Tds.java:750)
      4. net.sourceforge.jtds.jdbc.TdsStatement.getMoreResults(TdsStatement.java:710)
      5. net.sourceforge.jtds.jdbc.TdsStatement.executeCallImpl(TdsStatement.java:302)
      6. net.sourceforge.jtds.jdbc.TdsStatement.internalExecuteCall(TdsStatement.java:282)
      7. net.sourceforge.jtds.jdbc.PreparedStatement_base.execute(PreparedStatement_base.java:136)
      8. net.sourceforge.jtds.jdbc.PreparedStatement_base.executeUpdate(PreparedStatement_base.java:290)
      8 frames
    3. net.sf.hibernate
      SQLQueryImpl.list
      1. net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java:22)
      2. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:462)
      3. net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:436)
      4. net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:37)
      5. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2449)
      6. net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java:2435)
      7. net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2392)
      8. net.sf.hibernate.impl.SessionImpl.autoFlushIfRequired(SessionImpl.java:1821)
      9. net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3863)
      10. net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:52)
      10 frames