Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2008
    Posts
    1

    Unanswered: ORA-08177: can't serialize access for this transaction

    I am getting the error "com.ibm.db2.jcc.b.SqlException: Unexpected error code "8177" received from data source "DB033". Associated text and tokens are "ORA-08177: can't serialize access for this transaction
    "."---when our application is running by more than one user at same time, when they update/delete a table in the database.

    Can anyone suggest how I will change my java code such that the message will not come and my database updation/deletion will be completed.

  2. #2
    Join Date
    Jan 2004
    Posts
    370
    Rollback the current transaction and execute it again.

    http://download.oracle.com/docs/cd/B...htm#sthref1981

    .

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •