org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE BATCH_STEP_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE STEP_EXECUTION_ID = ?]; data exception: string data, right truncation; nested exception is java.sql.SQLDataException: data exception: string data, right truncation

Stack Overflow | Paul Campbell | 3 months ago
  1. 0

    spring batch jobrepository causing dataintegrityviolationexception

    Stack Overflow | 3 months ago | Paul Campbell
    org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [UPDATE BATCH_STEP_EXECUTION_CONTEXT SET SHORT_CONTEXT = ?, SERIALIZED_CONTEXT = ? WHERE STEP_EXECUTION_ID = ?]; data exception: string data, right truncation; nested exception is java.sql.SQLDataException: data exception: string data, right truncation
  2. 0

    [NoEclipse Branch] Exception Thrown when saving data related to StudentStatus

    GitHub | 3 years ago | hirokiterashima
    org.springframework.dao.DataIntegrityViolationException: could not insert: [org.wise.vle.domain.status.StudentStatus]; SQL [insert into studentStatus (id, periodId, runId, status, timestamp, workgroupId) values (null, ?, ?, ?, ?, ?)]; nested exception is org.hibernate.exception.DataException: could not insert: [org.wise.vle.domain.status.StudentStatus]
  3. 0

    Hibernate 4.1 with HSQLDB gives 'data exception: string data, right truncation'

    Stack Overflow | 4 years ago | Kronis
    javax.persistence.PersistenceException: org.hibernate.exception.DataException: could not insert: [org.project.model.Cv]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Feed Import breaks up

    GitHub | 3 years ago | dehenne
    javax.persistence.PersistenceException: org.hibernate.exception.DataException: data exception: string data, right truncation; table: T_FEED column: FED_TITLE_C
  6. 0

    DataException when trying to persist Entity

    soso.io | 1 year ago
    javax.persistence.PersistenceException: org.hibernate.exception.DataException: data exception: string data, right truncation; table: NOTE column: DATE

  1. andyglick 2 times, last 3 weeks ago
  2. marcbouvierdav 1 times, last 1 month ago
  3. WoodenDoors 67 times, last 7 months ago
87 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. org.hsqldb.HsqlException

    data exception: string data, right truncation

    at org.hsqldb.error.Error.error()
  2. HyperSQL Database
    Error.error
    1. org.hsqldb.error.Error.error(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    2. org.hsqldb.error.Error.error(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    2 frames
  3. HSQLDB
    JDBCPreparedStatement.executeUpdate
    1. org.hsqldb.types.CharacterType.castOrConvertToType(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    2. org.hsqldb.types.CharacterType.convertToType(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    3. org.hsqldb.StatementDML.getUpdatedData(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    4. org.hsqldb.StatementDML.executeUpdateStatement(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    5. org.hsqldb.StatementDML.getResult(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    6. org.hsqldb.StatementDMQL.execute(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    7. org.hsqldb.Session.executeCompiledStatement(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    8. org.hsqldb.Session.execute(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    9. org.hsqldb.jdbc.JDBCPreparedStatement.fetchResult(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    10. org.hsqldb.jdbc.JDBCPreparedStatement.executeUpdate(Unknown Source)[hsqldb-2.3.3.jar!/:2.3.3]
    10 frames
  4. Spring Framework
    JdbcTemplate.update
    1. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:873)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:866)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:629)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:866)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:927)[spring-jdbc-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    5 frames
  5. Spring Batch Core
    SimpleJobRepository.updateExecutionContext
    1. org.springframework.batch.core.repository.dao.JdbcExecutionContextDao.persistSerializedContext(JdbcExecutionContextDao.java:233)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2. org.springframework.batch.core.repository.dao.JdbcExecutionContextDao.updateExecutionContext(JdbcExecutionContextDao.java:161)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    3. org.springframework.batch.core.repository.support.SimpleJobRepository.updateExecutionContext(SimpleJobRepository.java:205)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    3 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_77]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_77]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_77]
    4. java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_77]
    4 frames
  7. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3 frames
  8. Spring Tx
    TransactionInterceptor.invoke
    1. org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)[spring-tx-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)[spring-tx-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)[spring-tx-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3 frames
  9. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2 frames
  10. com.sun.proxy
    $Proxy79.updateExecutionContext
    1. com.sun.proxy.$Proxy79.updateExecutionContext(Unknown Source)[na:na]
    1 frame
  11. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_77]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_77]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_77]
    4. java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_77]
    4 frames
  12. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3 frames
  13. Spring Batch Core
    SimpleBatchConfiguration$PassthruAdvice.invoke
    1. org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    1 frame
  14. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2 frames
  15. com.sun.proxy
    $Proxy79.updateExecutionContext
    1. com.sun.proxy.$Proxy79.updateExecutionContext(Unknown Source)[na:na]
    1 frame
  16. Spring Batch Core
    TaskletStep$ChunkTransactionCallback.doInTransaction
    1. org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:451)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2. org.springframework.batch.core.step.tasklet.TaskletStep$ChunkTransactionCallback.doInTransaction(TaskletStep.java:330)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2 frames
  17. Spring Tx
    TransactionTemplate.execute
    1. org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)[spring-tx-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    1 frame
  18. Spring Batch Core
    StepContextRepeatCallback.doInIteration
    1. org.springframework.batch.core.step.tasklet.TaskletStep$2.doInChunkContext(TaskletStep.java:271)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2. org.springframework.batch.core.scope.context.StepContextRepeatCallback.doInIteration(StepContextRepeatCallback.java:81)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2 frames
  19. Spring Batch Infrastructure
    RepeatTemplate.iterate
    1. org.springframework.batch.repeat.support.RepeatTemplate.getNextResult(RepeatTemplate.java:374)[spring-batch-infrastructure-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2. org.springframework.batch.repeat.support.RepeatTemplate.executeInternal(RepeatTemplate.java:215)[spring-batch-infrastructure-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    3. org.springframework.batch.repeat.support.RepeatTemplate.iterate(RepeatTemplate.java:144)[spring-batch-infrastructure-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    3 frames
  20. Spring Batch Core
    SimpleJobLauncher$1.run
    1. org.springframework.batch.core.step.tasklet.TaskletStep.doExecute(TaskletStep.java:257)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    2. org.springframework.batch.core.step.AbstractStep.execute(AbstractStep.java:200)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    3. org.springframework.batch.core.job.SimpleStepHandler.handleStep(SimpleStepHandler.java:148)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    4. org.springframework.batch.core.job.AbstractJob.handleStep(AbstractJob.java:392)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    5. org.springframework.batch.core.job.SimpleJob.doExecute(SimpleJob.java:135)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    6. org.springframework.batch.core.job.AbstractJob.execute(AbstractJob.java:306)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    7. org.springframework.batch.core.launch.support.SimpleJobLauncher$1.run(SimpleJobLauncher.java:135)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    7 frames
  21. Spring Core
    SyncTaskExecutor.execute
    1. org.springframework.core.task.SyncTaskExecutor.execute(SyncTaskExecutor.java:50)[spring-core-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    1 frame
  22. Spring Batch Core
    SimpleJobLauncher.run
    1. org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:128)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    1 frame
  23. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_77]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_77]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_77]
    4. java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_77]
    4 frames
  24. Spring AOP
    ReflectiveMethodInvocation.proceed
    1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3 frames
  25. Spring Batch Core
    SimpleBatchConfiguration$PassthruAdvice.invoke
    1. org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:127)[spring-batch-core-3.0.7.RELEASE.jar!/:3.0.7.RELEASE]
    1 frame
  26. Spring AOP
    JdkDynamicAopProxy.invoke
    1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)[spring-aop-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2 frames
  27. com.sun.proxy
    $Proxy77.run
    1. com.sun.proxy.$Proxy77.run(Unknown Source)[na:na]
    1 frame
  28. uk.ac.fife
    BatchScheduler.runJob
    1. uk.ac.fife.studentseeding.batch.BatchScheduler.runJob(BatchScheduler.java:117)[studentseeding-service-1.16.1.jar!/:na]
    1 frame
  29. Java RT
    Method.invoke
    1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.8.0_77]
    2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)[na:1.8.0_77]
    3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.8.0_77]
    4. java.lang.reflect.Method.invoke(Method.java:498)[na:1.8.0_77]
    4 frames
  30. Spring Context
    ReschedulingRunnable.run
    1. org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:65)[spring-context-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    2. org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)[spring-context-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3. org.springframework.scheduling.concurrent.ReschedulingRunnable.run(ReschedulingRunnable.java:81)[spring-context-4.2.6.RELEASE.jar!/:4.2.6.RELEASE]
    3 frames
  31. Java RT
    Thread.run
    1. java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)[na:1.8.0_77]
    2. java.util.concurrent.FutureTask.run(FutureTask.java:266)[na:1.8.0_77]
    3. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(ScheduledThreadPoolExecutor.java:180)[na:1.8.0_77]
    4. java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:293)[na:1.8.0_77]
    5. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)[na:1.8.0_77]
    6. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)[na:1.8.0_77]
    7. java.lang.Thread.run(Thread.java:745)[na:1.8.0_77]
    7 frames