java.sql.SQLException: ORA-08177: can't serialize access for this transaction at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:269)

Stack Overflow | padis | 3 years ago
  1. 0

    Spring Batch ORA-08177: can't serialize access for this transaction when running single job, SERIALIZED isolation level

    Stack Overflow | 3 years ago | padis
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:269)
  2. 0

    MySQL Bugs: #74271: Generate post-4.1 hash for mem users when old_passwords=1

    mysql.com | 1 year ago
    java.sql.SQLException: The password hash doesn't h ave the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
  3. 0

    MySQL Bugs: #74271: Generate post-4.1 hash for mem users when old_passwords=1

    mysql.com | 1 year ago
    java.sql.SQLException: The password hash doesn't h ave the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-01461: can bind a LONG value only for inser... | Oracle Community

    oracle.com | 11 months ago
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column
  6. 0

    ORA-01461

    symmetricds | 6 years ago | messayed
    java.sql.SQLException: ORA-01461: can bind a LONG value only for insert into a LONG column

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

      ORA-08177: can't serialize access for this transaction at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:269)

      at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate()
    2. Spring Framework
      JdbcTemplate.update
      1. org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72)
      2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:603)
      3. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:812)
      4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:868)
      5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:872)
      5 frames
    3. Spring Batch Core
      SimpleJobRepository.createJobExecution
      1. org.springframework.batch.core.repository.dao.JdbcJobInstanceDao.createJobInstance(JdbcJobInstanceDao.java:105)
      2. org.springframework.batch.core.repository.support.SimpleJobRepository.createJobExecution(SimpleJobRepository.java:135)
      2 frames
    4. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    5. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    6. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110)
      1 frame
    7. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      1 frame
    8. Spring Batch Core
      AbstractJobRepositoryFactoryBean$1.invoke
      1. org.springframework.batch.core.repository.support.AbstractJobRepositoryFactoryBean$1.invoke(AbstractJobRepositoryFactoryBean.java:172)
      1 frame
    9. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    10. Unknown
      $Proxy27.createJobExecution
      1. $Proxy27.createJobExecution(Unknown Source)
      1 frame
    11. Spring Batch Core
      SimpleJobLauncher.run
      1. org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:124)
      1 frame
    12. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      4. java.lang.reflect.Method.invoke(Method.java:597)
      4 frames
    13. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:317)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:183)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150)
      3 frames
    14. Spring Batch Core
      SimpleBatchConfiguration$PassthruAdvice.invoke
      1. org.springframework.batch.core.configuration.annotation.SimpleBatchConfiguration$PassthruAdvice.invoke(SimpleBatchConfiguration.java:117)
      1 frame
    15. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    16. Unknown
      $Proxy61.run
      1. $Proxy61.run(Unknown Source)
      1 frame