java.sql.SQLException: ORA-08177: can't serialize access for this transaction

spring.io | 5 months ago
  1. 0

    Could not open JDBC Connection for transaction java.sql.SQLException: ORA-00923: - Spring Forum

    spring.io | 5 months ago
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction
  2. 0

    Could not open JDBC Connection for transaction java.sql.SQLException: ORA-00923: - Spring Forum

    spring.io | 5 months ago
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction
  3. 0

    new problem on oracle

    symmetricds | 8 years ago | sunxh
    java.sql.SQLException: ORA-01400: can not insert NULL into("USR_DUANX"."SYM_TRIGGER_HIST"."COLUMN_NAMES")
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Spring4.0.2 and Hibernate4.3.5 integration issue

    Stack Overflow | 2 years ago | anilpeddi
    java.sql.SQLException: Missing IN or OUT parameter at index:: 14****

    4 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 oracle.jdbc.driver.DatabaseError.throwSqlException()
    2. Oracle jdbc
      OraclePreparedStatement.executeUpdate
      1. oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
      2. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
      3. oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
      4. oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
      5. oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
      6. oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
      7. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1170)
      8. oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
      9. oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3423)
      9 frames
    3. Commons DBCP
      DelegatingPreparedStatement.executeUpdate
      1. org.apache.commons.dbcp.DelegatingPreparedStatement.executeUpdate(DelegatingPreparedStatement.java:102)
      1 frame
    4. Spring Framework
      JdbcTemplate.update
      1. org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
      2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
      3. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
      4. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
      5. org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:854)
      5 frames
    5. Spring Batch Core
      SimpleJobRepository.createJobExecution
      1. org.springframework.batch.core.repository.dao.JdbcJobInstanceDao.createJobInstance(JdbcJobInstanceDao.java:117)
      2. org.springframework.batch.core.repository.support.SimpleJobRepository.createJobExecution(SimpleJobRepository.java:127)
      2 frames
    6. 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:585)
      4 frames
    7. Spring AOP
      ReflectiveMethodInvocation.proceed
      1. org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:307)
      2. org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:182)
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:149)
      3 frames
    8. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:106)
      1 frame
    9. Spring AOP
      JdkDynamicAopProxy.invoke
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:171)
      2. org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:204)
      2 frames
    10. Unknown
      $Proxy0.createJobExecution
      1. $Proxy0.createJobExecution(Unknown Source)
      1 frame
    11. Spring Batch Core
      CommandLineJobRunner.main
      1. org.springframework.batch.core.launch.support.SimpleJobLauncher.run(SimpleJobLauncher.java:102)
      2. org.springframework.batch.core.launch.support.CommandLineJobRunner.start(CommandLineJobRunner.java:207)
      3. org.springframework.batch.core.launch.support.CommandLineJobRunner.main(CommandLineJobRunner.java:254)
      3 frames
    12. Unknown
      FileToTableMain.main
      1. FileToTableMain.main(FileToTableMain.java:8)
      1 frame