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

Oracle Community | 352935 | 1 decade ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  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

    log4j JDBCAppender with Oracle problem

    Coderanch | 8 years ago | Sagar Kale
    java.sql.SQLException: ORA-01009: missing mandatory parameter
  6. 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

  1. rp 1 times, last 2 months ago
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