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

Oracle Community | 352935 | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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

    index name collision

    Oracle Community | 1 decade ago | 3004
    java.sql.SQLException: ORA-00955: name is already used by an existing object

  1. rp 1 times, last 4 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