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

Oracle Community | 352935 | 1 decade ago
  1. 0

    Bug in Oracle's handling of transaction isolation levels?

    Oracle Community | 1 decade ago | 352935
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction
  2. 0

    update oracle binary raw field

    Google Groups | 1 decade ago | Eric Abbott
    java.sql.SQLException: ORA-01465: invalid hex number
  3. 0

    Re: oracle database model dangerously broken

    db-ddlutils-user | 1 decade ago | Tim Dudgeon
    org.apache.ddlutils.DynaSqlException: Error while executing SQL -- Column PROP_VALUE_EXT in table MY_TABLE differs from current specification -- Table DR$POLICY_TAB can be dropped -- Table CS_SRS can be dropped -- Table OGIS_SPATIAL_REFERENCE_SYSTEMS can be dropped -- Table SDO_ANGLE_UNITS can be dropped -- Table SDO_AREA_UNITS can be dropped -- Table SDO_DATUMS can be dropped -- Table SDO_DIST_UNITS can be dropped -- Table SDO_ELLIPSOIDS can be dropped -- Table SDO_PROJECTIONS can be dropped -- Table USER_CS_SRS can be dropped -- Table USER_TRANSFORM_MAP can be dropped -- Table AUDIT_ACTIONS can be dropped -- Table AW$CWMTOECM can be dropped -- Table AW$EXPRESS can be dropped -- Table DUAL can be dropped -- Table ODCI_SECOBJ$ can be dropped -- Table ODCI_WARNINGS$ can be dropped -- Table OLAPTABLEVELS can be dropped -- Table OLAPTABLEVELTUPLES can be dropped -- Table PSTUBTBL can be dropped -- Table STMT_AUDIT_OPTION_MAP can be dropped -- Table SYSTEM_PRIVILEGE_MAP can be dropped -- Table TABLE_PRIVILEGE_MAP can be dropped -- Table DEF$_TEMP$LOB can be dropped -- Table HELP can be dropped -- Table WK$CHARSET can be dropped -- Table WK$CRAWLER_CONFIG_DEFAULT can be dropped -- Table WK$LANG can be dropped -- Table WK$MIMETYPES can be dropped -- Table WK$SYS_CONFIG can be dropped -- Table WM$WORKSPACES_TABLE can be dropped -- Table XDB$ACL can be dropped -- Table XDB$ALL_MODEL can be dropped -- Table XDB$ANY can be dropped -- Table XDB$ANYATTR can be dropped -- Table XDB$ATTRGROUP_DEF can be dropped -- Table XDB$ATTRGROUP_REF can be dropped -- Table XDB$ATTRIBUTE can be dropped -- Table XDB$CHOICE_MODEL can be dropped -- Table XDB$COMPLEX_TYPE can be dropped -- Table XDB$ELEMENT can be dropped -- Table XDB$GROUP_DEF can be dropped -- Table XDB$GROUP_REF can be dropped -- Table XDB$SCHEMA can be dropped -- Table XDB$SEQUENCE_MODEL can be dropped -- Table XDB$SIMPLE_TYPE can be dropped
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Oracle sequence created twice. ORA-00955: name is already used by an existing object

    Stack Overflow | 2 years ago
    java.sql.SQLException: ORA-00955: name is already used by an existing object
  6. 0

    Oracle 8. Serializable transactions

    Google Groups | 2 decades ago | Vlad Dutov
    java.sql.SQLException: ORA-08177: can't serialize access for this transaction

    26 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.dbaccess.DBError.throwSqlException()
    2. oracle.jdbc.dbaccess
      DBError.throwSqlException
      1. oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
      1 frame
    3. oracle.jdbc.ttc7
      TTC7Protocol.parseExecuteFetch
      1. oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
      2. oracle.jdbc.ttc7.Oall7.receive(Oall7.java:573)
      3. oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891)
      4. oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093)
      4 frames
    4. Oracle jdbc
      OracleStatement.executeUpdate
      1. oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:2047)
      2. oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1940)
      3. oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2709)
      4. oracle.jdbc.driver.OracleStatement.executeUpdate(OracleStatement.java:796)
      4 frames
    5. test
      Test.main
      1. test.Test.executeUpdate(Test.java:33)
      2. test.Test.main(Test.java:22)
      2 frames